Hi @seem,
I have made a small snippet for you have a look there
Html
<div>
<asp:ListView ID="lvUsers" runat="server">
<ItemTemplate>
<asp:CheckBox ID="chkUser" runat="server" /><asp:Label ID="lblUserName" runat="server"
Text='<%#Eval("Name") %>' ></asp:Label><br />
</ItemTemplate>
</asp:ListView>
<asp:Button ID="btnSave" runat="server" Text="Save" OnClick="Save" />
</div>
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.lvUsers.DataSource = this.GetData();
this.lvUsers.DataBind();
}
}
private DataTable GetData()
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[2] { new DataColumn("UserId"), new DataColumn("Name") });
dt.Rows.Add(1, "Ashutosh");
dt.Rows.Add(2, "Vipin");
dt.Rows.Add(3, "Sushil");
return dt;
}
protected void Save(object sender, EventArgs e)
{
foreach (ListViewDataItem item in this.lvUsers.Items)
{
if (item.ItemType == ListViewItemType.DataItem)
{
CheckBox chkUser = item.FindControl("chkUser") as CheckBox;
if (chkUser.Checked)
{
string name = (item.FindControl("lblUserName") as Label).Text;
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ConnectionString);
SqlCommand cmd = new SqlCommand("insert into Table_Users values(@Name)", con);
cmd.Parameters.AddWithValue("@Name", name);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
}
Namespaces:
using System;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
