private void btnUpdateData_Click(object sender, EventArgs e) { try { SqlComm = new SqlCommand("UPDATE MyDataTable ('DataDesc', 'DataDate', 'DataQty') VALUES ('@DataDesc', '@DataDate', '@DataQty') WHERE DataID ='@DataID'", SqlConn); SqlComm.Parameters.AddWithValue("@DataID", txtDataID.Text); SqlComm.Parameters.AddWithValue("@DataDesc", txtDataDesc.Text); SqlComm.Parameters.AddWithValue("@DataQty", int.Parse(txtDataQty.Text)); SqlComm.Parameters.AddWithValue("@DataDate", dtpDataDate.Value); SqlComm.ExecuteNonQuery(); MessageBox.Show("Data updated!", "DB Connection With App.Config", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); Clear(); DisableButtons(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
SqlComm = new SqlCommand("UPDATE MyDataTable ('DataDesc', 'DataDate', 'DataQty') VALUES (@DataDesc, @DataDate, @DataQty) WHERE DataID = @DataID", SqlConn);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)