How to Active-Inactive User in GridView in Asp.Net
Here we are binding a GridView to showing all user details and we can enable and disable user to block the user's login in the system.
We are using Image Button's CommandName Propery to Select then it works on SelectedIndexChanging / SelectedIndexChanged event, if you use CommandName as Update then it works on Rowupdating / RowUpdated event and if you use CommandName as Edit then it works on RowEditing event
Points Of Remember:
1. Fire GridView's event RowDataBound.
2. Fire GridView's event SelectedIndexChanging.
3. Add a ImageButton in GridView ItemTemplate.
4. Set ImageButton's CommandName propery to Select.
5. Set GridView's DataKeyNames Property to record ID (ID=primary/unique key of student table).
6. Add namespace System.Data and System.Data.SqlClient in your C# page.
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Active-Inctive User</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1"
runat="server" AutoGenerateColumns="False"
OnRowDataBound="GridView1_RowDataBound" CellPadding="4"
DataKeyNames="ID"
OnSelectedIndexChanging="GridView1_SelectedIndexChanging" ForeColor="#333333">
<AlternatingRowStyle BackColor="White"
ForeColor="#284775" />
<Columns>
<asp:BoundField DataField="Name"
HeaderText="Name" />
<asp:BoundField DataField="Branch"
HeaderText="Branch" />
<asp:BoundField DataField="City"
HeaderText="City" />
<asp:BoundField DataField="Active"
HeaderText="Active" />
<asp:TemplateField>
<ItemTemplate>
<asp:ImageButton ID="img_user"
runat="server" CommandName="Select"
ImageUrl='<%# Eval("Active"
)
%>' Width="20px" Height="20px"
/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<HeaderStyle BackColor="#5D7B9D"
Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#F7F6F3"
ForeColor="#333333" />
</asp:GridView>
</div>
</form>
</body>
C# Codes :
using System.Data;
using System.Data.SqlClient;
public partial class test_Active : System.Web.UI.Page
{
// sql connection
SqlConnection con = new SqlConnection( @"Data Source=JITESH-PC\SQL;Initial
Catalog=db_Student;Integrated Security=True");
protected void Page_Load(object sender,
EventArgs e)
{
if (!IsPostBack)
{
BindGridView();
}
}
//method for binding GridView
protected void BindGridView()
{
DataTable dt = new DataTable
();
SqlDataAdapter da = new SqlDataAdapter( "Select ID,Name,Branch,City,Active
from tbl_student", con);
con.Open();
da.Fill(dt);
con.Close();
if (dt.Rows.Count > 0)
{
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
// checking active/inactive and adding image url
protected void GridView1_RowDataBound(object sender,
GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
ImageButton img = (ImageButton)e.Row.FindControl("img_user");
if (e.Row.Cells[3].Text == "Active")
{
img.ImageUrl = "~/Images/active.png";
}
else
{
img.ImageUrl = "~/Images/inactive.png";
}
}
}
//save updated record in database
protected void GridView1_SelectedIndexChanging(object sender,
GridViewSelectEventArgs e)
{
// id of edit row
string id = GridView1.DataKeys[e.NewSelectedIndex].Value.ToString();
string status = GridView1.Rows[e.NewSelectedIndex].Cells[3].Text;
if (status == "Active")
{
status="Inactive";
}
else
{
status = "Active";
}
// update record
SqlCommand cmd = new SqlCommand( "update tbl_student set Active='" +status+"'
where ID=" + id, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
BindGridView();
}
Output:
