We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Private Sub StoredProcedureCallDelete() ' PROJECT_DATA - Delete all records with a * belonging to current Project Name ' Dim myConnectionString As String = _ "Data Source=.\SQLExpress;AttachDbFilename=C:\CompanySetup.mdf;Integrated Security=True;User Instance=True;Trusted_Connection=Yes;" Using connection As New SqlClient.SqlConnection(myConnectionString) connection.Open() Using command As New SqlClient.SqlCommand("StoredProcedure1", connection) command.CommandType = CommandType.StoredProcedure ' pass parameter - All records matching this project name will be deleted command.Parameters.Add("@Proj_NameLookUp", SqlDbType.Text).Value = PDF_ML_Form.PDF_Proj_Name_lbl.Text command.ExecuteNonQuery() End Using End Using End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.