protected void Page_Load(object sender, EventArgs e) { if (Session["AdminEmail"] == null) { Response.Redirect("HomePage.aspx"); } bool pagepost = this.IsPostBack; if (pagepost == false) { clscar obj = new clscar(); String query = "select * from tblcarcat"; try { DataSet ds = dbobj.getRecord(query); //set the data source of the dropdown list box ddlCarCat.DataSource = ds.Tables[0]; ddlCarCat.DataTextField = "CarCatName";//column name whose value we want to see ddlCarCat.DataValueField = "CarCatID"; ddlCarCat.DataBind(); ddlCarCat.Items.Insert(0, new ListItem("Select", String.Empty)); } catch (Exception err) { lblmsg.Text = err.Message; } } }
protected void ddlCarCat_SelectedIndexChanged(object sender, EventArgs e) { String query = "select Seater from tblcarcat where CarCatID='" + ddlCarCat.Text + "'"; try{ DataSet ds = dbobj.getRecord(query); DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { txtSeater.Text = dr["Seater"].ToString(); } clscar obj = new clscar(); String query1 = "select CarName from tblcar where CarCat='" + ddlCarCat.Text + "'"; DataSet ds1 = dbobj.getRecord(query1); ddlCarName.DataSource = ds1.Tables[0]; ddlCarName.DataTextField = "CarName"; ddlCarName.DataValueField = "CarName"; ddlCarName.DataBind(); ddlCarName.Items.Insert(0, new ListItem("Select", String.Empty)); txtMinHrs.Text = null; txtHrlyRate.Text = null; } catch (Exception err) { lblmsg.Text = err.Message; } }
protected void ddlCarCat1_SelectedIndexChanged(object sender, EventArgs e) { clscar obj = new clscar(); String query = "select CarNo from tblcar where CarCat='" + ddlCarCat1.Text + "'"; try { DataSet ds = dbobj.getRecord(query); ddlCarNo.DataSource = ds.Tables[0]; ddlCarNo.DataTextField = "CarNo"; ddlCarNo.DataValueField = "CarNo"; ddlCarNo.DataBind(); ddlCarNo.Items.Insert(0, new ListItem("Select", String.Empty)); txtCarNo.Text = null; txtCarName.Text = null; ddlCarType.Text = null; ddlFuelType.Text = null; txtDescription.Text = null; txtHrlyRate.Text = null; txtMinHrs.Text = null; } catch (Exception err) { lblmsg.Text = err.Message; } }
protected void ddlCarNo_SelectedIndexChanged(object sender, EventArgs e) { clscar objreg = new clscar(); try { objreg.CarNo = ddlCarNo.SelectedItem.Value; DataSet ds = objreg.GetDetailsbyCarNo(); DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { txtCarNo.Text = dr["CarNo"].ToString(); txtCarName.Text = dr["CarName"].ToString(); ddlCarType.SelectedValue = dr["CarType"].ToString(); ddlFuelType.SelectedValue = dr["FuelType"].ToString(); txtDescription.Text = dr["Description"].ToString(); txtHrlyRate.Text = dr["HrlyRate"].ToString(); txtMinHrs.Text = dr["MinHrs"].ToString(); String Imagefilename = dr["CarImage"].ToString(); Image2.ImageUrl = "Upload/" + Imagefilename; } } catch (Exception err) { lblmsg.Text = err.Message; } }
private void populateGridview() { clscar obj = new clscar(); try { obj.CarNo = Session["CarNo"].ToString(); DataSet ds = obj.GetDetailsbyCarNo(); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } catch (Exception err) { lblmsg.Text = err.Message; } }
private void populateGridview() { clscar objreg = new clscar(); try { DataSet ds = objreg.GetDetails(); // set the datasourec of the Gridview to //dataset table GridView1.DataSource = ds.Tables[0]; //call the databind method GridView1.DataBind(); } catch (Exception err) { lblmsg.Text = err.Message; } }