C-Sharp

Question

i need in database connection with storedprocedure. i need data insertiondeletion 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