How to show content in saved items in c#?

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?

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

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

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

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

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_id,onward_journey_id,convert(varchar, departuredate, 106)as DepartureDate,from_location,to_location, case metro when 'Y' then 'Yes' else 'No' END as Metro, case Trans_All when 'Y' then 'Yes' else 'No' END as transit,case 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 Mode,case 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 SEAT,no_of_days as noofdays,other_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 < ds.Tables[0].Rows.Count; 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_id,request_id,convert(varchar, departuredate, 106)as DepartureDate,from_location,to_location,  case metro when 'Yes' then 'Yes' else 'No' end as Metro,case Trans_All when 'Yes' then 'Yes' else  'No' END as transit,case 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 Mode,case 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 SEAT,no_of_days as noofdays,other_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("");
    //    }
    //}




    //}

    protected void ADD_Click(object sender, EventArgs e)
    {
        if (TxtFm.Text == "")
        {
            Response.Write("");
        }

        if (TxtTo.Text == "")
        {
            Response.Write("");
        }


        if (DDL_Metro.SelectedIndex == 0)
        {
            Response.Write("");
        }

        if (DDL_trans.SelectedIndex == 0)
        {
            Response.Write("");
        }

        if (DDL_ModeOfTravel.SelectedIndex == 0)
        {
            Response.Write("");
        }

        if (DDL_SeatType.SelectedIndex == 0)
        {
            Response.Write("");
        }
        if (TxtNo.Text == "")
        {
            Response.Write("");
        }



        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(departuredate,from_location,to_location,metro,trans_all,mode_of_travel,seat_type,no_of_days,other_details,status_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("");
    //    //Response.Write("");

    //}
   
    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("");
            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("");
            //        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("");

    }

    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=@depdate,from_location=@from,to_location=@to,metro=@metro,trans_all=@trans,mode_of_travel=@mode,seat_type=@seat,no_of_days=@noofdys,other_details=@other,status_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");
    }

  
}

can you share your view.aspx cs code..