void fillgrid() { mobj = new MoveChallan(ComObj); string qry = "SELECT SCSC_Procurement.*,tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name,Society.Society_Name +','+ SocPlace +',' + Society_Id as PurchaseCenterName FROM dbo.SCSC_Procurement left join dbo.tbl_MetaData_STORAGE_COMMODITY on SCSC_Procurement.Commodity_Id=tbl_MetaData_STORAGE_COMMODITY .Commodity_Id left join dbo.Society on SCSC_Procurement.Purchase_Center= Society.Society_Id where IssueCenter_ID='" + sid + "' order by SCSC_Procurement.Recd_date desc"; DataSet ds = mobj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { Label1.Visible = true; Label1.Text = "Currently no Record is present"; } else { dgridchallan.DataSource = ds.Tables[0]; dgridchallan.DataBind(); } }
void fillgrid() { mobj = new MoveChallan(ComObj); string qry = "SELECT * FROM dbo.SCSC_Truck_challan where Dist_ID='" + distid + "' and Depot_Id='" + sid + "' and Challan_No not like '%NoChallan%' "; DataSet ds = mobj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { lbldisp.Visible = true; lbldisp.Text = "No Record Present"; } else { dgridchallan.DataSource = ds.Tables[0]; dgridchallan.DataBind(); } }
void GetName() { mobj = new MoveChallan(ComObj); string qry1dt = "select district_name from pds.districtsmp where district_code='" + distid + "'"; DataSet ds1dt = mobj.selectAny(qry1dt); DataRow dr1dt = ds1dt.Tables[0].Rows[0]; Label3.Text = dr1dt["district_name"].ToString(); mobj = new MoveChallan(ComObj); string qryissue = "select DepotName from dbo.tbl_MetaData_DEPOT where DepotID='" + issueid + "'"; DataSet dsic = mobj.selectAny(qryissue); DataRow dric = dsic.Tables[0].Rows[0]; Label4.Text = dric["DepotName"].ToString(); }
void GetBank() { mobj2 = new MoveChallan(ComObj); string qrybank = "select Bank_ID,Bank_Name from dbo.Bank_Master where district_code='" + distid + "' and issueCenter_code='" + distid + "'"; DataSet dsb = mobj2.selectAny(qrybank); ddlbankname.DataSource = dsb.Tables[0]; ddlbankname.DataTextField = "Bank_Name"; ddlbankname.DataValueField = "Bank_ID"; ddlbankname.DataBind(); ListItem lst = new ListItem(); lst.Text = "--Select--"; lst.Value = "NA"; ddlbankname.Items.Insert(0, lst); }
void fillgrid() { mobj = new MoveChallan(ComObj); string qry = "SELECT * FROM dbo.Lift_A_RO where Dist_Id='" + distid + "' and RO_No not like '%NoRO%'"; DataSet ds = mobj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { lbldisp.Visible = true; lbldisp.Text = "Currently No Record Found"; } else { dgridchallan.DataSource = ds.Tables[0]; dgridchallan.DataBind(); } }
public void GetGodown() { try { mobj = new MoveChallan(ComObj); string qry = "SELECT * FROM dbo.tbl_MetaData_GODOWN where DistrictId='" + distid + "' and DepotId='" + issueid + "' order by Godown_ID"; DataSet ds = mobj.selectAny(qry); ddlgodown.DataSource = ds.Tables[0]; ddlgodown.DataTextField = "Godown_Name"; ddlgodown.DataValueField = "Godown_ID"; ddlgodown.DataBind(); ddlgodown.Items.Insert(0, "--Select--"); } catch (Exception) { } }
public void GetSource() { try { mobj = new MoveChallan(ComObj); string qry = "SELECT * FROM dbo.Source_Arrival_Type order by Source_ID"; DataSet ds = mobj.selectAny(qry); ddlsarrival.DataSource = ds.Tables[0]; ddlsarrival.DataTextField = "Source_Name"; ddlsarrival.DataValueField = "Source_ID"; ddlsarrival.DataBind(); ddlsarrival.Items.Insert(0, "--Select--"); } catch (Exception) { } }
protected void btnUpdate_Click(object sender, EventArgs e) { string mbankname = txtbankname.Text; mobj = new MoveChallan(ComObj); string qreygodn = "select * from dbo.Bank_Master where District_Code='" + distid + "'and issueCenter_code='" + issueid + "' and Bank_Name='" + mbankname + "'"; DataSet dsgodn = mobj.selectAny(qreygodn); if (dsgodn == null) { } else { if (dsgodn.Tables[0].Rows.Count == 0) { string bank_id = GridView1.SelectedRow.Cells[1].Text; string bname = txtbankname.Text; string Update = "Update dbo.Bank_Master set Bank_Name='" + bname + "'where District_Code='" + distid + "' and issueCenter_code='" + issueid + "'and Bank_ID='" + bank_id + "'"; cmd.Connection = con; cmd.CommandText = Update; try { con.Open(); cmd.ExecuteNonQuery(); Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Data Updated Successfully.....'); </script> "); btnsubmit.Enabled = false; } catch (Exception ex) { Label1.Text = ex.Message; } finally { con.Close(); ComObj.CloseConnection(); } } else { Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Bank Name Already Exist.....'); </script> "); btnupdate.Enabled = false; } } }
protected void ddlStates_SelectedIndexChanged(object sender, EventArgs e) { if (ddlStates.SelectedItem.Text != "Madhya Pradesh") { ddldesdistt.DataSource = ""; ddldesdistt.DataBind(); mobj = new MoveChallan(ComObj); string qrydist = "SELECT district_code,district_name FROM OtherState_DistrictCode where State_Id = '" + ddlStates.SelectedValue + "'"; DataSet dsd = mobj.selectAny(qrydist); ddldesdistt.DataSource = dsd.Tables[0]; ddldesdistt.DataTextField = "district_name"; ddldesdistt.DataValueField = "district_code"; ddldesdistt.DataBind(); ddldesdistt.Items.Insert(0, "--Select--"); lblrailhead.Visible = true; txtrailhead.Visible = true; lblsenddist.Visible = false; ddldesrailhead.Visible = false; } else { ddldesdistt.DataSource = ""; ddldesdistt.DataBind(); mobj = new MoveChallan(ComObj); string qrydist = "select district_name,district_code from pds.districtsmp order by district_name "; DataSet dsd = mobj.selectAny(qrydist); ddldesdistt.DataSource = dsd.Tables[0]; ddldesdistt.DataTextField = "district_name"; ddldesdistt.DataValueField = "district_code"; ddldesdistt.DataBind(); ddldesdistt.Items.Insert(0, "--Select--"); lblrailhead.Visible = false; txtrailhead.Visible = false; lblsenddist.Visible = true; ddldesrailhead.Visible = true; } }
void GetBalance() { string mcomdtyid = ddlcomdty.SelectedValue; //string mcatid = ddlcategory.SelectedValue; string mscheme = ddlscheme.SelectedValue; string godown = ddlgodown.SelectedValue; string msource = lblsource.Text; mobj1 = new MoveChallan(ComObj); string qry = "Select Round(Current_Balance,2) as Current_Balance,Current_Bags from dbo.issue_opening_balance where District_Id='" + distid + "'and Depotid='" + issueid + "'and Commodity_Id='" + mcomdtyid + "'and Scheme_Id='" + mscheme + "' and Godown='" + godown + "'and Source='" + msource + "'"; DataSet ds = mobj1.selectAny(qry); if (ds == null) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('There is No opening for selected Comodity/Scheme....'); </script> "); lblbqty.Visible = false; txtbqty.Visible = false; } else { if (ds.Tables[0].Rows.Count == 0) { txtbqty.Text = "0"; txtcurbags.Text = "0"; lblbqty.Visible = true; txtbqty.Visible = true; txtbqty.BackColor = System.Drawing.Color.Wheat; txtcurbags.Visible = true; txtcurbags.BackColor = System.Drawing.Color.Wheat; txtbqty.ReadOnly = true; } else { DataRow dr = ds.Tables[0].Rows[0]; txtbqty.Text = dr["Current_Balance"].ToString(); txtcurbags.Text = dr["Current_Bags"].ToString(); lblbqty.Visible = true; txtbqty.Visible = true; txtbqty.BackColor = System.Drawing.Color.Wheat; txtcurbags.Visible = true; txtcurbags.BackColor = System.Drawing.Color.Wheat; txtbqty.ReadOnly = true; } } }
void GetRackDetails() { string qryr = "select Rack_Receipt_Bulk.Rack_No,Rack_Receipt_Bulk.district_code,districtsmp.district_name,Recd_RailHead,tbl_Rail_Head.RailHead_Name from Rack_Receipt_Bulk left join pds.districtsmp on districtsmp.district_code=Rack_Receipt_Bulk.district_code left join dbo.tbl_Rail_Head on Rack_Receipt_Bulk.Recd_RailHead=tbl_Rail_Head.RailHead_Code where Sending_District='" + distid + "' and Rack_No='" + txtrackno.Text + "'"; mobj = new MoveChallan(ComObj); DataSet dsrac = mobj.selectAny(qryr); if (dsrac == null) { } else { if (dsrac.Tables[0].Rows.Count == 0) { lbltctrackno.Visible = true; txtrackno.Visible = true; ddldesrailhead.Enabled = true; ddldesdistt.Enabled = true; GetDist(); GetDestRH(); } else { lbltctrackno.Visible = false; txtrackno.Visible = false; DataRow drrack = dsrac.Tables[0].Rows[0]; ddldesdistt.SelectedValue = drrack["district_code"].ToString(); ddldesdistt.Enabled = false; mobj = new MoveChallan(ComObj); string qrydrh = "select RailHead_Code,RailHead_Name from dbo.tbl_Rail_Head where district_code='" + drrack["district_code"].ToString() + "'"; DataSet dsdh = mobj.selectAny(qrydrh); ddldesrailhead.DataSource = dsdh.Tables[0]; ddldesrailhead.DataTextField = "RailHead_Name"; ddldesrailhead.DataValueField = "RailHead_Code"; ddldesrailhead.DataBind(); ddldesrailhead.Items.Insert(0, "--Select--"); ddldesrailhead.SelectedValue = drrack["Recd_RailHead"].ToString(); ddldesrailhead.Enabled = false; } } }
void GetSeason() { mobj = new MoveChallan(ComObj); string qryms = "select * from dbo.Marketing_Season"; DataSet dsms = mobj.selectAny(qryms); if (dsms == null) { } else { ddlmseason.DataSource = dsms.Tables[0]; ddlmseason.DataTextField = "Season_Name"; ddlmseason.DataValueField = "Season_Id"; ddlmseason.DataBind(); ddlmseason.Items.Insert(0, "--Select--"); } }
void GetSource() { mobj = new MoveChallan(ComObj); string qrygs = "SELECT * FROM dbo.Source_Arrival_Type where Source_Id in (01,03) order by Source_ID"; DataSet ds = mobj.selectAny(qrygs); if (ds == null) { } else { ddlsource.DataSource = ds.Tables[0]; ddlsource.DataTextField = "Source_Name"; ddlsource.DataValueField = "Source_ID"; ddlsource.DataBind(); ddlsource.Items.Insert(0, "--Select--"); } }
void GetScheme() { mobj = new MoveChallan(ComObj); string qrysch = "SELECT * FROM dbo.Purchase_Pool Order By Scheme_ID"; DataSet ds = mobj.selectAny(qrysch); if (ds == null) { } else { ddlscheme.DataSource = ds.Tables[0]; ddlscheme.DataTextField = "Scheme_Name"; ddlscheme.DataValueField = "Scheme_Id"; ddlscheme.DataBind(); ddlscheme.Items.Insert(0, "--Select--"); } }
void GetState() { mobj = new MoveChallan(ComObj); string qryms = "select * from dbo.State_Master order by State_Name "; DataSet dsms = mobj.selectAny(qryms); if (dsms == null) { } else { ddlstate.DataSource = dsms.Tables[0]; ddlstate.DataTextField = "State_Name"; ddlstate.DataValueField = "State_Code"; ddlstate.DataBind(); ddlstate.Items.Insert(0, "--Select--"); } }
void GetDispatchType() { mobj = new MoveChallan(ComObj); string qryd = "SELECT * FROM DispatchType"; DataSet dsd = mobj.selectAny(qryd); if (dsd.Tables[0].Rows.Count == 0) { } else { ddldispatchtype.DataSource = dsd.Tables[0]; ddldispatchtype.DataTextField = "DispatchName"; ddldispatchtype.DataValueField = "DispatchId"; ddldispatchtype.DataBind(); } }
void GetRackRecdQty() { mobj = new MoveChallan(ComObj); string qreyrq = "select Rack_RecdQty,Rack_Qty,Rack_RecdDate from dbo.Rack_Receipt_Bulk where district_code='" + distid + "' and Rack_No='" + rackno + "'"; DataSet ds = mobj.selectAny(qreyrq); if (ds.Tables[0].Rows.Count == 0) { } else { DataRow drs = ds.Tables[0].Rows[0]; txtrackqty.Text = drs["Rack_Qty"].ToString(); txtrecdqty.Text = drs["Rack_RecdQty"].ToString(); DaintyDate1.Text = getdate(drs["Rack_RecdDate"].ToString()); txtissqty.ReadOnly = true; } }
protected void Button6_Click(object sender, EventArgs e) { string comdty = ddlcomdty.SelectedValue; string scheme = ddlscheme.SelectedValue; string distid = ddldistrict.SelectedValue; string issueid = ddlissue.SelectedValue; string source = ddlsarrival.SelectedValue; int mmonth = int.Parse(ddl_allot_month.SelectedValue); int myear = int.Parse(ddd_allot_year.SelectedValue); string qrystock = "select Sum(Quantity) as Qty from dbo.State_Scheme_Transfer where Commodity_Id='" + comdty + "'and S_Scheme_Id='" + scheme + "' and District_Id='" + distid + "'and Depotid='" + issueid + "' and Month=" + mmonth + "and Year=" + myear; mobj = new MoveChallan(ComObj); DataSet dspro = mobj.selectAny(qrystock); if (dspro.Tables[0].Rows.Count == 0) { txtgetscheme.Text = "0"; } else { DataRow drop = dspro.Tables[0].Rows[0]; txtgetscheme.Text = CheckNull(drop["Qty"].ToString()).ToString(); } //// string qrystockdest = "select Sum(Quantity) as Qty from dbo.State_Scheme_Transfer where Commodity_Id='" + comdty + "'and D_Scheme_Id='" + scheme + "' and District_Id='" + distid + "'and Depotid='" + issueid + "' and Month=" + mmonth + "and Year=" + myear; mobj = new MoveChallan(ComObj); DataSet dsprod = mobj.selectAny(qrystockdest); if (dspro.Tables[0].Rows.Count == 0) { txtrecdScheme.Text = "0"; } else { DataRow drop = dsprod.Tables[0].Rows[0]; txtrecdScheme.Text = CheckNull(drop["Qty"].ToString()).ToString(); } }
protected void ddlstate_SelectedIndexChanged(object sender, EventArgs e) { if (con.State == ConnectionState.Closed) { con.Open(); } if (ddlstate.SelectedItem.Text != "Madhya Pradesh") { ddldistrict.DataSource = ""; ddldistrict.DataBind(); mobj = new MoveChallan(ComObj); string qrydist = "SELECT district_code,district_name FROM OtherState_DistrictCode where State_Id = '" + ddlstate.SelectedValue + "'"; DataSet dsd = mobj.selectAny(qrydist); ddldistrict.DataSource = dsd.Tables[0]; ddldistrict.DataTextField = "district_name"; ddldistrict.DataValueField = "district_code"; ddldistrict.DataBind(); ddldistrict.Items.Insert(0, "--Select--"); } else { ddldistrict.DataSource = ""; ddldistrict.DataBind(); mobj = new MoveChallan(ComObj); string qrydist = "select district_name,district_code from pds.districtsmp order by district_name "; DataSet dsd = mobj.selectAny(qrydist); ddldistrict.DataSource = dsd.Tables[0]; ddldistrict.DataTextField = "district_name"; ddldistrict.DataValueField = "district_code"; ddldistrict.DataBind(); ddldistrict.Items.Insert(0, "--Select--"); } if (con.State == ConnectionState.Open) { con.Close(); } }
void fillgrid() { mobj = new MoveChallan(ComObj); string qry = "SELECT RO_of_FCI.*,districtsmp.district_name from dbo.RO_of_FCI left join pds.districtsmp on RO_of_FCI.Distt_Id=districtsmp.district_code where RO_of_FCI.IsExpire='Y' and RO_of_FCI.Distt_Id='" + distid + "' and RO_of_FCI.RO_No='" + rono + "'"; DataSet ds = mobj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { lblmsg.Visible = true; lblmsg.Text = "No Record Present Currently"; } else { lblmsg.Visible = false; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); GridView1.Columns[0].Visible = false; } }
void GetRack() { //int month = int.Parse(DateTime.Today.Month.ToString()); //int year = int.Parse(DateTime.Today.Year.ToString()); //ddlrackno.Items.Insert(0, "--Select--"); //string qreyrac = "select Rack_No from dbo.Rake_Master_Sugar where Dest_District='" + distid + "'"; //cmd.Connection = con; //cmd.CommandText = qreyrac; //con.Open(); //dr = cmd.ExecuteReader(); //while (dr.Read()) //{ // ddlrackno.Items.Add(dr["Rack_No"].ToString()); //} //dr.Close(); //con.Close(); mobj = new MoveChallan(ComObj); string qreyrac = "select Rack_No from dbo.Rake_Master_Sugar where district_code='" + distid + "' and Mode='S'"; DataSet ds = mobj.selectAny(qreyrac); if (ds.Tables[0].Rows.Count == 0) { ddlrackno.Items.Clear(); ListItem lst = new ListItem(); lst.Text = "Not Indicated"; lst.Value = "0"; ddlrackno.Items.Insert(0, "--Select--"); ddlrackno.Items.Insert(1, lst); } else { ddlrackno.Items.Clear(); ddlrackno.DataSource = ds.Tables[0]; ddlrackno.DataTextField = "Rack_No"; ddlrackno.DataValueField = "Rack_No"; ddlrackno.DataBind(); ddlrackno.Items.Insert(0, "--Select--"); ddlrackno.Items.Insert(1, "Not Indicated"); } }
void GetFactory() { string st = ddlstate.SelectedValue; mobj = new MoveChallan(ComObj); string qryms = "select distinct(Factory_Code) as Factory_Code,Factory_Name from dbo.Sugar_Places where State_code=" + st + " and Place_code='" + ddlplace.SelectedValue + "' order by Factory_Name"; DataSet dsms = mobj.selectAny(qryms); if (dsms == null) { } else { ddlfactory.DataSource = dsms.Tables[0]; ddlfactory.DataTextField = "Factory_Name"; ddlfactory.DataValueField = "Factory_Code"; ddlfactory.DataBind(); ddlfactory.Items.Insert(0, "--Select--"); } }
void fillgrid(string qry) { string logtype = ddllogintype.SelectedValue; mobj = new MoveChallan(ComObj); //string qry = "SELECT User_LogTime.user_id,User_LogTime.IP_Address,User_LogTime.Login_Date, User_LogTime.Login_Time, User_LogTime.Logout_Time, User_LogTime.offline,tbl_MetaData_DEPOT.DepotName FROM User_LogTime Left JOIN tbl_MetaData_DEPOT ON User_LogTime.user_id = tbl_MetaData_DEPOT.DepotID where Login_Date>='" + fromdae + "'and Login_Date <='" + todate + "'and User_LogTime.Login_Type='" + logtype + "' order by User_LogTime.offline"; DataSet ds = mobj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { lblmsg.Visible = true; lblmsg.Text = "No Record Present Currently"; } else { lblmsg.Visible = false; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } }
void fillgridProc() { string did = ddl_dist.SelectedValue; string sid = ddl_IC.SelectedValue; string gid = ddlgodown.SelectedValue; mobj = new MoveChallan(ComObj); string qry = "SELECT SCSC_Procurement.*, tbl_MetaData_GODOWN.Godown_Name as Godown_Name, tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name,tbl_MetaData_Purchase_Center.PurchaseCenterName FROM dbo.SCSC_Procurement left join tbl_MetaData_GODOWN on SCSC_Procurement.Recd_Godown=tbl_MetaData_GODOWN.Godown_ID left join dbo.tbl_MetaData_STORAGE_COMMODITY on SCSC_Procurement.Commodity_Id=tbl_MetaData_STORAGE_COMMODITY .Commodity_Id left join dbo.tbl_MetaData_Purchase_Center on SCSC_Procurement.Purchase_Center=tbl_MetaData_Purchase_Center.PcId where Distt_ID='" + did + "' and IssueCenter_ID='" + sid + "' and Recd_Godown='" + gid + "' order by SCSC_Procurement.Recd_date desc"; DataSet ds = mobj.selectAny(qry); if (ds.Tables[0].Rows.Count > 0) { dgrid_Proc.DataSource = ds.Tables[0]; dgrid_Proc.DataBind(); } else { dgrid_Proc.DataSource = null; dgrid_Proc.DataBind(); } }
void fillgrid() { con.Open(); mobj = new MoveChallan(ComObj); string qry = "SELECT SCSC_Procurement.*,tbl_MetaData_GODOWN.Godown_Name,tbl_MetaData_DEPOT.DepotName, tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name,Society.Society_Name +','+ SocPlace +',' + Society_Id as PurchaseCenterName FROM dbo.SCSC_Procurement left join dbo.tbl_MetaData_STORAGE_COMMODITY on SCSC_Procurement.Commodity_Id=tbl_MetaData_STORAGE_COMMODITY .Commodity_Id left join dbo.Society on SCSC_Procurement.Purchase_Center= Society.Society_Id inner join tbl_MetaData_DEPOT on SCSC_Procurement.IssueCenter_ID=tbl_MetaData_DEPOT.DepotID left join tbl_MetaData_GODOWN on tbl_MetaData_GODOWN.Godown_ID=SCSC_Procurement.Recd_Godown where TC_Number='" + txt_tcno.Text.Trim() + "' and Purchase_Center ='" + ddl_purchasecentre.SelectedValue.ToString() + "' order by SCSC_Procurement.Recd_date desc"; DataSet ds = mobj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { Label1.Visible = true; Label1.Text = "Currently no Record is present"; dgridchallan.DataBind(); } else { Label1.Visible = false; dgridchallan.DataSource = ds.Tables[0]; dgridchallan.DataBind(); } con.Close(); }
void getsweepageCategory() { if (con.State == ConnectionState.Closed) { con.Open(); } mobj = new MoveChallan(ComObj); string qry = "SELECT * FROM dbo.tbl_sweepage_CATEGORY "; DataSet ds = mobj.selectAny(qry); ddlcataegory.DataSource = ds.Tables[0]; ddlcataegory.DataTextField = "Category_Name"; ddlcataegory.DataValueField = "Category_Id"; ddlcataegory.DataBind(); ddlcataegory.Items.Insert(0, "--Select--"); if (con.State == ConnectionState.Open) { con.Close(); } }
void GetICenter() { if (con.State == ConnectionState.Closed) { con.Open(); } mobj = new MoveChallan(ComObj); string qry = "SELECT * FROM dbo.tbl_MetaData_DEPOT where DistrictId = '23" + distid + "' order by DepotID "; DataSet ds = mobj.selectAny(qry); ddlissuecenter.DataSource = ds.Tables[0]; ddlissuecenter.DataTextField = "DepotName"; ddlissuecenter.DataValueField = "DepotID"; ddlissuecenter.DataBind(); ddlissuecenter.Items.Insert(0, "--Select--"); if (con.State == ConnectionState.Open) { con.Close(); } }
void fillgrid() { string date = DateTime.Today.Date.ToString("MM/dd/yyyy"); mobj = new MoveChallan(ComObj); string qry = "SELECT RO_of_FCI.*,districtsmp.district_name from dbo.RO_of_FCI left join pds.districtsmp on RO_of_FCI.Distt_Id=districtsmp.district_code where RO_of_FCI.RO_Validity <'" + date + "' and RO_of_FCI.Distt_Id='" + distid + "' and RO_of_FCI.RO_No <> 'NoRO' order by RO_of_FCI.RO_date Desc"; DataSet ds = mobj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { lblmsg.Visible = true; lblmsg.Text = "No Record Present Currently"; } else { lblmsg.Visible = false; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); //GridView1.Columns[0].Visible = false; } }
void GetGodown() { mobj = new MoveChallan(ComObj); string qry = "SELECT * FROM dbo.tbl_MetaData_GODOWN where DistrictId='" + ddl_dist.SelectedValue + "' and DepotId='" + ddl_IC.SelectedValue + "' order by Godown_ID"; DataSet ds = mobj.selectAny(qry); ddlgodown.DataSource = ds.Tables[0]; if (ds.Tables[0].Rows.Count > 0) { ddlgodown.DataTextField = "Godown_Name"; ddlgodown.DataValueField = "Godown_ID"; ddlgodown.DataBind(); ddlgodown.Items.Insert(0, "--Select--"); } else { ddlgodown.Items.Clear(); ddlgodown.DataValueField = null; ddlgodown.DataBind(); } }
void fillGrid() { string depoid = ddlissueCenter.SelectedValue; string qrychk = "select issue_opening_balance.* ,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 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 where issue_opening_balance.Depotid='" + depoid + "'"; mobj = new MoveChallan(ComObj); DataSet dschk = mobj.selectAny(qrychk); if (dschk == null) { } else { GridView1.DataSource = dschk.Tables[0]; GridView1.DataBind(); //GridView1.Columns[9].Visible = false; //GridView1.Columns[10].Visible = false; //GridView1.Columns[11].Visible = false; //GridView1.Columns[12].Visible = false; } }