当插入第二条记录时丢失先前记录的任何一个电话我如何查看所有记录 [英] when am inserting 2nd record lossing previous recods any one tel me how can i see all records

问题描述

这是我的代码........

this is my code........

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {


    }

    protected void btnsave_Click(object sender, EventArgs e)
    {DataTable dt = new DataTable();
        
        DataRow dr;
       
        dt.Columns.Add(new System.Data.DataColumn("Name", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("Address", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("Cell", typeof(String)));



            dr = dt.NewRow();

            dr[0] = TextBox1.Text;
            dr[1] = TextBox2.Text;
            dr[2] = TextBox3.Text;
            dt.Rows.Add(dr);

            Session["CurrentData"] = dt;

            clearfields();
        
        
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Redirect("Default3.aspx");

    }
    private void clearfields()
    {
        TextBox1.Text = "";
        TextBox2.Text = "";
        TextBox3.Text = "";
    
    
    }
}

推荐答案

插入第二个值之前.set

before inserting second value.set

dt = Session["CurrentData"];

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {


    }

    protected void btnsave_Click(object sender, EventArgs e)
    {
        DataTable dt = new DataTable();
        if (Session["CurrentData"] != null)
        {
            dt = (DataTable)Session["CurrentData"];
        }
        DataRow dr;

        dt.Columns.Add(new System.Data.DataColumn("Name", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("Address", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("Cell", typeof(String)));



        dr = dt.NewRow();

        dr[0] = TextBox1.Text;
        dr[1] = TextBox2.Text;
        dr[2] = TextBox3.Text;
        dt.Rows.Add(dr);

        Session["CurrentData"] = dt;

        clearfields();


    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Redirect("Default3.aspx");

    }
    private void clearfields()
    {
        TextBox1.Text = "";
        TextBox2.Text = "";
        TextBox3.Text = "";


    }
}

您没有还原会话中保存的数据表.

试试这个

You are not restoring the data table that you saved in session.

Try this

private DataTable CreatEmptyDT()
{
    DataTable dt = new DataTable();

    dt.Columns.Add(new System.Data.DataColumn("Name", typeof(String)));
    dt.Columns.Add(new System.Data.DataColumn("Address", typeof(String)));
    dt.Columns.Add(new System.Data.DataColumn("Cell", typeof(String)));

    return dt;
}

public DataTable CurrentData
{
    get
    {
        object o = Session["CurrentData"];
        if (o == null)
            return CreatEmptyDT();
        else
            return (DataTable)o;
    }
    set { Session["CurrentData"] = value; }
}

protected void btnsave_Click(object sender, EventArgs e)
{
    DataTable dt = CurrentData;

    DataRow dr = dt.NewRow();

    dr[0] = TextBox1.Text;
    dr[1] = TextBox2.Text;
    dr[2] = TextBox3.Text;
    dt.Rows.Add(dr);

    CurrentData = dt;

    clearfields();
}

干杯

Cheers

这篇关于当插入第二条记录时丢失先前记录的任何一个电话我如何查看所有记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！