HTML
<asp:DataList ID="DataList1" runat="server">
<ItemTemplate>
Name :
<asp:TextBox ID="txtName" Text='<%# Eval("Name") %>' runat="server" />
<br />
Email :
<asp:TextBox ID="txtEmail" runat="server" Text='<%# Eval("Email") %>'/>
</ItemTemplate>
</asp:DataList>
<hr />
<asp:Button Text="Save" OnClick="Save" runat="server" />
Namespace
using System.Data;
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[2]{new DataColumn("Name"),
new DataColumn("Email")});
dt.Rows.Add("Abc", "Abc@Abc.com");
dt.Rows.Add("Pqr", "Pqr@Pqr.com");
this.DataList1.DataSource = dt;
this.DataList1.DataBind();
}
}
protected void Save(object sender, EventArgs e)
{
string name = string.Empty;
string email = string.Empty;
// This will Update and insert one by one in Sql. You can Insert or Update as per your requirement
foreach (DataListItem item in this.DataList1.Items)
{
name = (item.FindControl("txtName") as TextBox).Text;
email = (item.FindControl("txtEmail") as TextBox).Text;
// For inserting name and email
this.Insert(name, email);
// For Updating name and email
this.Update(name, email);
}
}
private void Insert(string name, string email)
{
// Write your code for Insert by passing name and email in the insert query
}
private void Update(string name, string email)
{
// Write your code for update by passing name and email in the update query
}