»Dotnet Ads
»Message Boards
Message Boards
Dotnet Books
»Member Details
Register
Login
LogOut
Submit Code
Submit Jobs
Submit Projects
»Competition
Community
Winners
Prizes
Write For Us
Members
»Other Resources
Links
Dotnet Resources
|
Delete Gridview data after confirmation protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow dtgridit;
LinkButton lnk1;
switch(e.CommandName.ToUpper().ToString())
{
case "DELETE":
for (int i = 0; i < GridView1.Rows.Count; i++)
{
dtgridit = GridView1.Rows[i];
lnk1 = (LinkButton)dtgridit.FindControl("LinkButton1");
lnk1.Attributes.Add("onclick", "javascript:return confirm('All the details of the selected employee will be deleted permanently.Are you sure?');");
DoDeleteQuery(GridView1.Rows[i].Cells[0].Text.ToString());
}
break;
}
}
private void DoDeleteQuery(string qid)
{
try
{
SqlConnection sql3rdConn = new SqlConnection(conStr);
string DelqueryStr = "delete from employee where empname = '" + qid.Trim() + "'";
SqlCommand DelComm = new SqlCommand(DelqueryStr, sql3rdConn);
SqlDataAdapter sqlDelAdapter = new SqlDataAdapter(DelComm);
DataSet DeldataSet = new DataSet();
sqlDelAdapter.Fill(DeldataSet);
}
catch (Exception ex)
{
lblError.Text = ex.Message + "==" + ex.Source;
}
finally
{
}
}
|