private void clearData() { btn_del.Enabled = false; Panel1.Visible = false; // cleargrid dgrid_Proc.DataSource = null; dgrid_Proc.DataBind(); GridView_other.DataSource = null; GridView_other.DataBind(); GridView_opn.DataSource = null; GridView_opn.DataBind(); GridView_Iado.DataSource = null; GridView_Iado.DataBind(); GridView_trck_chn.DataSource = null; GridView_trck_chn.DataBind(); }
private void fillgridOther() { string did = ddl_dist.SelectedValue; string depid = ddl_IC.SelectedValue; string gid = ddlgodown.SelectedValue; mobj = new MoveChallan(ComObj); string qry = "SELECT tbl_Receipt_Details.Godown as Godown, tbl_Receipt_Details.challan_no, tbl_Receipt_Details.challan_date,tbl_Receipt_Details.Vehile_no,tbl_Receipt_Details.Receipt_Id,tbl_Receipt_Details.S_of_arrival,Source_Arrival_Type.Source_Name as Source_Name FROM dbo.tbl_Receipt_Details left join dbo.Source_Arrival_Type on tbl_Receipt_Details.S_of_arrival= Source_Arrival_Type.Source_ID where Dist_Id='" + did + "' and Depot_ID='" + depid + "' and Godown='" + gid + "' order by Order by challan_date desc"; DataSet ds = mobj.selectAny(qry); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { GridView_other.DataSource = ds.Tables[0]; GridView_other.DataBind(); } else { GridView_other.DataSource = null; GridView_other.DataBind(); } } else { GridView_other.DataSource = null; GridView_other.DataBind(); } }