How to show content in saved items in c#?

Question

Hai Friends i ve the application like travel.aspx ============ departuredate = textbox from = textbox to = textbox requestId(visible false) add(button) save(button) submit(button) after pressing the button entire details ll show on gridview i declare the request as global variable in these page. after fill the details users choose SAVE means ll be redirect into HOME.aspx page. in that page draft items contains above details like Min(departuredate)(link Button) from to when the user press the date ll re-direct VIEW.aspx in these page ll display what i had enter the details shown on it as refercences these link http://hightechnology.in/how-to-redirect-to-another-page-by-click-on-linkbutton-in-gridview/ i passed the global variable from travel.aspx into View.aspx (i had done these much) now i m facing the problem is when i tried to add sum dates in VIEW.aspx it not shown on grid view after give SAVE(button) i can able to see ? what was the problem?

Rocky Rocky · Answer

Hi i ve three pages in my aspx travel.aspx page i entered sum details like '2013-05-01''Chennai''Banglore' '2013-05-02''Banglore''chennai' ===>ADD the conten ll show on gridview now i gave the save(button) it ll be redirect into Home.aspx Home.apsx ======= Draft Items 2013-05-01 (link button) chennai Banglore if the user press the link button it show View.Aspx what i had entered on travel.aspx that details ll shown here . i.e view.aspx ll show '2013-05-01''Chennai''Banglore' '2013-05-02''Banglore''chennai' now mY requirement is when the user try add one more date '2013-05-03' 'chennai''chennai' Add(button) the date added on database but not show on gridview after given save ll goes on HOME.aspx again press the link button that time only can see the last added date?

Sanjeeb Lenka · Answer

in which page you want to show the grid. plz provide clear details

Rocky Rocky · Answer

Hi content ll show on home.aspx with link button when i choose the link button ll goes view.aspx what i had entered on travel.aspx page

Sanjeeb Lenka · Answer

in this you are redirect to home.aspx after update s. so in which page you want to show the data after update .

Rocky Rocky · Answer

