private void btnModify_Click(object sender, EventArgs e)
{
frmId fd = new frmId();
fd.ShowDialog();
string id_search = fd.id.ToString();
SqlConnection con = connection.OpenConnection();
SqlCommand cmd = new SqlCommand("SELECT * from [dbo].[TblItem] where [ItmOrdinary]=@ItmOrdinary", con);
cmd.Parameters.AddWithValue("@ItmOrdinary", id_search);
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataTable dtRecord = new DataTable();
adap.Fill(dtRecord);
SqlDataReader rdr = cmd.ExecuteReader();
using (rdr)
if (rdr.Read())
{
txtProductCode.Text = (rdr["ItmOrdinary"].ToString());
txtProductName.Text = (rdr["ItmName"].ToString());
con.Close();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
frmId fd = new frmId();
fd.ShowDialog();
string id_search = fd.id.ToString();
SqlConnection con = connection.OpenConnection();
SqlCommand cmd = new SqlCommand("SELECT * from [dbo].[TblItem] where [ItmOrdinary]=@ItmOrdinary", con);
cmd.Parameters.AddWithValue("@ItmOrdinary", id_search);
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataTable dtRecord = new DataTable();
adap.Fill(dtRecord);
txtBarcode.Text = dtRecord.ToString();
}
