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
