using System;
using
System.Collections.Generic;
using System.Linq;
using System.Web;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using
System.Data.SqlClient;
using
System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Xml.Linq;
public partial class Default2 : System.Web.UI.Page
{
SqlConnection
con;
protected void Page_Load(object
sender, EventArgs e)
{
con = new
SqlConnection("give
connection name");
if
(!IsPostBack)
{
Bindtablename();
}
}
protected void Bindtablename()
{
con.Open();
SqlCommand
cmd = new SqlCommand("Select * from tablename", con);
cmd.ExecuteNonQuery();
SqlDataAdapter
da = new SqlDataAdapter(cmd);
DataSet
ds = new DataSet();
da.Fill(ds);
//Binding
data to gridview
gv1.DataSource = ds;
gv1.DataBind();
con.Close();
}
protected void gv1_RowDataBound(object
sender, GridViewRowEventArgs e)
{
if
(e.Row.RowType == DataControlRowType.DataRow)
{
string
(give field name for example uname empname) = Convert.ToString(DataBinder.Eval(e.Row.DataItem,
"(give field name for example uname
empname)"));
LinkButton
delete = (LinkButton)e.Row.FindControl("delete");
deletebtnresult.Attributes.Add("onclick", "javascript:return
rahi('" + (give field name for
example uname empname) + "')");
}
}
protected void delete_Click(object
sender, EventArgs e)
{
LinkButton
btnlink = sender as LinkButton;
GridViewRow
gvrow = btnlink.NamingContainer as GridViewRow;
int uid
= Convert.ToInt32(gv1.DataKeys[gvrow.RowIndex].Value.ToString());
string
uname = gvrow.Cells[0].Text;
con.Open();
SqlCommand
cmd = new SqlCommand("delete from table name where (give field name for
example uid )=" + (give field name for
example uname empname), con);
int
result = cmd.ExecuteNonQuery();
con.Close();
if (result == 1)
{
Bindtablename();
ScriptManager.RegisterStartupScript(this, this.GetType(),
"alertmessage", "javascript:alert('" + uname + " Deleted
successfully')", true);
}
}
public string linkdele { get;
set; }
}
Default.aspx* page=========
<script language="javascript" type="text/javascript" >
function
rahi((give field name for example uname ))
{
var
result = confirm('Are you sure you want to delete '
+ (give field name for example uname ) + ' tablename');
if
(result)
{
return
true;
}
else
{
return
false;
}
}
</script>
<div>
<asp:GridView ID="gv1" runat="server" DataKeyNames="uid"
AutoGenerateColumns="false" OnRowDataBound="gv1_RowDataBound"
>
<Columns>
<asp:TemplateField
HeaderText="
udetails Delete ">
<ItemTemplate>
<asp:LinkButton ID="delete" runat="server" OnClick="delete_Click" >
Delete User
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="uname" HeaderText="uname" />
<asp:BoundField DataField="FName" HeaderText="FName" />
<asp:BoundField DataField="LName" HeaderText="LName" />
</Columns>
</asp:GridView>
</div>

No comments:
Post a Comment