void binddropdown() { try { General_Function gf = new General_Function(); db_conn cn = new db_conn(); gf.fillcombo("select Tpid,RatePerSeat from TravelPackage_M", ddltpid, "RatePerSeat", "Tpid", "select"); } catch { } }
void binddropdown() { try { General_Function gf = new General_Function(); db_conn cn = new db_conn(); gf.fillcombo("select City_Id,City_Name from City_M", ddlcity, "City_Name", "City_Id", "select"); } catch { } }
public void fillcombo(string query, DropDownList drpList, string drpTextField, string drpValueField, string selectText) { db_conn obj = new db_conn(); DataSet ds = new DataSet(); ds = obj.select(query); if (ds.Tables[0].Rows.Count > 0) { drpList.DataSource = ds.Tables[0]; drpList.DataTextField = drpTextField; drpList.DataValueField = drpValueField; drpList.DataBind(); } }
public void fill_grid(DataSet ds, GridView dg) { db_conn obj = new db_conn(); if (ds.Tables[0].Rows.Count > 0) { dg.DataSource = ds.Tables[0]; dg.DataBind(); } else { dg.DataSource = null; } }
void binddropdown() { try { General_Function gf = new General_Function(); db_conn cn = new db_conn(); gf.fillcombo("select Package_Id,Package_Name from Package_M", ddlpackageid, "Package_Name", "Package_Id", "select"); gf.fillcombo("select Bus_Id,Bus_Name from Bus_M", ddlbusid, "Bus_Name", "Bus_Id", "select"); gf.fillcombo("select Train_Id,Train_No from Train_M", ddltrainid, "Train_No", "Train_Id", "select"); gf.fillcombo("select Plane_Id,Plane_Name from Plane_M", ddlplaneid, "Plane_Name", "Plane_Id", "select"); gf.fillcombo("select Car_Id,Car_Name from Car_M", ddlcarid, "Car_Name", "Car_Id", "select"); } catch { } }
// Use this for initialization void Start() { db_conn database = new db_conn(); switch (ut) { case usagetype.NewLargestHit: StartCoroutine(database.setNewLargestHit(playerid, displayname, value)); break; case usagetype.UpdateLargestHit: StartCoroutine(database.UpdateLargestHit(playerid, value)); break; case usagetype.GetTop10LargestHits: StartCoroutine(database.getTopTenLargestHit()); break; case usagetype.GetPlayerLargestHit: StartCoroutine(database.getPlayerLargestHit(playerid)); break; case usagetype.NewOttomanTime: StartCoroutine(database.setNewOttomanTime(playerid, displayname, value)); break; case usagetype.UpdateOttomanTime: StartCoroutine(database.UpdateOttomanTime(playerid, value)); break; case usagetype.GetTop10OttomanTime: StartCoroutine(database.getTopTenOttomanTime()); break; case usagetype.GetPlayerOttomanTime: StartCoroutine(database.getPlayerOttomanTme(playerid)); break; } }
void binddropdown() { try { General_Function gf = new General_Function(); db_conn cn = new db_conn(); gf.fillcombo("select Customer_Id,First_Name from Customer_M where email = '" + Session["Email"].ToString() + "'", ddlcustomerid, "First_Name", "Customer_Id", "select"); gf.fillcombo("select Package_Id,Package_Name from Package_M", ddlpackageid, "Package_Name", "Package_Id", "select"); DataSet ds = new DataSet(); ds = cn.select("select * from Package_M where Package_Id='" + ddlpackageid.SelectedValue + "'"); Double amt = Convert.ToDouble(ds.Tables[0].Rows[0]["Price"].ToString()); lblamt.Text = amt.ToString(); // gf.fillcombo("select Tpid,RatePerSeat from TravelPackage_M", ddltpid, "RatePerSeat", "Tpid", "select"); } catch { } }