All About GridView CRUD without 'C' (Read,Update,Delete) function ASP.Net
Gridview is a powerful tools for developer to view the records from database, for example like user manager page.
Today i want to show how to delete, and modify in gridview plus to have a user friendly viewing functionality about the a Total records that user want to show on GridView and total records of all data.
Lets Try..
Happy coding...
By Mohd Zulkamal
NOTE : – If You have Found this post Helpful, I will appreciate if you can Share it on Facebook, Twitter and Other Social Media Sites. Thanks =)
Today i want to show how to delete, and modify in gridview plus to have a user friendly viewing functionality about the a Total records that user want to show on GridView and total records of all data.
Lets Try..
The ASP.NET Page
<asp:Label ID="LErrorMessage" ForeColor="Red" runat="server"></asp:Label>
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CssClass="mainTable"
BorderColor="Gray" BorderStyle="Solid" BorderWidth="1px"
AllowPaging="True" PageSize="15"
Width="864px" EmptyDataText="Tiada Rekod Dijumpai" OnRowDeleting="GridView1_RowDeleting"
OnPageIndexChanging="GridView1_PageIndexChanging" OnRowDataBound="addJavascript"
OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
<RowStyle BorderColor="Gray" BorderStyle="Solid" BorderWidth="1px" />
<AlternatingRowStyle BackColor="#F7F6F3" BorderColor="Gray" BorderStyle="Solid" BorderWidth="1px"
ForeColor="#333333" />
<Columns>
<asp:TemplateField HeaderText="No.">
<ItemTemplate>
<%# Container.DataItemIndex + 1 %>
</ItemTemplate>
<ItemStyle Width="20px" BorderColor="#CCCCCC" BorderStyle="Solid" BorderWidth="1px" />
</asp:TemplateField>
<asp:BoundField DataField="UserId" HeaderText="User ID">
<ItemStyle Width="100px" BorderColor="#CCCCCC" BorderStyle="Solid" BorderWidth="1px" />
</asp:BoundField>
<asp:BoundField DataField="First_Name" HeaderText="First Name">
<ItemStyle Width="150px" BorderColor="#CCCCCC" BorderStyle="Solid" BorderWidth="1px" />
</asp:BoundField>
<asp:BoundField DataField="Last_Name" HeaderText="Last Name">
<ItemStyle Width="100px" BorderColor="#CCCCCC" BorderStyle="Solid" BorderWidth="1px" />
</asp:BoundField>
<asp:BoundField DataField="IsLockedOut" HeaderText="is Lock">
<ItemStyle Width="80px" BorderColor="#CCCCCC" BorderStyle="Solid" BorderWidth="1px" />
</asp:BoundField>
<asp:CommandField CausesValidation="False" ShowDeleteButton="True">
<ItemStyle Width="50px" BorderColor="#CCCCCC" BorderStyle="Solid" BorderWidth="1px" />
</asp:CommandField>
<asp:CommandField SelectText="Modify" CausesValidation="false" ShowSelectButton="True">
<ItemStyle Width="50px" BorderColor="#CCCCCC" BorderStyle="Solid" BorderWidth="1px" />
</asp:CommandField>
</Columns>
<HeaderStyle ForeColor="White" BackColor="#6699CC" Font-Bold="true" />
<PagerStyle BackColor="#6699CC" ForeColor="White" />
</asp:GridView>
<br />
<br />
<asp:Panel ID="PanelDropDownGVPage" runat="server" Visible="false">
Total users per page :
<asp:DropDownList ID="DropDownList1" CssClass="defaultSelect" Width="50px" runat="server"
AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<br />
</asp:Panel>
Shows records
<asp:Literal ID="LRekodShow" runat="server"></asp:Literal> from
<asp:Literal ID="LiteralTotalRekod" runat="server"></asp:Literal> users
<br />
The JavaScript - put in header
<script type="text/javascript">
function ConfirmOnDelete(item) {
if (confirm("Are you sure to remove " + item + "?") == true)
return true;
else
return false;
}
</script>
The Code Behind
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindGridview();
}
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
BindGridview();
}
private void BindGridview()
{
string err = "";
DataTable UsersTable = GetAllUsersInformation(ref err);
if (err.Trim() != "")
{
LErrorMessage.Text = err;
return;
}
int pageIndex = GridView1.PageIndex;
if (UsersTable.Rows.Count > GridView1.PageSize)
{
PanelDropDownGVPage.Visible = true;
if (pageIndex == 0)
{
LRekodShow.Text = "1 - " + GridView1.PageSize.ToString();
}
else
{
int pageSize = GridView1.PageSize;
int numberRecord = pageIndex * pageSize;
int balance = UsersTable.Rows.Count - numberRecord;
int startRecordToShow = numberRecord + 1;
if (balance > GridView1.PageSize)
{
LRekodShow.Text = startRecordToShow.ToString() + " - " + (GridView1.PageSize + numberRecord).ToString();
}
else
{
LRekodShow.Text = startRecordToShow.ToString() + " - " + (balance + numberRecord).ToString();
}
}
}
else if (UsersTable.Rows.Count == 0)
{
LRekodShow.Text = "0";
}
else
{
LRekodShow.Text = "1 - " + UsersTable.Rows.Count.ToString();
}
GridView1.DataSource = UsersTable;
GridView1.DataBind();
string[] listAll = { "10", "15", "25", "35", "50" };
DropDownList1.DataSource = listAll;
DropDownList1.DataBind();
DropDownList1.SelectedValue = GridView1.PageSize.ToString();
LiteralTotalRekod.Text = UsersTable.Rows.Count.ToString();
}
private DataTable GetAllUsersInformation(ref string err)
{
DataTable users = new DataTable();
users.Columns.Add("UserId", typeof(string));
users.Columns.Add("First_Name", typeof(string));
users.Columns.Add("Last_Name", typeof(string));
users.Columns.Add("IsLockedOut", typeof(string));
DataRow row;
for (int i = 0; i < 100; i++)
{
row = users.NewRow();
row["UserId"] = "AHMAD" + i.ToString();
row["First_Name"] = "AHMAD FIRST NAME" + i.ToString();
row["Last_Name"] = "AHMAD LAST NAME" + i.ToString();
row["IsLockedOut"] = "FALSE";
users.Rows.Add(row);
}
return users;
}
protected void addJavascript(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowState != DataControlRowState.Edit) // check for RowState
{
if (e.Row.RowType == DataControlRowType.DataRow) //check for RowType
{
string id = e.Row.Cells[1].Text; // Get the id to be deleted
LinkButton lb = (LinkButton)e.Row.Cells[5].Controls[0]; //cast the ShowDeleteButton link to linkbutton
if (lb != null)
{
//add script to link button
lb.Attributes.Add("onclick", "return ConfirmOnDelete('User " + id + "');"); //attach the JavaScript function with the ID as the paramter
}
}
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string err = "";
//string UserID = GridView1.Rows[e.RowIndex].Cells[1].Text;
string UserID = e.Values["UserId"].ToString();
//do logic delete based on user id
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
//modifi user action
//get user id from selected row
string UserID = GridView1.SelectedRow.Cells[1].Text;
//do logic to modify user
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string val = DropDownList1.SelectedValue.ToString();
GridView1.PageSize = Convert.ToInt16(val);
BindGridview();
}
The Output
Happy coding...
By Mohd Zulkamal
NOTE : – If You have Found this post Helpful, I will appreciate if you can Share it on Facebook, Twitter and Other Social Media Sites. Thanks =)
.bmp)
