linking SQL database with C# problem

[Siten0308]

Hello,

I am finally back, i got a huge problem after installing vista SP1, dont install it, worst mistake ever, after installing it my computer crashed beyond recover, so after i reinstalled vista, installed C# sdk with sql 2005 express, now everything works, i am able to import all database and everything, the problem i am guessing is when i installed C# sdk, i did not install SQL with it, probably a tool to help link between the two, and later installed SQL 2005 standard edition without that link they dont know each other, no matter how much you try and point to each other, without installing SQL with C# package, it wont work, so let it be known, when installed C#, include everything!! i am fixed now thanks for everyones input and help.

[Xav]

Yay!

[Pancrazio]

Are you sure it wasn't just a bad connectionstring? I advice you to (learn how to) add new connections manually. It's not difficult. It's might be a bit more difficult to add data to webcontrols (if that's what you're doing), but once you understand the code and wrote it once you can just edit it for future uses. There are good tutorials for this online.

[Siten0308]

can you give me an example pancrazio for future reference? maybe i will disconnect my database to my program to try it out.

[Pancrazio]

I'm not an expert and it's been more than a year since I've used C# (needed it for school) but if I remember correctly it goes something like this using SQL server:

using System.Data.SqlClient; //Namespace

SqlConnection conn = new SqlConnection(
"server=myservername;database=mydatabasename;uid=m yusername;pwd=mypassword"); /* defining a SQL connection named 'conn' with the correct servername, databasename, userid and password. The thing between brackets is the connection string, there is a whole website somewhere about nothing but the connectionstring. */
conn.Open(); // open the connection
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select x from x where x";//Using your SQL command
cmd.Connection = conn;
string Result = (string)cmd.ExecuteScalar(); //Put the result in a string named Result
Console.Writeline(Result); //Writes it in the console
conn.Close(); // close the connection

For multiple results you can use SqlDataReader.

The framework database programming classes are referred to as ADO.NET . Look ok the internet for ADO.NET tutorials. Programming is all about managing and manipulating data, so if it's your ambition to develop professional web applications using C# and .NET for, you need to learn this stuff.

If you don't know how to use SQL commands, you should learn that too.
SQL Tutorial - Learn SQL is the website I learned it from.