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 selectupdateinsert delete coding for C#

Lakshmanan Sethu · 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.