DB db = new DB();
string CategoryCode = this.inputLP.Value.Trim();
string cmdstr = "SELECT count(*) FROM [BomCateTec] where CategoryCode='" + CategoryCode + "'";
DataTable dt = db.reDt(cmdstr);
int NowTecall = Convert.ToInt32(dt.Rows[0][0].ToString());
public DataTable reDt(string cmdstr)
{
SqlConnection con =GetCon();
SqlDataAdapter da = new SqlDataAdapter(cmdstr, con);
DataSet ds = new DataSet();
da.Fill(ds);
return (ds.Tables[0]);
}