Search results for query: *

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...

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#?

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.

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

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...

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...

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...

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#.

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.

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...

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...

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...

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.

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...

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...

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...

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...

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?

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...

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...