private void buyer_detai() { if (Request.QueryString["inv"] != "" && Request.QueryString["inv"] != null) { bl.inv_no = Request.QueryString["inv"].ToString(); int i = Convert.ToInt32(dl.slelct_cut_id_inv(bl)); DataSet ds = new DataSet(); bl.cust_id = i; ds = dl.select_buyerdetail(bl); if (ds.Tables[0].Rows.Count > 0) { lbl_puch_party.Text = ds.Tables[0].Rows[0]["company_name"].ToString(); lbl_puch_add1.Text = ds.Tables[0].Rows[0]["address_1"].ToString(); lbl_puch_add2.Text = ds.Tables[0].Rows[0]["address_2"].ToString(); lbl_puch_city.Text = ds.Tables[0].Rows[0]["city_name"].ToString(); lbl_puch_st.Text = ds.Tables[0].Rows[0]["state_name"].ToString(); lbl_puch_ph.Text = ds.Tables[0].Rows[0]["contact_no"].ToString(); lbl_vat_puch_no.Text = ds.Tables[0].Rows[0]["vat"].ToString(); lbl_puch_cst_no.Text = ds.Tables[0].Rows[0]["cst"].ToString(); lbl_ecc_puch_no.Text = ds.Tables[0].Rows[0]["ecc"].ToString(); } } }