How to show Confirmation message box?

[Ron Clarke]

I have a small web app that displays data from a SQL Server database. Using
a DataGrid control on a page, the user can delete a row from the database.
This works fine. But I want to prompt the user for confirmation ("Are you
sure...") before deleting the record. How can I do this from the ASP.NET
code? Since the C# code is server-side, is there a way to display a Yes/No
type of message box and only take action if the users clicks the "Yes"
button? I'm new to web development, so any and all help is appreciated.

Here is the deletion message handler; I want to prompt the user for
confirmation before the deletion code executes:

private void dgridProfiles_Delete(object source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
[** How do I prompt the user here??]
[If user said yes, then...]
String profID = e.Item.Cells[0].Text.Trim();
String deleteCmd = "DELETE from Profile where ProfileID = @profID";
string connstr =
ConfigurationSettings.AppSettings["BLConnectionString"];
SqlConnection connection = new SqlConnection(connstr);
SqlCommand myCommand = new SqlCommand(deleteCmd, connection);
myCommand.Parameters.Add(new SqlParameter("@profID", SqlDbType.Char,
10));
myCommand.Parameters["@profID"].Value =
dgridProfiles.DataKeys[(int)e.Item.ItemIndex];
connection.Open();
try
{
myCommand.ExecuteNonQuery();
dgridProfiles.EditItemIndex = -1;
LabelMessageArea.Text = "Profile deleted.";
}
catch (SqlException )
{
LabelMessageArea.Text = "ERROR: Could not delete record.";
}
finally
{
connection.Close();
}
BindGrid();
}

[end code sample]
Thanks!

[Jeff Louie]

Ron... You can do this with client side java script.

http://www.geocities.com/jeff_louie/net_delete.htm

Regards,
Jeff

But I want to prompt the user for confirmation ("Are you

sure...") before deleting the record. How can I do this from the ASP.NET
code? <

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Steve C. Orr [MVP, MCSD]]

Here's an example that should answer your question:
http://www.dotnetjunkies.com/HowTo/1...EB07C94A8.dcik

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
Hire top-notch developers at http://www.able-consulting.com

"Ron Clarke" <ro********@hp.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

I have a small web app that displays data from a SQL Server database. Using a DataGrid control on a page, the user can delete a row from the database.
This works fine. But I want to prompt the user for confirmation ("Are you
sure...") before deleting the record. How can I do this from the ASP.NET
code? Since the C# code is server-side, is there a way to display a Yes/No
type of message box and only take action if the users clicks the "Yes"
button? I'm new to web development, so any and all help is appreciated.

Here is the deletion message handler; I want to prompt the user for
confirmation before the deletion code executes:

private void dgridProfiles_Delete(object source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
[** How do I prompt the user here??]
[If user said yes, then...]
String profID = e.Item.Cells[0].Text.Trim();
String deleteCmd = "DELETE from Profile where ProfileID = @profID";
string connstr =
ConfigurationSettings.AppSettings["BLConnectionString"];
SqlConnection connection = new SqlConnection(connstr);
SqlCommand myCommand = new SqlCommand(deleteCmd, connection);
myCommand.Parameters.Add(new SqlParameter("@profID", SqlDbType.Char,
10));
myCommand.Parameters["@profID"].Value =
dgridProfiles.DataKeys[(int)e.Item.ItemIndex];
connection.Open();
try
{
myCommand.ExecuteNonQuery();
dgridProfiles.EditItemIndex = -1;
LabelMessageArea.Text = "Profile deleted.";
}
catch (SqlException )
{
LabelMessageArea.Text = "ERROR: Could not delete record.";
}
finally
{
connection.Close();
}
BindGrid();
}

[end code sample]
Thanks!

[Jeff Louie]

Ron... You can do this with client side java script.

http://www.geocities.com/jeff_louie/net_delete.htm

Regards,
Jeff

But I want to prompt the user for confirmation ("Are you

sure...") before deleting the record. How can I do this from the ASP.NET
code? <

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Steve C. Orr [MVP, MCSD]]

Here's an example that should answer your question:
http://www.dotnetjunkies.com/HowTo/1...EB07C94A8.dcik

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
Hire top-notch developers at http://www.able-consulting.com

"Ron Clarke" <ro********@hp.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

I have a small web app that displays data from a SQL Server database. Using a DataGrid control on a page, the user can delete a row from the database.
This works fine. But I want to prompt the user for confirmation ("Are you
sure...") before deleting the record. How can I do this from the ASP.NET
code? Since the C# code is server-side, is there a way to display a Yes/No
type of message box and only take action if the users clicks the "Yes"
button? I'm new to web development, so any and all help is appreciated.

Here is the deletion message handler; I want to prompt the user for
confirmation before the deletion code executes:

private void dgridProfiles_Delete(object source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
[** How do I prompt the user here??]
[If user said yes, then...]
String profID = e.Item.Cells[0].Text.Trim();
String deleteCmd = "DELETE from Profile where ProfileID = @profID";
string connstr =
ConfigurationSettings.AppSettings["BLConnectionString"];
SqlConnection connection = new SqlConnection(connstr);
SqlCommand myCommand = new SqlCommand(deleteCmd, connection);
myCommand.Parameters.Add(new SqlParameter("@profID", SqlDbType.Char,
10));
myCommand.Parameters["@profID"].Value =
dgridProfiles.DataKeys[(int)e.Item.ItemIndex];
connection.Open();
try
{
myCommand.ExecuteNonQuery();
dgridProfiles.EditItemIndex = -1;
LabelMessageArea.Text = "Profile deleted.";
}
catch (SqlException )
{
LabelMessageArea.Text = "ERROR: Could not delete record.";
}
finally
{
connection.Close();
}
BindGrid();
}

[end code sample]
Thanks!