Forums
This topic is locked
asp.net vb web delete a row
Posted 30 Jun 2004 23:58:10
1
has voted
30 Jun 2004 23:58:10 Stu Robinson posted:
ASP.Net/VB Web application with an Access DB, I have been using Parnell/Martinez’s QuickPro Guide book.www.vpland.com/email_remove.aspx
I have a “Remove Me” web page where the user enters their UserID (email) and Password. I am able to delete a UserID and I receive a ‘You have been Deleted’ msg. I get a good msg no matter what I enter? No failure occurs?
I have messed around with both parms (User ID & Password) and it always ignores the second parm?
Suggestions or examples.
I would also like to delete a dependent row in another table when this first delete is done.
Thanks Stu
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %><MMelete
runat="server"
CommandText='<%# "DELETE FROM Users WHERE Users_ID=?" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_conn_veritas_email" %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_conn_veritas_email" %>'
Expression='<%# (Request.Form("Users_ID" <> Nothing) %>'
CreateDataSet="false"
SuccessURL='<%# "email_remove.aspx?as_msg=You Have Been Deleted" %>'
FailureURL='<%# "email_remove.aspx?as_msg=Error Your User ID & Password Could not be Deleted" %>'
Debug="true"
><Parameters>
<Parameter Name="@Users_ID" Value='<%# IIf((Request.Form("Users_ID" <> Nothing), Request.Form("Users_ID", "" %>' Type="WChar" />
</Parameters>
</MMelete>
<MM<img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>ageBind runat="server" PostBackBind="true" />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">