C-Sharp

karthi keyan

i need in database connection with storedprocedure. i need data insertion,deletion, updation, in sqlserver. only c# connection pls help me

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tapan Patel10y ago
Here is how.
SqlConnectionStringBuilder sconnectionbuilder=new SqlConnectionStringBuilder();
SqlConnection connection=new SqlConnection();
sconnectionbuilder.IntegratedSecurity=true;
sconnectionbuilder.DataSource="SQLServer Name";
sconnectionbuilder.InitialCatalog="Database Name";
connection=new SqlConnection(sconnectionbuilder.ConnectionString);
SqlCommandcmd1=new SqlCommand("Procedurename",connection){CommandType=CommandType.StoredProcedure};
cmd1.Parameters.AddWithValue("@parametername","Value"); // if any
connection.Open();
cmd1.ExecuteNonQuery();//you can modify this the way you want for select statements
Please mark it as an answer if it addresses the issue.
Sandeep Singh10y ago
Please see my suggestion below link.
http://www.c-sharpcorner.com/forums/storing-records-in-database-through-csharp
Dennis S21y ago
Please refer to search I made at Microsoft MSDN Search Page about SqlConnection, SqlCommand and SqlDataAdapter. Hope this can help you start.

Link:
http://search.msdn.microsoft.com/search/results.aspx?view=msdn&st=b&na=82&qu=SqlConnection+SqlCommand+SqlDataAdapter

dennis