Hello Friends,
On my web form there is one DropDown List Box which contains different Items..
and one TextBox, user will Enter Quantity in textBox....
Now problem is that I want to Add Item and Qty in DataGrid on the Same Page when I click on ADD Button.........

Later on Data in DataGrid will go to DataBase when user Clicks on Send Button.....
So pls Help me....I will be Thankful to u...(A'm using Visual Studio 2005 and SQL Server 2005)

9 Years
Discussion Span
Last Post by dilipv

you can do such batch operations using table adapter, but you need to store the datatable in session i guess. So instead of adding to the database you can add to the datatable and at the end make a batch update to the database. But for the web applications this seems illogical. I suggest that you use update panel and run insert queries against database each time new record added.


hi mukund_007,
For doing the same you need to add Textbox, DropDownList and Button and datagrid to aspx page as follows.

<asp: TextBox ID ="txtBox"  runat ="server"></asp: TextBox>
<asp: DropDownList ID="ddlist" runat ="server" >
<asp: ListItem Text ="1" Value ="1"></asp: ListItem>
<asp: ListItem Text ="2" Value ="2"></asp: ListItem>
<asp: ListItem Text ="3" Value ="3"></asp: ListItem>
<asp: ListItem Text ="4" Value ="4"></asp: ListItem>
</asp: DropDownList>
<asp: Button ID="submit" runat ="server" Text="submit" OnClick="submit_Click"/>
<asp: DataGrid ID="dgrid" runat ="server" ></asp: DataGrid>

You need to add your datagrid table to session["SampleDataTable"]; on page load.
Then on the Button click event you write as follows.

protected void submit_Click(object sender, EventArgs e)
        DataTable dt = new DataTable("ani");
        dt = (DataTable)Session["SampleDataTable"];
        if (dt == null)
            dt.Columns.Add(new DataColumn("TextBox_Value", typeof(String)));
            dt.Columns.Add(new DataColumn("Item_Name", typeof(String)));            
        DataRow dr = dt.NewRow();
        dr[0] = txtBox.Text;
        dr[1] = ddlist.SelectedValue;
        dgrid.DataSource = dt;
        Session["SampleDataTable"] = dt;        

After finishing of all the batch operation you need to update database to reflect the change in database.
Hope this will help you.
Thakns & Regards

Edited by mike_2000_17: Fixed formatting

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.