C-Sharp

Question

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

Tapan Patel · Answer

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 Singh · Answer

Please see my suggestion below link. http://www.c-sharpcorner.com/forums/storing-records-in-database-through-csharp

Dennis S · Answer

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

C-Sharp

Answers (3)