PL:
public void fetchtolabel()//fetch itemcode into label
{
try
{
SqlDataReader sdr;
sdr = objBL.fetchtolabel(this.cmbitemname.GetItemText(this.cmbitemname.SelectedItem));
if (sdr.Read())
{
lblcode.Text = sdr["vaitemcode"].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
BL:
public SqlDataReader fetchtolabel(string vaitemname)//fetch item code to label
{
return objDL.fetchtolabel(vaitemname);
}
DL:
public SqlDataReader fetchtolabel(string vaitemname)//itemcodebindtolabel
{
SqlDataReader sdr;
cmd = new SqlCommand("[selectitemcodetolabel]", con.serverConnection());
cmd.Parameters.AddWithValue("@vaitemname", vaitemname);
cmd.CommandType = CommandType.StoredProcedure;
sdr = cmd.ExecuteReader();
return sdr;
}
No comments:
Post a Comment