Inline Editing and Updating in GridView with check box

Gohil Jayendrasinh
10y
51.4k
0
1

Article

Editing and updating in gridview is very simple. But how can you edit when you use checkbox.

GirdView contain CheckBoxField that display checkbox in each item in GridView control. This column
Fields is commonly use to display field with Boolean value.

If you use SQL SERVER and the Datatype for this field is bit then no problem for binding CheckBoxField data in GridView.

But you Datatype char(1) or anything and you insert like "T" or "F" then CheckBoxField is not bind.

Hear we can see how to solve this type of problem.

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;
}
}
public int InsertUpdateData(string connectionString,string sql)
{
int i;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand com = new SqlCommand(sql, connection);
i = com.ExecuteNonQuery();
return i;
}
}
}

You Can read my other article on

http://www.c-sharpcorner.com

1) Gridview paging and multiple rows delete using checkbox.
2) How to create 3 tire application using LINQ
3) Binding Gridview using LINQ
4) How to create RSS (Really Simple Syndication)?
5) Gridview paging and multiple row delete using checkbox

Up Next

Ebook Download

View all

Printing in C# Made Easy

Read by 10.8k people

Download Now!

Learn

View all