I am giving 1 Ex. When i delete a record, it will ask, Are You Sure to Delete if?
<asp:GridView ID="GridView1" AllowPaging="true" AutoGenerateColumns="false"
runat="server" ShowFooter="true" HeaderStyle-BackColor="Red"
OnRowEditing="EditStudent" OnPageIndexChanging="OnPaging"
OnRowUpdating="StudUpdate" OnRowCancelingEdit="CancelEdit" PageSize="10" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="LnkBtn" runat="server" CommandArgument='<%# Eval("StudentId")%>' OnClientClick="return confirm('Do you Want to Delete it?')" Text="Delete" OnClick="DeleteStudent"></asp:LinkButton>
</ItemTemplate>
<FooterTemplate><asp:Button ID="AddBt" runat="server" Text="AddNewStudent" OnClick="AddNewStudent" /></FooterTemplate>
</asp:TemplateField>
protected void DeleteStudent(object sender, EventArgs args)
{
LinkButton LnkRemove = (LinkButton)sender;
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
con.Open();
cmd.CommandText = "Delete from Student where StudentId=@p1;" + "select StudentId,FirstName,LastName,Address,StudMail,StudPhone,Gender from Student";
cmd.Parameters.Add("@p1", SqlDbType.NChar).Value = LnkRemove.CommandArgument;
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds,"Student");
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
BindData();
}
protected void OnPaging(object sender, GridViewPageEventArgs e)
{
BindData();
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
} Premalatha
Software Engineer
Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator