what do i need to put after this: strStoredProc = "EXEC p_test_data_entry @claim1 = '" & Me.txt_claim.Text & "'"
so i can get the values of the remaining values?
Code:strStoredProc = "EXEC p_test_data_entry @claim1 = '" & Me.txt_claim.Text & "'" '@refund = '" & Me.DropDownList_refund_type.SelectedItem.Text & "' @reason = '" & Me.DropDownList_reason_overpay.SelectedItem.Text & "'"
Code:Private Sub btn_save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_save.Click Dim strStoredProc As String Dim myConnection As New SqlConnection("data source=AUS-REPORTING;initial catalog=Log;user id=user;password=password") Dim x As String strStoredProc = "EXEC p_test_data_entry @claim1 = '" & Me.txt_claim.Text & "'" '@refund = '" & Me.DropDownList_refund_type.SelectedItem.Text & "' @reason = '" & Me.DropDownList_reason_overpay.SelectedItem.Text & "'" Dim sqlCmd As New SqlClient.SqlCommand(strStoredProc, myConnection) 'Try myConnection.Open() sqlCmd.ExecuteNonQuery() myConnection.Close() 'Catch ' myConnection.Close() 'End Try End Sub




Reply With Quote