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(); }
void fillGrid_opening() { string distid = ddl_dist.SelectedValue; string issueid = ddl_IC.SelectedValue; string gdwnId = ddlgodown.SelectedValue; string qrychk = "select issue_opening_balance.District_Id as DistiD,issue_opening_balance.Depotid as depid,issue_opening_balance.Godown,issue_opening_balance.Source,issue_opening_balance.Scheme_Id,issue_opening_balance.Commodity_Id,convert(decimal(18,5),issue_opening_balance.Current_Balance) as Current_Balance ,issue_opening_balance.Current_Bags,convert(decimal(18,5),issue_opening_balance.Quantity) as Quantity ,issue_opening_balance.Bags,tbl_MetaData_GODOWN.Godown_Name,tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name ,tbl_MetaData_SCHEME.Scheme_Name as Scheme_Name,Source_Arrival_Type.Source_Name as Source_Name ,Current_Godown_Position.Month, Current_Godown_Position.Year from dbo.issue_opening_balance left join dbo.tbl_MetaData_STORAGE_COMMODITY on issue_opening_balance.Commodity_Id=tbl_MetaData_STORAGE_COMMODITY .Commodity_Id left join dbo.tbl_MetaData_SCHEME on issue_opening_balance.Scheme_Id =tbl_MetaData_SCHEME.Scheme_Id left join dbo.Source_Arrival_Type on issue_opening_balance.Source=Source_Arrival_Type.Source_ID left join dbo.tbl_MetaData_GODOWN on issue_opening_balance.Godown=tbl_MetaData_GODOWN.Godown_ID left join Current_Godown_Position on issue_opening_balance.Godown=Current_Godown_Position.Godown where issue_opening_balance.District_Id='" + distid + "'and issue_opening_balance.Depotid='" + issueid + "' and Godown='" + gdwnId + "'"; mobj = new MoveChallan(ComObj); DataSet dschk = mobj.selectAny(qrychk); if (dschk == null) { } else { if (dschk.Tables[0].Rows.Count > 0) { GridView_opn.DataSource = dschk.Tables[0]; GridView_opn.DataBind(); } else { GridView_opn.DataSource = null; GridView_opn.DataBind(); } } }