Can anybody recommend good online courses for SQL and/or data controls? (I guess I should master the regular data controls before going on to Silverlight, right?)

Can anybody recommend good online courses for SQL and/or data controls? (I guess I should master the regular data controls before going on to Silverlight, right?)

Hi, everybody. I've been studying C# (using Visual C# 2008 Express) for several months and I think I've got the basics down pretty well at this point, so now I want to create a moderately ambitious...

Thanks a lot, guys.

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

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

JerryShaw :



Yes, the problem arose when I experimented (once) with the Data Source Configuration Wizard in Visual C# 2008 Express (accessed via the DataSource property in the Properties window...

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

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

JerryShaw:

Thanks for your reply.

I'm a newbie, so I'm not familiar with BindingSources.

Could you please tell me what I need to include in my code to get the compiler to recognize the...

JerryShaw:

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

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, problem solved. It turns out that although I had been told to save stored procedures via Ctrl-F5, it's actually F5. Again, thanks.

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

dickersonka:

Thanks for your help.

One question: don't I have to associate a procedure with a given table? Otherwise, how will the procedure recognize the column names?

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

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

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

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

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

Using Visual C# 2008 Express and SQL Server 2008 Express, I would like to insert new records into database "AdventureWorks", table "Person.Contact".

To my surprise, this table's int-value identity...

On the off-chance that this will help, this is the exact kind of exception that's occurring:

System.Runtime.InteropServices.ExternalException

Are there any other properties of the Exception...

I can read in an SQL table ("Person.Contact") from AdventureWorks and step through it one row at a time, but when I try to save a record, either one I'm inserting or one I'm editting, I get the...

I'm starting to learn SQL Server. As part of that effort, I'm experimenting with accessing AdventureWorks sample databases.

In database AdventureWorks, I've been accessing table Person.Contact....

I’m trying to learn how to connect to an SQL Server database (I’m using the AdventureWorks sample database), but I’m having problems.

Here’s the code I’m using:

// define connection string for...

I meant copying the folder, with all its contents, for the entire solution. This folder contains the .sln & .suo files and the project folder. Such folders are subfolders of C:\Documents and...

serkan sendur:

Have you actually tried this? I would have to give the new solution a different name than the old one, and then the name of the copied project would be different than the solution...

Is there any way to copy an entire Visual C# solution in such a way that it works? If you just copy it and rename it, it gives an error message that it's been renamed and therefore it refuses to work.

How can I uninstall the AdventureWorks sample databases? They're not an application, so I can't do it via Add / Remove Programs or a downloaded uninstaller.

They're apparently corrupt, and they've...

Assuming it can be done (as I've been told):

How do I import ".mdb" (MS Access / OleDb) files (specifically, Northwind sample database files) into SQL Server 2008 (Express with Advanced Features)?

I've installed SQL Server 2008 Express with Advanced Features, but I've been having so-far insurmountable problems installing the AdventureWorks sample databases. However, I've successfully installed...

After some initial problems with the prerequisite installation of SQL Server Express with Advanced Features, I tried to install AdventureWorks sample databases.

Upon launch of the installer,...

I heard of a sample database called Pub. Does anyone know about it? Is it an SQL Server sample database that, unlike AdventureWorks, doesn't require SQL Server's Full-text Search capability to...

I tried SQL Server 2008 Enterprise 180-day evaluation version - same result.

I've got a 32-bit machine (Pentium 4) running Windows XP Pro (version 2002). I understand that there are 32- and 64-bit versions of Windows XP Pro, and that some 64-bit versions of XP Pro will run on...

Windows XP Pro is a 32-bit op sys, right?

I installed SQL Server 2008 Express, basic edition (SQLEXPR32_x86_ENU_Bootstrapper.exe, version 9.0.30729.1) without any problem.

Then I attempted to install AdventureWorks Sample Databases for...

I've got a Pentium 4 machine - the exact architecture is GenuineIntel x86 family 15 model 2 stepping 7. (I'm running Windows XP Pro, version 2002, Service Pack 3 with no problem.) This is a 32-bit...

I did a full installation of SQL Server 2008 Express. Looking at Add / Remove Programs, I see the following pertinent programs installed:
SQL Server 2008
SQL Server 2008 Browser
SQL Server 2008...

Geek-Master:

services.msc shows:

SQL Active Directory Helper Service
SQL Server (SQLEXPRESS)
SQL Server Agent (SQLEXPRESS)
SQL Server Browser
SQL Server VSS Writer