private void Find_Doc() { string ls_sql = string.Format( @"Select * FROM bs_productline with(nolock) Where id='{0}' and state<>'2' Select B.*,B.id as origin_id FROM bs_productline A with(nolock), bs_carton_code B with(nolock) Where A.id=B.location_id and A.id='{0}' and A.state<>'2' Order by B.location_id,B.id", txtID.Text); DataSet dts = clsApp.ExcuteSqlReturnDataSet(ls_sql, null); if (dts.Tables[0].Rows.Count > 0) { dtMostly = dts.Tables[0]; if (dtMostly.Rows[0]["part_mrp"].ToString() == "True") { chkpart_mrp.Checked = true; } else { chkpart_mrp.Checked = false; } bds_h.DataSource = dtMostly; dtDetail = dts.Tables[1]; bds_d.DataSource = dtDetail; m_id = txtID.Text; } }