protected void Button1_Click(object sender, EventArgs e) { clsroute objroute = new clsroute(); objroute.RouteNo = txtrouteno.Text; objroute.RouteName = txtroutename.Text; objroute.Source = txtsource.Text; objroute.Destination = txtdestination.Text; objroute.TotalDistance = int.Parse(txtdistance.Text); objroute.Rate = int.Parse(txtrate.Text); try { int result = objroute.InsertRoute(); if (result == 1) { lblmessage.Text = "Inserted Successfully"; lblmessage.ForeColor = Color.Green; } else if (result == 2) { lblmessage.Text = "RouteNo " + objroute.RouteNo + " Already Exits.Try again..."; } } catch (Exception err) { lblmessage.Text = err.Message.ToString(); } }
protected void btnbussubmit_Click(object sender, EventArgs e) { clsroute objroute = new clsroute(); objroute.RouteNo = ddlrouteno.SelectedItem.Value; objroute.DeleteRoute(); }
protected void Page_Load(object sender, EventArgs e) { //check the page is posted or not if (!this.IsPostBack) { objroute = new clsroute(); DataSet ds = objroute.getAllRoute(); ddlrouteno.DataSource = ds.Tables[0]; //the table fieldname as hidden ddlrouteno.DataValueField = "RouteNo"; ddlrouteno.DataBind(); } }
protected void Button1_Click(object sender, EventArgs e) { clsroute objroute = new clsroute(); objroute.RouteNo = ddlrouteno.Text; objroute.RouteName = txtroutename.Text; objroute.Source = txtsource.Text; objroute.Destination = txtdestination.Text; objroute.TotalDistance = int.Parse(txtdistance.Text); objroute.Rate = int.Parse(txtrate.Text); int result = objroute.EditRoute(); if (result >= 1) { lblmessage.Text = "record Is updated Successfully"; lblmessage.ForeColor = System.Drawing.Color.Green; } }
protected void Button2_Click(object sender, EventArgs e) { objroute = new clsroute(); String routeno = ddlrouteno.SelectedItem.Value; DataSet ds = objroute.getRoutebyRouteNo(routeno); if (ds.Tables[0].Rows.Count >= 1) { foreach (DataRow dr in ds.Tables[0].Rows) { txtroutename.Text = dr["RouteName"].ToString(); txtsource.Text = dr["Source"].ToString(); txtdestination.Text = dr["Destination"].ToString(); txtdistance.Text = dr["TotalDistance"].ToString(); txtrate.Text = dr["Rate"].ToString(); } } }