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