Dim cmd As New SqlCommand cmd.CommandText = "UPDATE tblPersonnel SET @Date,@FirstName,@LastName,@CaseNumber,@CaseResult,@PhotoName WHERE ImageID='" + Trim(comID.Text) + "')" cmd.CommandType = CommandType.Text cmd.Connection = conn cmd.Parameters.Add("@Date", SqlDbType.Date).Value = Format(DateInput.Value, "M/dd/yyyy") cmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = comFirstName.Text cmd.Parameters.Add("@LastName", SqlDbType.VarChar).Value = comLastName.Text cmd.Parameters.Add("@CaseNumber", SqlDbType.VarChar).Value = comboCaseNumber.Text cmd.Parameters.Add("@CaseResult", SqlDbType.VarChar).Value = comboResult.Text cmd.Parameters.Add("@PhotoName", SqlDbType.VarChar).Value = textboxImageName.Text cmd.ExecuteNonQuery()
int
string
"UPDATE tblPersonnel SET @Date,@FirstName,@LastName,@CaseNumber,@CaseResult,@PhotoName WHERE ImageID= '" + Trim(comID.Text) + "')"
ImageID = int.Parse(Trim(comID.Text));
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)