Dim mySqlCommand As New SqlCommand() Dim mySqlDataAdapter As New SqlDataAdapter() mySqlCommand.CommandText = myCommandText mySqlCommand.Connection = SecurityRolesConnection mySqlCommand.Parameters.Add("@EmployeeID", SqlDbType.BigInt) Long.TryParse(idTextBox.Text, myBigInt) mySqlCommand.Parameters("@EmployeeID").Value = myBigInt mySqlCommand.Prepare() mySqlDataAdapter.SelectCommand = mySqlCommand mySqlDataAdapter.Fill(myDataSet) myTableView = myDataSet.Tables(0).DefaultView
CommandType
CommandType.StoredProcedure
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)