Step 1: Your .aspx page like this.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div align="center">
<table align="center">
<tr>
<td>
<asp:GridView ID="gvuserinfo" runat="server" AllowPaging="True" AutoGenerateColumns="False"
AutoGenerateEditButton="True"
OnPageIndexChanging="gvuserinfo_PageIndexChanging"
onrowcancelingedit="gvuserinfo_RowCancelingEdit"
onrowediting="gvuserinfo_RowEditing"
onrowupdating="gvuserinfo_RowUpdating">
<Columns>
<asp:BoundField DataField="userid" HeaderText="Userid" ReadOnly="True" >
</asp:BoundField>
<asp:BoundField HeaderText="User Name" DataField="username" />
<asp:CheckBoxField DataField="allowplan" Text="" HeaderText="Allowed For Plan" />
</Columns>
</asp:GridView>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblmessage" runat="server" ForeColor="Red"></asp:Label>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
Step 2: your .cs file like this
using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
#region :: Add using ::
using System.Collections;
#endregion
public partial class _Default : System.Web.UI.Page
{
#region :: Variable Declaration::
// DataAccess Class.
clsGeneral objGeneral = new clsGeneral();
#endregion
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//Bind The Gridview.
BindGridView();
}
}
#region :: Bind GridView ::
private void BindGridView()
{
string connection = objGeneral.Getconnection();
string sql = "SELECT userid, username, allowforfreeplan FROM UserInfo ORDER BY username";
DataTable dtUserInfo = new DataTable();
dtUserInfo = objGeneral.SelectRows(dtUserInfo, connection, sql);
/*Create new column for database.
* this column is user for bind ChecBoxField.
*/
DataColumn column = new DataColumn();
column.DataType = System.Type.GetType("System.Boolean");
column.ColumnName = "allowplan";
//Add column in table.
dtUserInfo.Columns.Add(column);
if ((dtUserInfo != null) && (dtUserInfo.Rows.Count > 0))
{
for (int i = 0; i < dtUserInfo.Rows.Count; i++)
{
string type = dtUserInfo.Rows[i]["allowforfreeplan"].ToString().ToUpper();
if (type == "T")
{
dtUserInfo.Rows[i]["allowplan"] = true;
}
else
{
dtUserInfo.Rows[i]["allowplan"] = false;
}
}
gvuserinfo.DataSource = dtUserInfo;
gvuserinfo.DataBind();
}
}
#endregion
protected void gvuserinfo_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvuserinfo.PageIndex = e.NewPageIndex;
BindGridView();
}
protected void gvuserinfo_RowEditing(object sender, GridViewEditEventArgs e)
{
gvuserinfo.EditIndex = e.NewEditIndex;
BindGridView();
}
protected void gvuserinfo_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
gvuserinfo.EditIndex = -1;
BindGridView();
}
protected void gvuserinfo_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int userid = Convert.ToInt32(gvuserinfo.Rows[e.RowIndex].Cells[1].Text);
TextBox txtname = (TextBox)gvuserinfo.Rows[e.RowIndex].Cells[2].Controls[0];
CheckBox cb = (CheckBox)gvuserinfo.Rows[e.RowIndex].Cells[3].Controls[0];
string allowforfree = string.Empty;
if (cb.Checked == true)
{
allowforfree = "T";
}
else
{
allowforfree = "F";
}
string sql = "UPDATE [dbo].[UserInfo] SET [username] = '" + txtname.Text + "',[allowforfreeplan] = '" + allowforfree + "'";
sql += " WHERE [dbo].[UserInfo].[userid] = " + userid;
string connection = objGeneral.Getconnection();
int i = objGeneral.InsertUpdateData(connection, sql);
if (i == 1)
{
// lblmessage.Text = "Record Updated Succesfully ...";
}
gvuserinfo.EditIndex = -1;
BindGridView();
}
}
Step 3: Your DataAccess Class like.
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
/// <summary>
/// Summary description for clsGeneral
/// </summary>
public class clsGeneral
{
protected string test = ConfigurationManager.ConnectionStrings["SQLCONNECTION"].ToString();
public clsGeneral()
{
//
// TODO: Add constructor logic here
//
}
public string Getconnection()
{
return test;
}
public DataTable SelectRows(DataTable datatable,string connectionString, string queryString)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(queryString, connection);
adapter.Fill(datatable);
return datatable;
}
}