01.
sb.Remove(0, sb.Length);
02.
sb.Append(
"SELECT Product_code,Product_name,Product_pricep,Product_pricem"
);
03.
sb.Append(
"FROM Product"
);
04.
sb.Append(
"WHERE ( Product_code =@Product_code )"
);
05.
06.
string
sqlProduct = sb.ToString();
07.
08.
09.
DataTable dt;
10.
com.CommandType = CommandType.Text;
11.
com.CommandText = sqlProduct;
12.
com.Parameters.Clear();
13.
com.Parameters.Add(
"@Product_code"
, SqlDbType.NVarChar).Value =textBoxcodeproduct.Text;
14.
com.Connection = Conn;
15.
dr = com.ExecuteReader();
16.
if
(dr.HasRows)
17.
{
18.
dt =
new
DataTable();
19.
dt.Load(dr);
20.
textBoxcodeproduct.Text = dt.Rows[0][
"Product_code"
].ToString();
21.
label7.Text = dt.Rows[0][
"Product_name"
].ToString();
22.
label8.Text = dt.Rows[0][
"Product_pricep"
].ToString();
23.
label9.Text = dt.Rows[0][
"Product_pricem"
].ToString();
24.
25.
26.
27.
}