private void cuni_detai() { if (Request.QueryString["inv"] != "" && Request.QueryString["inv"] != null) { bl.inv_no = Request.QueryString["inv"].ToString(); string i = Convert.ToString(dl.slelct_cuni_nm_inv(bl)); DataSet ds = new DataSet(); bl.ship = i; ds = dl.select_cunidetail(bl); if (ds.Tables[0].Rows.Count > 0) { lbl_cuni_nm.Text = ds.Tables[0].Rows[0]["company_name"].ToString(); lbl_cuni_add1.Text = ds.Tables[0].Rows[0]["address_1"].ToString(); lbl_cuni_add2.Text = ds.Tables[0].Rows[0]["address_2"].ToString(); lbl_cuni_ct.Text = ds.Tables[0].Rows[0]["city_name"].ToString(); lbl_cuni_st.Text = ds.Tables[0].Rows[0]["state_name"].ToString(); lbl_cuni_ph.Text = ds.Tables[0].Rows[0]["contact_no"].ToString(); lbl_cuni_vat.Text = ds.Tables[0].Rows[0]["vat"].ToString(); lbl_cuni_cst.Text = ds.Tables[0].Rows[0]["cst"].ToString(); lbl_cuni_ecc.Text = ds.Tables[0].Rows[0]["ecc"].ToString(); } } }