我怎样才能从文本框和标签的数据表中插入值 [英] how can i insert value in datatable from textbox and lable

问题描述

我正在使用数据表，并希望从文本框中插入值，该源代码的来源是什么.
输入所有记录后，最后使用提交按钮保存到数据库.

我的数据表代码是:

Hi,

I am using a data table and want to insert value from text box what is the source code for that.
After entering all records finally use submit button for save to database.

My data table code is:

protected void btnAdd_Click(object sender, EventArgs e)
       {
           //SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connectionstring"].ToString());
           //SqlDataAdapter da = new SqlDataAdapter("select product_name,product_quantity,product_amount from product_order", con);

           DataTable dt = new DataTable();
           dt.Columns.Add("Product_Name");
           dt.Columns.Add("Product_Quantity");
           dt.Columns.Add("Product_Amount");

           DataRow dr = dt.NewRow();
           dt.Rows.Add(dr);
           dr[0] = DropDownList1.SelectedItem.Text;
           dr[1] = txtqty.Text;
           dr[2] = txtAmount.Text;


       }

推荐答案

//您的数据表
DataTable myDataTable = new DataTable();

DataColumn myDataColumn;

myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName ="id";
myDataTable.Columns.Add(myDataColumn);

myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName =用户名";
myDataTable.Columns.Add(myDataColumn);

//现在将TextBox值添加到行列中

DataRow行；

row = myTable.NewRow();

row ["id"] = Guid.NewGuid().ToString();
row ["username"] = TextBox1.Text;//在这里，您要分配值

myTable.Rows.Add(row); //将行添加到表中

谢谢&问候，
Jeevan.

Hi,

//Your DataTable
DataTable myDataTable = new DataTable();

DataColumn myDataColumn;

myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "id";
myDataTable.Columns.Add(myDataColumn);

myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "username";
myDataTable.Columns.Add(myDataColumn);

//Now to add the TextBox value in a row column

DataRow row;

row = myTable.NewRow();

row["id"] = Guid.NewGuid().ToString();
row["username"] = TextBox1.Text;// Here you are assigning the value

myTable.Rows.Add(row); //Add the row to a table

Thanks & Regards,
Jeevan.

这是您要问的非常基本的事情.
建议您阅读一些书籍或访问google.

我对此表示不满，这很明显是因为您没有付出任何努力来寻找解决方案或学习相关知识.

This is a very basic thing you are asking.
I suggest you to read some book or visit google.

I am downvoting this, cause its clear that you have not put in any efforts to search the solution or learn the thing.

这篇关于我怎样才能从文本框和标签的数据表中插入值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！