使用GRID一对一地从Web表单插入数据 [英] USING GRID for insert data from web form one by one

问题描述

我正在从Web表单中插入值.

从下拉列表中选择第一个项目名称，然后使用文本框中的项目费率和数量.

我希望所有这些值都放入网格中，当我插入所有值时，计算所有值的数量，然后按提交以保存这些数据，然后保存在数据库中.

Hi,

I am inserting value from web form.

First item name selecting from drop down list then using item rate and quantity from text box.

I want all these values to come in a grid and when I have inserted all the values, calculate amount of all value and press submit to save these data and then save in database.

推荐答案

如果您不想保存在文本框中输入的值，则可以创建一个临时数据表.在文本框中单击提交后，填充在DataTable中输入的数据.将gridview数据源作为数据表.

绑定gridview.然后，您将可以在gridview中看到输入的值.

如果一切正常，请进行最终提交，然后将这些值插入数据库.

希望对您有帮助.:)


Mohan Gajula

if u dont want to save the values entered in textbox u can create a temporary DataTable. Once the submit is clicked for the textboxes, fill the data entered in DataTable. give the gridview datasource as datatable.

Bind the gridview. Then you will be able to see the the entered values in gridview.

if everything is fine go for final submit and insert these values into database.

hope this helps u.. :)


Mohan Gajula

你好shivesh

一旦您根据自己的公式获得总计，
den fire d在提交按钮的单击事件上插入查询，
和den fire d select查询以在相同的click事件中从数据库中获取数据，
并提供数据源到gridview ...........

我希望它会帮助你.......


plz rply me .....

hello shivesh

once u get ur total according ur formulae,
den fire d insert query on click event of submit button,
and den fire d select query to fetch d data from database on same click event,
and provide datasource to the gridview...........

i hope it will hep u.......


plz rply me.....

请检查此代码

Please check this code

private DataTable CreateDataTable()
        {
            DataTable myDataTable = new DataTable();
            DataColumn myDataColumn;
            myDataColumn = new DataColumn();
            myDataColumn.DataType = Type.GetType("System.String");
            myDataColumn.ColumnName = "ItemName";
            myDataTable.Columns.Add(myDataColumn);
            myDataColumn = new DataColumn();
            myDataColumn.DataType = Type.GetType("System.String");
            myDataColumn.ColumnName = "ItemRate";
            myDataTable.Columns.Add(myDataColumn);
            myDataColumn = new DataColumn();
            myDataColumn.DataType = Type.GetType("System.String");
            myDataColumn.ColumnName = "ItemQty";
            myDataTable.Columns.Add(myDataColumn);
            //add records
            AddDataToTable("ItemName1", "ItemRate1", "ItemQty1", myDataTable);
            // In your case you can comment the above line and go like this
            //AddDataToTable(textBoxItemName.Text,ddlItemRate.SelectedValue, txtItemQty.Text,myDataTable);
            gvItems.DataSource = myDataTable;
            gvItems.DataBind();
            return myDataTable;
        }
        private void AddDataToTable(string strItemName, string strItemRate, string strItemQty, System.Data.DataTable myTable)
        {
            DataRow row;
            row = myTable.NewRow();
            row["ItemName"] = strItemName;
            row["ItemRate"] = strItemRate;
            row["ItemQty"] = strItemQty;
            myTable.Rows.Add(row);
        }

希望这有效:)

Hope this works :)

这篇关于使用GRID一对一地从Web表单插入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！