SQL

[eddie]

hi all out there, im a singaporean student ..currently im doing a c# project.. i need to create a visual studio 2005 windows application that can add delete modify eg sort,filter a database in excel format.However i need to use SQL to link the database to my windows application and i have some problems with SQL. i have read the intro but anybody can tell me how n where to download the sql server and any online resources that can teach me how to link the database with my application .. thanks

[aspnetguy]

There is a link in my si to the free version of sql server 2005 and other dtaabses too.You will need to use the System.Data.SqlCient namespace (for SQL Server):

SqlConnection cnt = new SqlConnection("Connection String");SqlCommand  cmd = new SqlCommand("query",cnt);SqlDataReader data = cmd.ExecuteReader();while(data.Read()){          //do something          somevariable = data["column Name"].ToString();}data.Close();cnt.Close();