Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: thedougster
  • Order by date
  1. thedougster

    creating threads in C#

    Can someone please break down a simple statement for a relative newbie? Thread firstThread = new Thread (new ThreadStart (Method1)); In other words, what is happening at each stage here: new ThreadStart (Method1) new Thread (new ThreadStart (Method1)) Thread firstThread = new Thread (new...
  2. thedougster

    determining if an SQL database exists, etc.

    hmckillop: Please pardon what I'm sure is a stupid question, but I'm a newbie stumbling around in the dark: Are these SQL queries or VB snippets? If it's VB, do you know where I can find this in C#?
  3. thedougster

    determining if an SQL database exists, etc.

    Could someone please give me the simplest possible C# code snippets / SQL queries to determine whether: * a given SQL database exists, * a given existing SQL database is accessible, and * a given table exists within a given existing SQL database? Thanks for whatever help anyone can provide.
  4. thedougster

    the Brigadoon of databases

    markros: >I suspect the database got somehow detached and you had to >attach it again. Sounds plausible. How do I do that?
  5. thedougster

    the Brigadoon of databases

    I've been working with SQL2008 AdventureWorks; specifically database AdventureWorks, table Person.Contact. I experimented with using a DataGrid control's DataSource property to add a new project data source to the DataGrid, although my code was written to access the database without using a...
  6. thedougster

    help with BindingSources

    I need some help with BindingSources (in C#). This is what I'm working on: From the C# tutorial at Programmer's Heaven (http://www.programmersheaven.com/2/Les_CSharp_13_p9): private void btnLoadData_Click(object sender, System.EventArgs e) { string connectionString = "server=P-III...
  7. thedougster

    help with BindingSources

    I need some help with BindingSources. This is what I'm working on: From the C# tutorial at Programmer's Heaven (http://www.programmersheaven.com/2/Les_CSharp_13_p9): private void btnLoadData_Click(object sender, System.EventArgs e) { string connectionString = "server=P-III...
  8. thedougster

    where's the dgDetails class?

    I've tried, but I haven''t been able to find the namespace containing the dgDetails class for the DataGridView control. Can anybody tell me where it is? BTW, this is for C#.
  9. thedougster

    proper Save location for SQL stored procedures

    Thanks everybody, problem solved. It turns out that although I had been told to save stored procedures via Ctrl-F5, it's actually F5. Again, thanks to all.
  10. thedougster

    proper Save location for SQL stored procedures

    That's EXACTLY what I'm doing. When I try to create a stored procedure again, SSMS says it's already in the database. When I load it into a query window and run it, it runs. When I try to run it from another query window or from an app, it can't be found. When I look for it in the Stored...
  11. thedougster

    proper Save location for SQL stored procedures

    I saved a few stored procedures in SQL Server Management Studio. The default Save location, which I accepted, was C:\Documents and Settings\BobLewiston\My Documents\SQL Server Management Studio\Projects. (And yes, each stored procedure was in the form of an .sql file, and I assigned each file...
  12. thedougster

    how to “store” stored procedures

    I've written a few SQL stored procedures in a text editor. But how do I actually "store" them in (add them to?) a database using SQL Server 2008 Management Studio Express? I've tried to research this topic in Management Studio's onboard Help, but apparently Help assumes I know more about the...
  13. thedougster

    dataAdapter.Update / SQL PasswordHash NULL problem

    mrdenny: I disabled the setting which prevents SSMS from making changes. I actually had to do this for column PasswordSalt as well as column PasswordHash. It works! Thanks a lot.
  14. thedougster

    dataAdapter.Update / SQL PasswordHash NULL problem

    mrdenny: Thanks, I'll try it. As I had said: As I had said: I'm not saying I disagree with you that I can throw any valid string in there, I just don't understand what this column is really for. As I had said: So for whatever reason, it WON'T allow me to put ANY value in there. I will...
  15. thedougster

    dataAdapter.Update / SQL PasswordHash NULL problem

    Some of you may have seen my earlier thread “PasswordHash NULL problem”. I’ve started a new thread because investigation has shown that the problem is actually quite different than I previously stated. Also please note that this is unrelated to another of my previous threads, “dataAdapter.Update...
  16. thedougster

    How do I get PasswordHash value?

    mrdenny: I'm in the dark about this whole PasswordHash business. Why do individual rows in a database table have different password hashes? Isn't the password for the whole database? Please expand on this briefly, and tell me how to use HASHBYTES. Yes, I'll research it tomorrow (it's now LATE...
  17. thedougster

    PasswordHash NULL problem

    When I try to save a new (inserted) record in an SQL database, I get the following System.Runtime.InteropServices.ExternalException message: I have to either find out how to insert an appropriate value into the PasswordHash column OR make SQL Server Management Studio allow NULL in the...
  18. thedougster

    displaying an auto-incremented SQL identity column

    sqlfable: >If this identity is not going to become a strength in you >relational integrity by forming it as a key, then ...Use >row_number() if the intention is a simplistic task such as >unicity. What more is involved in using the identity column as a key than mere unicity?
  19. thedougster

    How do I get PasswordHash value?

    When I try to save a new (inserted) record via the following code: DataRow row = dataTable.Rows [currRec]; // update data in DataSet from data entry WinForm row.BeginEdit (); row ["Title"] = txtTitle.Text; row ["FirstName"] = txtFirstName.Text; row ["MiddleName"] = txtMiddleName.Text...
  20. thedougster

    displaying an auto-incremented SQL identity column

    Most databases have multiple users. For these databases it is a good idea to auto-increment the identity column. I understand that an SQL identity column is not incremented until the newly-created record is inserted. I guess this means the identity column is incremented when you actually...

Part and Inventory Search

Back
Top