Please send me the coding for connecting sql server database

Question

please send me the coding for connecting sql server with C#

caron judith · Answer

SqlConnection cnn ; connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password" cnn = new SqlConnection(connetionString); try { cnn.Open(); MessageBox.Show ("Connection Open ! "); cnn.Close(); } catch (Exception ex) { MessageBox.Show("Can not open connection ! "); } Full Source.... http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm Caron

Jignesh Trivedi · Answer

hi, Please refer http://androidsharp.blogspot.in/2013/07/createreadupdatedelete-crud-operations.html http://www.novicksoftware.com/Articles/crud-operations-using-sql-server-stored-procedures-part-1.htm http://www.dotnetspark.com/kb/667-crud-operations-using-linq-entities.aspx hope this will help.

Praveen Jeyarajah · Answer

thank you, send me select,update,insert, delete coding for C#

Lakshmanan Sethu Sankaranarayan · Answer

Hi, Please refer this also http://www.c-sharpcorner.com/UploadFile/368e1d/carsportal-1-connecting-to-sql-server-database-in-Asp-Net/ In case you are using latest version of VS.

Jignesh Trivedi · Answer

hi, try string connetionString="Data Source=ServerName; Initial Catalog=DatabaseName;User ID=UserName;Password=Password"; var con = new SqlConnection(connetionString); con.Open(); // do your code Con.Close(); Also refer http://www.codeproject.com/Articles/4416/Beginners-guide-to-accessing-SQL-Server-through-C http://www.daniweb.com/software-development/csharp/threads/339949/how-to-establish-a-connection-with-sql-server-using-c hope this will help you.

Please send me the coding for connecting sql server database

Answers (5)