protected void Savedrft_Click(object sender EventArgs e) { if ((TxtComments.Text != ) && (Txttotal.Text != )) { // //draftcheck(); string sd = update travel_request set active_tag='Y' where user_id=' + Txtusr.Text + ' and request_id='+ ss + '; SqlCommand cmd = new SqlCommand(sd conn); conn.Open(); cmd.ExecuteNonQuery(); Session[requestId] = ss; Response.Write( alert('Record Saved Successfully'); ); Server.Transfer(Home.aspx); conn.Close(); //SqlCommand cm = new SqlCommand(save_draft conn); //cm.CommandType = CommandType.StoredProcedure; //try //{ // conn.Open(); // DateTime dt1 = Convert.ToDateTime(HdnFldDate.Value); // cm.Parameters.Add(new SqlParameter(@username uname)); // cm.Parameters.Add(new SqlParameter(@departure dt1)); // cm.Parameters.Add(new SqlParameter(@request requestId)); // cm.Prepare(); // string strSuccess = Convert.ToString(cm.ExecuteNonQuery()); // int isSuccessfull; // isSuccessfull = Convert.ToInt32(cm.ExecuteScalar()); // if (isSuccessfull != 0) // { // Response.Write( alert('Record Saved Successfully'); ); // Server.Transfer(Home.aspx); // } //} //catch (Exception ex) //{ // string strMessage = SQL Query failed:  + ex.Message; //} //finally //{ // cm = null; // conn.Close(); //} TxtAdamt.Text = ; Txtage.Text = ; TxtCntct.Text = ; TxtComments.Text = ; Txtdept.Text = ; TxtDesig.Text = ; TxtFNme.Text = ; TxtGen.Text = ; TxtLctn.Text = ; TxtLNme.Text = ; Txtmail.Text = ; Txttotal.Text = ; Txtusr.Text = ; Txtrequest.Text = ; }

Sanjeeb Lenka · Answer

which is your SAVE(button) code in this... above code

Rocky Rocky · Answer

using System; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class View : System.Web.UI.Page { string uname = ; public static int ss; DataSet ds = new DataSet(); SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[AccessConnectionString].ConnectionString); protected void Page_Load(object sender EventArgs e) { if (!Page.IsPostBack) { binddata(); } if (Session[username] != null) { uname = Session[username].ToString(); // Label1.Text = uname; Label1.ForeColor = System.Drawing.Color.Magenta; Label1.Text = string.Format( {0}  uname); PopulateUserDetails(uname); //GetDataTravel(); } else { Response.Redirect(Default.aspx); } } protected void ddHeardAboutUs_SelectedIndexChanged(object sender EventArgs e) { if (ddHeardAboutUs.SelectedItem.Value == --select--) { Response.Redirect(Trvlreq.aspx); } if ((ddHeardAboutUs.SelectedItem.Value == Travel Request) || (ddHeardAboutUs.SelectedItem.Value == Basic Details)) { details.Visible = (ddHeardAboutUs.SelectedItem.Text == Travel Request); empdeatils.Visible = (ddHeardAboutUs.SelectedItem.Text == Basic Details); } } public void binddata() { ss = Convert.ToInt32(Request.QueryString[IdPassed]); //SqlDataAdapter da = new SqlDataAdapter(T_bind conn); //da.SelectCommand.CommandType = CommandType.StoredProcedure; //da.SelectCommand.Parameters.Add(new SqlParameter(@username SqlDbType.VarChar)); //da.SelectCommand.Parameters[@username].Value = uname.ToString(); //da.SelectCommand.Parameters.Add(new SqlParameter(@request SqlDbType.Int)); //da.SelectCommand.Parameters[@request].Value = ss.ToString(); string sql = select request_idonward_journey_idconvert(varchar departuredate 106)as DepartureDatefrom_locationto_location case metro when 'Y' then 'Yes' else 'No' END as Metro case Trans_All when 'Y' then 'Yes' else 'No' END as transitcase when mode_of_travel like 'Ai%' then mode_of_travel when mode_of_travel like 'Tr%' then mode_of_travel when mode_of_travel like 'Bu%' then mode_of_travel when mode_of_travel like 'Ca%' then mode_of_travel when mode_of_travel like 'Au%' then mode_of_travel when mode_of_travel like 'lo%' then mode_of_travel end as Modecase when mode_of_travel like ('ai%') then seat_type when mode_of_travel like ('tra%') then seat_type when mode_of_travel like ('Bu%') then seat_type when mode_of_travel like ('ca%') then seat_type when mode_of_travel like ('au%') then seat_type when mode_of_travel like ('loc%') then seat_type end as SEATno_of_days as noofdaysother_details from onward_journey where request_id=' + ss + 'order by departuredate; SqlCommand cmd = new SqlCommand(sql conn); SqlDataAdapter da = new SqlDataAdapter(cmd); SqlDataReader rdrData; ds.Clear(); da.Fill(ds); conn.Open(); cmd.ExecuteNonQuery(); rdrData = cmd.ExecuteReader(); if (ds.Tables.Count > 0) { for (int i = 0; i { GridView1.DataSource = ds; GridView1.DataBind(); } } else { GridView1.DataSource = null; GridView1.DataBind(); } //da.Fill(ds T_bind); //GridView1.DataSource = ds.Tables[T_bind]; //GridView1.DataBind(); } //string strquery = select onward_journey_idrequest_idconvert(varchar departuredate 106)as DepartureDatefrom_locationto_location case metro when 'Yes' then 'Yes' else 'No' end as Metrocase Trans_All when 'Yes' then 'Yes' else 'No' END as transitcase when mode_of_travel like 'Ai%' then mode_of_travel when mode_of_travel like 'Tr%' then mode_of_travel when mode_of_travel like 'Bu%' then mode_of_travel when mode_of_travel like 'Ca%' then mode_of_travel when mode_of_travel like 'Au%' then mode_of_travel when mode_of_travel like 'lo%' then mode_of_travel end as Modecase when mode_of_travel like ('ai%') then seat_type when mode_of_travel like ('tra%') then seat_type when mode_of_travel like ('Bu%') then seat_type when mode_of_travel like ('ca%') then seat_type when mode_of_travel like ('au%') then seat_type when mode_of_travel like ('loc%') then seat_type end as SEATno_of_days as noofdaysother_details from onward_journey where request_id= '  + btg.ToString() +  ' order by departuredate; //SqlCommand cmd = new SqlCommand(T_bindata conn); //private void datecheck() //{ // bool readerHasRows = false; // string depdate = Datepicker.Text; // // string maxde = select max(departuredate) from onward_journey; // string commandQuery = SELECT DepartureDate FROM onward_journey WHERE departuredate = @depdate and request_id='+requestId+' ; // using (SqlCommand cmd = new SqlCommand(commandQuery conn)) // { // conn.Open(); // cmd.Parameters.AddWithValue(@depdate Datepicker.Text); // using (SqlDataReader reader = cmd.ExecuteReader()) // { // // bool initialized above is set here // readerHasRows = (reader != null && reader.HasRows); //&& reader >Datepicker); // } // conn.Close(); // } // if (readerHasRows) // { // Response.Write( alert('Departure Date Already Exists!!') ); // } //} //} protected void ADD_Click(object sender EventArgs e) { if (TxtFm.Text == ) { Response.Write( alert('From Place Cannot Be Blank'); ); } if (TxtTo.Text == ) { Response.Write( alert('To Place Cannot Be Blank'); ); } if (DDL_Metro.SelectedIndex == 0) { Response.Write( alert('Metro city Cannot Be Blank'); ); } if (DDL_trans.SelectedIndex == 0) { Response.Write( alert('Trasnsit allowance Cannot Be Blank'); ); } if (DDL_ModeOfTravel.SelectedIndex == 0) { Response.Write( alert('Mode Of Travel Cannot Be Blank'); ); } if (DDL_SeatType.SelectedIndex == 0) { Response.Write( alert('Seat Type Cannot Be Blank'); ); } if (TxtNo.Text == ) { Response.Write( alert('No Of Days Cannot Be Blank'); ); } if ((Datepicker.Text != ) && (TxtNo.Text != ) && (DDL_SeatType.Text != ) && (DDL_ModeOfTravel.Text != ) && (TxtTo.Text != ) && (TxtFm.Text != ) && (DDL_Metro.Text != ) && (DDL_trans.Text != ) && (TxtNo.Text != )) { try { //string sql = insert into onward_journey(departuredatefrom_locationto_locationmetrotrans_allmode_of_travelseat_typeno_of_daysother_detailsstatus_id) values(@departuredate@from_location@to_location@metro@trans_all@mode_of_travel@seat_type@no_of_days@other_details'2'); SqlCommand cmd = new SqlCommand([Insert_Journey] conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@departuredate string.Format({0:MM/dd/yyyy} Datepicker.Text)); cmd.Parameters.AddWithValue(@from_location TxtFm.Text); cmd.Parameters.AddWithValue(@to_location TxtTo.Text); cmd.Parameters.AddWithValue(@metro DDL_Metro.Text); cmd.Parameters.AddWithValue(@trans_all DDL_trans.Text); cmd.Parameters.AddWithValue(@mode_of_travel DDL_ModeOfTravel.Text); cmd.Parameters.AddWithValue(@seat_type DDL_SeatType.Text); cmd.Parameters.AddWithValue(@no_of_days TxtNo.Text); cmd.Parameters.AddWithValue(@other_details Txtothrdet.Text); cmd.Parameters.AddWithValue(@status_id Txtstts.Text); cmd.Parameters.AddWithValue(@request ss); conn.Open(); cmd.ExecuteNonQuery(); HdnFldDate.Value = Datepicker.Text; DateTime val = new DateTime(); DateTime b = new DateTime(); val = Convert.ToDateTime(Datepicker.Text); b = val.AddDays(Convert.ToInt32(TxtNo.Text)); Datepicker.Text = b.ToString(); Datepicker.Enabled = false; //btg = requestId.ToString(); //Session[requestId] = btg.ToString(); binddata(); } catch (System.Exception ex) { Console.WriteLine(Source:  + ex.Source); Console.WriteLine(Exception Message:  + ex.Message); } finally { if (conn.State == ConnectionState.Open) { Console.WriteLine(Finally block closing the connection); conn.Close(); } } //Datepicker.Enabled = false; DDL_Metro.SelectedIndex = 0; DDL_trans.SelectedIndex = 0; DDL_ModeOfTravel.SelectedIndex = 0; DDL_SeatType.SelectedIndex = 0; TxtFm.Text = ; TxtTo.Text = ; TxtNo.Text = ; Txtothrdet.Text = ; //Txtrequest.Text = ; } } //private void draftcheck() //{ // SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[AccessConnectionString].ConnectionString); // SqlCommand cm = new SqlCommand(travelnodraft con); // cm.CommandType = CommandType.StoredProcedure; // con.Open(); // cm.Parameters.AddWithValue(@username uname); // cm.Parameters.AddWithValue(@departuredate Datepicker.Text); // cm.ExecuteNonQuery(); // con.Close(); // Response.Write( alert('Already same date in draft'); ); // //Response.Write( alert(' Delete successfully'); ); //} protected void Savedrft_Click(object sender EventArgs e) { if ((TxtComments.Text != ) && (Txttotal.Text != )) { // //draftcheck(); string sd = update travel_request set active_tag='Y' where user_id=' + Txtusr.Text + ' and request_id='+ ss + '; SqlCommand cmd = new SqlCommand(sd conn); conn.Open(); cmd.ExecuteNonQuery(); Session[requestId] = ss; Response.Write( alert('Record Saved Successfully'); ); Server.Transfer(Home.aspx); conn.Close(); //SqlCommand cm = new SqlCommand(save_draft conn); //cm.CommandType = CommandType.StoredProcedure; //try //{ // conn.Open(); // DateTime dt1 = Convert.ToDateTime(HdnFldDate.Value); // cm.Parameters.Add(new SqlParameter(@username uname)); // cm.Parameters.Add(new SqlParameter(@departure dt1)); // cm.Parameters.Add(new SqlParameter(@request requestId)); // cm.Prepare(); // string strSuccess = Convert.ToString(cm.ExecuteNonQuery()); // int isSuccessfull; // isSuccessfull = Convert.ToInt32(cm.ExecuteScalar()); // if (isSuccessfull != 0) // { // Response.Write( alert('Record Saved Successfully'); ); // Server.Transfer(Home.aspx); // } //} //catch (Exception ex) //{ // string strMessage = SQL Query failed:  + ex.Message; //} //finally //{ // cm = null; // conn.Close(); //} TxtAdamt.Text = ; Txtage.Text = ; TxtCntct.Text = ; TxtComments.Text = ; Txtdept.Text = ; TxtDesig.Text = ; TxtFNme.Text = ; TxtGen.Text = ; TxtLctn.Text = ; TxtLNme.Text = ; Txtmail.Text = ; Txttotal.Text = ; Txtusr.Text = ; Txtrequest.Text = ; } } protected void Submit_Click(object sender EventArgs e) { } protected void Cncl_Click(object sender EventArgs e) { } //select departuredate from onward_journey where departuredate=@dep; //string DepartureDate = txtDeDate.ToString; //DateTime dt1 = Convert int.Parse(DepartureDate.AddDays(3)); protected void GridView1_RowDeleting(object sender GridViewDeleteEventArgs e) { //string lid = ((Label)GridView1.Rows[e.RowIndex].FindControl(lid)).Text; string strcon = ConfigurationManager.ConnectionStrings[AccessConnectionString].ConnectionString; SqlConnection conn = new SqlConnection(strcon); conn.Open(); string j = GridView1.DataKeys[e.RowIndex].Value.ToString(); String strsession = delete from onward_journey where onward_journey_id=' + j + '; SqlCommand cmd = new SqlCommand(strsession conn); cmd.ExecuteNonQuery(); conn.Close(); binddata(); //Response.Write( alert(' Delete successfully'); ); } protected void GridView1_PageIndexChanging(object sender GridViewPageEventArgs e) { GridView1.PageIndex = e.NewPageIndex; binddata(); } protected void GridView1_RowCommand(object sender GridViewCommandEventArgs e) { if (e.CommandName == cmdBind) { LinkButton lb = (LinkButton)e.CommandSource; int index = Convert.ToInt32(lb.CommandArgument); Datepicker.Text = GridView1.Rows[index].Cells[1].Text; TxtFm.Text = GridView1.Rows[index].Cells[2].Text; TxtTo.Text = GridView1.Rows[index].Cells[3].Text; DDL_Metro.Text = GridView1.Rows[index].Cells[4].Text; DDL_trans.Text = GridView1.Rows[index].Cells[5].Text; DDL_ModeOfTravel.Text = GridView1.Rows[index].Cells[6].Text; DDL_SeatType.Text = GridView1.Rows[index].Cells[7].Text; TxtNo.Text = GridView1.Rows[index].Cells[8].Text; Txtothrdet.Text = GridView1.Rows[index].Cells[9].Text; } } protected void DDL_ModeOfTravel_SelectedIndexChanged(object sender EventArgs e) { DDL_SeatType.Items.Clear(); DDL_SeatType.Items.Add(-select-); if (DDL_ModeOfTravel.SelectedItem.Text == Train) { DDL_SeatType.Items.Add(II AC); DDL_SeatType.Items.Add(III AC); DDL_SeatType.Items.Add(Sleeper Class); DDL_SeatType.Items.Add(2nd SL); } else if (DDL_ModeOfTravel.SelectedItem.Text == Air) { DDL_SeatType.Items.Add(Business); DDL_SeatType.Items.Add(Economy); } else if (DDL_ModeOfTravel.SelectedItem.Text == Car) { DDL_SeatType.Items.Add(Car); } else if (DDL_ModeOfTravel.SelectedItem.Text == Bus) { DDL_SeatType.Items.Add(Semi Sleeper); DDL_SeatType.Items.Add(Sleeper Class); } else if (DDL_ModeOfTravel.SelectedItem.Text == Auto) { DDL_SeatType.Items.Add(Auto); } else if (DDL_ModeOfTravel.SelectedItem.Text == Local) { DDL_SeatType.Items.Add(Local Travel); } else if (DDL_ModeOfTravel.SelectedItem.Text == Mode of Travel) { DDL_SeatType.Items.Add(Seat Type); } } protected void Button1_Click(object sender EventArgs e) { string strcon = ConfigurationManager.ConnectionStrings[AccessConnectionString].ConnectionString; //StringBuilder strSql = new StringBuilder(string.Empty); SqlConnection conn = new SqlConnection(strcon); conn.Open(); SqlCommand fet = new SqlCommand(update_use_tr conn); //SqlCommand fet = new SqlCommand(update onward_journey set departuredate=@depdatefrom_location=@fromto_location=@tometro=@metrotrans_all=@transmode_of_travel=@modeseat_type=@seatno_of_days=@noofdysother_details=@otherstatus_id=@status where onward_journey_id=@onward_journey_id conn); fet.CommandType = CommandType.StoredProcedure; fet.Parameters.AddWithValue(@depdate Datepicker.Text); fet.Parameters.AddWithValue(@from TxtFm.Text); fet.Parameters.AddWithValue(@to TxtTo.Text); fet.Parameters.AddWithValue(@metro DDL_Metro.Text); fet.Parameters.AddWithValue(@trans DDL_trans.Text); fet.Parameters.AddWithValue(@mode DDL_ModeOfTravel.Text); fet.Parameters.AddWithValue(@seat DDL_SeatType.Text); fet.Parameters.AddWithValue(@noofdys TxtNo.Text); fet.Parameters.AddWithValue(@other Txtothrdet.Text); fet.Parameters.AddWithValue(@request ss); //fet.Parameters.AddWithValue(@status Txtstts.Text); //fet.Parameters.AddWithValue(@onward_journey_id fet.ExecuteNonQuery(); conn.Close(); DateTime val = new DateTime(); DateTime b = new DateTime(); val = Convert.ToDateTime(Datepicker.Text); b = val.AddDays(Convert.ToInt32(TxtNo.Text)); Datepicker.Text = b.ToString(); binddata(); //Datepicker.Text = b.ToString(); DDL_Metro.SelectedIndex = 0; DDL_trans.SelectedIndex = 0; DDL_ModeOfTravel.SelectedIndex = 0; DDL_SeatType.SelectedIndex = 0; TxtFm.Text = ; TxtTo.Text = ; TxtNo.Text = ; Txtothrdet.Text = ; Response.Write(Updated Successfully); } protected void Button2_Click(object sender EventArgs e) { Datepicker.Text = ; DDL_Metro.SelectedIndex = 0; DDL_trans.SelectedIndex = 0; DDL_ModeOfTravel.SelectedIndex = 0; DDL_SeatType.SelectedIndex = 0; TxtFm.Text = ; TxtTo.Text = ; TxtNo.Text = ; Txtothrdet.Text = ; } string empcode = ; public class UserDataAccess { public string connectionString = ConfigurationManager.ConnectionStrings[AccessConnectionString].ToString(); public bool ValidateUserDetails(string userName string password) { bool retValue = false; SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(user_validate con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@username userName); cmd.Parameters.AddWithValue(@pwd password); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); con.Open(); da.Fill(ds); con.Close(); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { retValue = true; } else { retValue = false; } return retValue; } public DataSet GetUserDetails(string userName) { SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(view_drfts con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@username userName); cmd.Parameters.AddWithValue(@request ss); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); con.Open(); da.Fill(ds); con.Close(); return ds; } } UserDataAccess userDA = new UserDataAccess(); private void PopulateUserDetails(string uname) { DataSet ds = userDA.GetUserDetails(uname); if (ds.Tables[0].Rows.Count > 0) { TxtFNme.Text = ds.Tables[0].Rows[0][fst_name].ToString(); TxtLNme.Text = ds.Tables[0].Rows[0][Lst_Name].ToString(); Txtage.Text = ds.Tables[0].Rows[0][AGE].ToString(); TxtGen.Text = ds.Tables[0].Rows[0][Gender].ToString(); TxtDesig.Text = ds.Tables[0].Rows[0][designation].ToString(); TxtRepto.Text = ds.Tables[0].Rows[0][reporting_to].ToString(); TxtLctn.Text = ds.Tables[0].Rows[0][location].ToString(); DropDownList1.Text = ds.Tables[0].Rows[0][costcenter_id].ToString(); DropDownList2.Text = ds.Tables[0].Rows[0][proof_type_id].ToString(); Txtdept.Text = ds.Tables[0].Rows[0][departments].ToString(); Txtmail.Text = ds.Tables[0].Rows[0][mail_id].ToString(); Txtusr.Text = ds.Tables[0].Rows[0][user_id].ToString(); TxtAdamt.Text = ds.Tables[0].Rows[0][advance_amount].ToString(); TxtComments.Text = ds.Tables[0].Rows[0][purpose_of_travel].ToString(); Txttotal.Text = ds.Tables[0].Rows[0][total_amount].ToString(); } empcode = Txtusr.Text; } protected void Logout_click(object sender EventArgs e) { Session.Abandon(); Session.Clear(); Response.Redirect(~/Default.aspx); } }

Sanjeeb Lenka · Answer

can you share your view.aspx cs code..