|
<%@ Page CodeBehind="reg_tables.aspx.cs"
Language="c#" AutoEventWireup="false"
Inherits="HCI.reg_tables" %>
<HTML>
<HEAD>
<title>Company Name</title>
<meta http-equiv="Content-Language"
content="en-us">
<meta http-equiv="Content-Type"
content="text/html; charset=windows-1252">
</HEAD>
<body>
<form runat="server">
<TABLE id="Table1" cellSpacing="1"
cellPadding="1" width="592" border="0">
<TR>
<TD width="218"><FONT
size="2"><FONT face="Verdana">Company
Name <FONT color="#ff0000">(Req)</FONT></FONT></FONT></TD>
<TD width="219">
<asp:TextBox id="companyname"
runat="server"></asp:TextBox><FONT
face="Verdana" size="2"></FONT></TD>
<TD>
<asp:RequiredFieldValidator id="RequiredFieldValidator1"
runat="server" ErrorMessage="The
Company Name is required"
ControlToValidate="companyname"></asp:RequiredFieldValidator><FONT
face="Verdana" size="2"></FONT></TD>
</TR>
<TR>
<TD width="218"><FONT
size="2"><FONT face="Verdana">Industry<FONT
color="#ff0000">(Req)</FONT></FONT></FONT></TD>
<TD width="219">
<asp:TextBox id="industryname"
runat="server"></asp:TextBox><FONT
face="Verdana" size="2"></FONT></TD>
<TD>
<asp:RequiredFieldValidator id="RequiredFieldValidator3"
runat="server" ErrorMessage="Industry
is required"
ControlToValidate="industryname"></asp:RequiredFieldValidator><FONT
face="Verdana" size="2"></FONT></TD>
</TR>
Etc. . .
The Code Behind File
----------------------------
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace HCI
{
/// <summary>
/// Summary description for reg_tables.
/// </summary>
public class reg_tables : System.Web.UI.Page
{
protected System.Web.UI.WebControls.RequiredFieldValidator
RequiredFieldValidator1;
protected System.Web.UI.WebControls.TextBox password;
protected System.Web.UI.WebControls.TextBox password2;
protected System.Web.UI.WebControls.TextBox contactphone;
protected System.Web.UI.WebControls.TextBox contact;
protected System.Web.UI.WebControls.TextBox email2;
protected System.Web.UI.WebControls.TextBox email;
protected System.Web.UI.WebControls.TextBox city;
protected System.Web.UI.WebControls.TextBox address3;
protected System.Web.UI.WebControls.TextBox address2;
protected System.Web.UI.WebControls.TextBox address1;
protected System.Web.UI.WebControls.TextBox industryname;
protected System.Web.UI.WebControls.TextBox companyname;
protected System.Web.UI.WebControls.TextBox zipcode;
protected System.Web.UI.WebControls.RequiredFieldValidator
RequiredFieldValidator3;
protected System.Web.UI.WebControls.RequiredFieldValidator
RequiredFieldValidator4;
protected System.Web.UI.WebControls.RequiredFieldValidator
RequiredFieldValidator5;
protected System.Web.UI.WebControls.RequiredFieldValidator
RequiredFieldValidator6;
protected System.Web.UI.WebControls.RequiredFieldValidator
RequiredFieldValidator7;
protected System.Web.UI.WebControls.RequiredFieldValidator
RequiredFieldValidator8;
protected System.Web.UI.WebControls.RequiredFieldValidator
RequiredFieldValidator9;
protected System.Web.UI.WebControls.RequiredFieldValidator
RequiredFieldValidator2;
protected System.Web.UI.WebControls.CompareValidator
CompareValidator1;
protected System.Web.UI.WebControls.TextBox phone;
protected System.Web.UI.WebControls.TextBox fax;
protected System.Web.UI.WebControls.TextBox website;
protected System.Web.UI.WebControls.TextBox taxid;
protected System.Web.UI.WebControls.TextBox contractortype;
protected System.Web.UI.WebControls.Button Button1;
private void Page_Load(object sender, System.EventArgs
e)
{
// Put user code to initialize the page here
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web
Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.companyname.TextChanged += new System.EventHandler(this.TextBox13_TextChanged);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void TextBox13_TextChanged(object sender,
System.EventArgs e)
{
}
private void Button1_Click(object sender, System.EventArgs
e)
{
if(Page.IsValid)
{
try
{
string state = Request.Form["State"];
string insertid = "";
string cmdtext="insert into table(col1,col2,col3,col4,col5,col6)
values('"+companyname.Text+"','"+address1.Text+"','"+city.Text+"','"+state+"','"+email.Text+"','"+password.Text+"')
select @@Identity";
SqlConnection sqlconn = HCI.ProjHelper.GetDbConnection();
SqlCommand sqlcmd = new SqlCommand(cmdtext,sqlconn);
insertid = sqlcmd.ExecuteScalar().ToString();
sqlconn.Close();
//Response.Write("Record #"+insertid+"
Sucessfully inserted");
Response.Redirect("thankyou.aspx?id="+insertid);
}
catch(Exception ex)
{
Response.Write("error occurred;Message:"+ex.Message+";Error
Source:"+ex.Source);
}
}
}
}
}
|
