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(); }