如何将按钮单击事件中的记录添加到数据表中 [英] How to Add Record from Button Click event Record into data table

问题描述

我想多次将记录添加到数据表中一键单击事件而不将数据表声明为静态.

例如我想在用户按下10时间按钮时将10条记录添加到数据表中


我正在使用此代码，但无法在每个Click事件数据表中清除

I want to Add record into Data Table in multiple time One Button Click Event Without Declare DataTable as Static.

e.g. I want add 10 record into Data Table when User press 10 Time Button


I am using this code but not working every Click event Data Table Clear

DataTable dt_dr = new DataTable("Test");

dt_dr.Columns.Add(LedgerId, typeof(int));
dt_dr.Columns.Add(LedgerName, typeof(string));


DataRow dt_row;
dt_row = dt_dr.NewRow();
dt_row[LedgerId] = TextBox1.Text;
dt_row[LedgerName] = TextBox2.Text;
dt_dr.Rows.Add(dt_row);

推荐答案

在按钮上单击鼠标，以您的标题为列的方式创建一个手动数据表.
然后动态添加包含数据的行.

On button click u make one manual datatable with your headers as columns.
then add rows with data dynamically.

Hello Anuja，
在类级别声明DataTable的对象

在按钮单击事件中使用波纹管代码

Hello Anuja,
Declare an object of DataTable at class level

Use bellow code in button click event

protected void Button1_Click(object sender, EventArgs e)
 {
     try
     {
         //Check if previous session is exist
         if (Session["MyTable"] == null)
         {
             dtMyTable = new DataTable("MyTable");
             dtMyTable.Columns.Add("Id", typeof(int));
             dtMyTable.Columns.Add("LName", typeof(string));

         }
         else
         {
             //If yes then get it from current session
             dtMyTable = (DataTable)Session["MyTable"];
         }

         //Add new row every time
         DataRow dt_row;
         dt_row = dtMyTable.NewRow();
         dt_row["Id"] = TextBox1.Text;
         dt_row["LName"] = TextBox2.Text;
         dtMyTable.Rows.Add(dt_row);

         //Update session table
         Session["MyTable"] = dtMyTable;
     }
     catch (Exception ex)
     {

         Response.Write(ex.Message);
     }
 }

这篇关于如何将按钮单击事件中的记录添加到数据表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！