Hello. When I Click my submit button. The data does not get added in to the database. I don't get an error messsage This is my code:
----------------------------------------------------------------
<%@ Page Language="
vb" AutoEventWireup="false" Codebehind="Register.aspx.
vb" Inherits="AIA.Register"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>Register</title>
<meta content="Microsoft Visual Studio.NET 7.0" name="GENERATOR">
<meta content="Visual Basic 7.0" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
<Script = Server>
Public Sub AddMember(seneder as Object, e As EventArgs)
// Establish Connection
Dim myConnection As New SqlConnection
Dim SQLServer As String = "Provider=SQLOLEDB.1;Data Source=localhost"
Dim DataConn as SQLConnection
DataConn = new SQLConnection(SQLServer)
// Call to store procedure which will be executed in a moment
dbCommand = New SQLCommand("sp_add_member",DataConn)
// Our command type is for a store procedure. Not a string SQL statement
dbCommand.CommandType = CommandType.StoredProcedure
// We are inserting from a textboxes which will reference
// the stored proc
dbCommand.Parameters.Add(New SQLParameter("@MemFirstName", SQLDbType.nvarchar,50))
dbCommand.Parameters("@MemFirstName").Value = txtFirstName.Text.trim()
dbCommand.Parameters.Add(New SQLParameter("@MemLastName", SQLDbType.nvarchar,50))
dbCommand.Parameters("@MemLastName").Value = txtLastName.Text.trim()
dbCommand.Parameters.Add(New SQLParameter("@MemSpouseName", SQLDbType.nvarchar,50))
dbCommand.Parameters("@MemSpouseName").Value = txtSpouseName.Text.trim()
dbCommand.Parameters.Add(New SQLParameter("@MemEmail", SQLDbType.nvarchar,50))
dbCommand.Parameters("@MemEmail").Value = txtAddress.Text.trim()
dbCommand.Parameters.Add(New SQLParameter("@MemPhone", SQLDbType.nvarchar,50))
dbCommand.Parameters("@MemPhone").Value = txtCity.Text.trim()
dbCommand.Parameters.Add(New SQLParameter("@MemAddress", SQLDbType.nvarchar,50))
dbCommand.Parameters("@MemAddress").Value = txtState.Text.trim()
dbCommand.Parameters.Add(New SQLParameter("@MemChildrenNames", SQLDbType.nvarchar,50))
dbCommand.Parameters("@MemChildrenNames").Value = txtEmail.Text.trim()
dbCommand.Parameters.Add(New SQLParameter("@MemChildrenNames", SQLDbType.nvarchar,50))
dbCommand.Parameters("@MemChildrenNames").Value = txtPhone.Text.trim()
dbCommand.Parameters.Add(New SQLParameter("@MemChildrenNames", SQLDbType.nvarchar,50))
dbCommand.Parameters("@MemChildrenNames").Value = txtChildren.Text.trim()
// Open connection and execute.
// This is not a query so ExecuteNonQuery is used
DataConn.open()
dbCommand.ExecuteNonQuery
DataConn.close
//Response.Write("New person successfully added!")
//Catch SQLexc As SqlException
//Response.Write("Insert Failed. Error Details are: " & SQLexc.ToString())
End Sub
</Script>
</HEAD>
<body bgColor="#ccffff" MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<table>
<tr>
<td>
<h2 align="center">AIA MEMBERSHIP[/h2]
</td>
</tr>
<tr>
<td>
Your membership dues are the life-line of AIA. In order to keep all function
ticket costs fairly low, all AIA functions (except India Day) are subsidized
from your yearly membership dues. We would appreciate your renewal of the year
2003 membership as soon as possible. If you have not already done so, please
complete the enclosed 2003 membership form and mail it with your check of $25
($10 for students and temporary resident â non voting members) to AIA,
</td>
</tr>
<tr>
<td>
($10.00Family-For families temporarily in Madison â Non Voting ___Life
Membership ($300-; Individual or Family)
</td>
</tr>
<tr>
</tr>
<tr align="center">
<td>
<asp:Label id="Label4" runat="server">First Name</asp:Label>
<asp:TextBox id="txtFirstName" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator id="RequiredFieldValidator1" ControlToValidate="txtFirstName" Text="Required Field!" runat="server" />
</td>
</tr>
<tr align="center">
<td>
<asp:Label id="Label9" runat="server">Last Name</asp:Label>
<asp:TextBox id="txtLastName" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator id="Requiredfieldvalidator2" ControlToValidate="txtLastName" Text="Required Field!" runat="server" />
</td>
</tr>
<tr align="center">
<td>
<asp:Label id="Label3" runat="server">Spouse Name</asp:Label>
<asp:TextBox id="txtSpouseName" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator id="Requiredfieldvalidator3" ControlToValidate="txtSpouseName" Text="Required Field!" runat="server" />
</td>
</tr>
<tr align="center">
<td>
<asp:Label id="Label8" runat="server">Address</asp:Label>
<asp:TextBox id="txtAddress" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator id="Requiredfieldvalidator4" ControlToValidate="txtAddress" Text="Required Field!" runat="server" />
</td>
</tr>
<tr align="center">
<td>
<asp:Label id="Label6" runat="server">City</asp:Label>
<asp:TextBox id="txtCity" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator id="Requiredfieldvalidator5" ControlToValidate="txtCity" Text="Required Field!" runat="server" />
</td>
</tr>
<tr align="center">
<td>
<asp:Label id="Label2" runat="server">Zip</asp:Label>
<asp:TextBox id="txtZip" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator id="Requiredfieldvalidator6" ControlToValidate="txtZip" Text="Required Field!" runat="server" />
</td>
</tr>
<tr align="center">
<td>
<asp:Label id="Label7" runat="server">Email</asp:Label>
<asp:TextBox id="txtEmail" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator id="Requiredfieldvalidator7" ControlToValidate="txtEmail" Text="Required Field!" runat="server" />
</td>
</tr>
<tr align="center">
<td>
<asp:Label id="Label1" runat="server">Phone Number</asp:Label>
<asp:TextBox id="txtPhone" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator id="Requiredfieldvalidator8" ControlToValidate="txtPhone" Text="Required Field!" runat="server" />
</td>
</tr>
<tr align="center">
<td>
<asp:Label id="Label5" runat="server">Childrens Name</asp:Label>
<asp:TextBox id="txtchildren" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
</tr>
<tr align="center">
<td>
<INPUT align="middle" type="button" onclick = "AddMember" value="Submit Form">
</td>
</tr>
</table>
</form>
</body>
</HTML>
Sanjeet
Inserting using a Stored Proc connection to SQL
