Posts
In Coding Page
<%@ 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 Pagetitle>
<script type="text/javascript">
//javascript function for select and deselect all check boxes
function SelectAll(status)
{
var gridview = document.getElementById("GridView1");
for(var i = 1;i < gridview.rows.length; i++) { gridview.rows[i].cells[1].firstChild.checked = status; } }
script>
head>
<body>
<form id="form1" runat="server">
<div>
<asp:Button ID="btndelete" runat="server" OnClick="btndelete_Click" Style="z-index: 100;
left: 227px; position: absolute; top: 110px" Text="DeleteAll" />
<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None"
Style="z-index: 101; left: 225px; position: absolute; top: 140px" AutoGenerateColumns="False" DataKeyNames="eno" AutoGenerateDeleteButton="True">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:TemplateField >
<HeaderTemplate>
<asp:CheckBox ID="chkall" runat="server" onclick="javascript:SelectAll(this.checked);" />
<%-- Onclick event is used to call Java Script Function--%>
HeaderTemplate>
<ItemTemplate>
<asp:CheckBox ID="chk1" runat="server" />
ItemTemplate>
<HeaderStyle HorizontalAlign="Left" />
<ItemStyle HorizontalAlign="Left" />
asp:TemplateField>
<asp:BoundField DataField="eno" HeaderText="EmpNo" ReadOnly="True" SortExpression="eno" />
<asp:BoundField DataField="ename" HeaderText="ename" SortExpression="ename" />
<asp:BoundField DataField="sal" HeaderText="sal" SortExpression="sal" />
Columns>
asp:GridView>
<asp:CheckBox ID="CheckBox1" runat="server" Style="z-index: 103; left: 511px; position: absolute;
top: 175px" />
div>
form>
body>
html>
Set Following GridView Properties
DatakeyNames=eno(set Primary Key colume name)
In .CS File
using System.Data.Odbc;
public partial class _Default : System.Web.UI.Page
{
string str;
OdbcConnection myConn = new OdbcConnection("driver={Mysql odbc 3.51 driver};user id=root;password=admin;server=localhost;database=temp");
protected void Page_Load(object sender, EventArgs e)
{
btndelete.Attributes.Add("onclick", "return confirmDelete(this.form1);");
if (IsPostBack == false)
{
str = "select * from emp1";
getdata(str);
}
}
public void getdata(string s)
{
OdbcDataAdapter da = new OdbcDataAdapter(s, myConn);
DataSet ds = new DataSet();
da.Fill(ds, "raji");
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void btndelete_Click(object sender, EventArgs e)
{
string ds = "";
foreach (GridViewRow r in GridView1.Rows)
{
CheckBox cb = (CheckBox)r.FindControl("chk1");
if (cb.Checked)
{
int eno = Convert.ToInt32(GridView1.DataKeys[r.RowIndex].Value);
ds = "delete from emp1 where eno=" + eno;
OdbcCommand cmd = new OdbcCommand(ds, myConn);
myConn.Open();
cmd.ExecuteNonQuery();
myConn.Close();
}
}
getdata("select * from emp1");
}
}
0 comments:
Respects for your's Questions & Opinions