VB.Net - SqlCommand

SqlCommand – Sample VB.Net

1
2
3
4
5
6
7
8
9
cmdStoredProc = New SqlCommand("usp_InitialExitTasks_c", conTime)
cmdStoredProc.CommandType = System.Data.CommandType.StoredProcedure
cmdStoredProc.Parameters.AddWithValue("@wfID", e.Command.Parameters("@identity").Value)
cmdStoredProc.Parameters.AddWithValue("@supusername", CType(frmWF.FindControl("dropNewSupv"), DropDownList).SelectedValue)
cmdStoredProc.Parameters.AddWithValue("@username", Session("User"))

conTime.Open()
cmdStoredProc.ExecuteNonQuery()
conTime.Close()