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)

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;
        dt.Rows.Add(dr);
        dgrid.DataSource = dt;
        dgrid.DataBind();
        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
Dilipv

Edited 3 Years Ago by mike_2000_17: Fixed formatting

This article has been dead for over six months. Start a new discussion instead.