C# Sql Connection for windows Application

[dlayante]

I am just new in C#, somebody can you give me code for MS SQL server connection, on how to call records, add, edit and delete records...THANK YOU

[Ramy Mahrous]

To know about connection strings http://connectionstrings.com to know how to play with database read in ADO.NET in http://msdn.com

[zarah_09]

can you give me some sample application on c# application with sql connection?include the codes.. help plz..

[DanielGreen]

Hi!

a simple code for opening a Database-connection

OleDbConnection myConn = new OleDbConnection ( );
try
{
myConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=myData.mdb";
myConn.Open ( );

//do something here
}
catch (Exception ex)
{
 // do exception-handling
}
finally
{
myConn.Close();
}

i hope this helps