Dear All,
This is the Code of my business object used to insert AddressBook Details into db
-------------InsertData.VB-------------------------------------------------
Option Explicit
Option Strict
Imports system
Imports system.Data
Imports system.Data.SqlClient
NameSpace InsertData
Public Class Insert
Public Sub Addrec(val1 as String,val2 as String)
Dim strc as string
strc = "server=sedcosrv2;database=Master;uid=sa;pwd="
Dim strsql as String = "INSERT INTO address_book (Name,Email) VALUES ('" & val1 & "','" & val2 & "')"
Dim MyConn as New sqlConnection(strc)
Dim cmd as New SqlCommand (strsql, MyConn)
MyConn.Open()
cmd.ExecuteNonQuery()
MyConn.Close()
End Sub
End Class
End Namespace
-------------------------------------------------------------------
This was sucessfully compiled and dll was stored in Bin Folder. and assembly reference was added in web.config
----------------------------Addressbook.ascx-------------------
<%@ Control Language="VB" %>
<%@ import Namespace="InsertData" %>
<script runat="server">
public sub button1_Click(Sender as Object, e as Eventargs)
Dim Name,email,comments
Name = Textbox1.Text
Email = Textbox2.Text
Comments = Textbox3.Text
Dim inst as new Insert()
inst.Addrec(Name,Email)
Response.write ("Record Added")
End Sub
public sub button2_Click(Sender as Object, e as Eventargs)
Textbox1.Text = ""
Textbox2.Text = ""
Textbox3.Text = ""
End Sub
</script>
<table id="AutoNumber1" style="BORDER-COLLAPSE: collapse" bordercolor="#0066cc" height="407" cellspacing="0" cellpadding="0" width="800" border="1">
<tbody>
<tr>
<td bgcolor="#0066cc">
</td>
<td bgcolor="#0066cc">
</td>
</tr>
<tr>
<td bordercolor="#0066cc" width="100" bgcolor="#0066cc" rowspan="4">
</td>
<td height="20" rowspan="5">
<p align="center">
<font face="Arial" size="2">
<img alt="Genesis Media Group" src="Images\bann.gif" align="center" /></font>
</p>
</td>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr>
<td bgcolor="#0066cc">
</td>
</tr>
<tr>
<td bgcolor="#0066cc">
</td>
<td style="FONT-WEIGHT: bold; FONT-SIZE: larger; COLOR: white; FONT-STYLE: normal; FONT-FAMILY: Arial; FONT-VARIANT: small-caps; TEXT-DECORATION: underline" bgcolor="#0066cc">
Sign In Address Book</td>
</tr>
<tr>
<td bgcolor="#0066cc">
</td>
<td>
</td>
</tr>
<tr>
<td bgcolor="#0066cc">
</td>
<td>
</td>
</tr>
<tr>
<td bgcolor="#0066cc">
</td>
<td style="FONT-WEIGHT: bold; FONT-SIZE: larger; COLOR: white; FONT-STYLE: normal; FONT-FAMILY: Arial; FONT-VARIANT: small-caps; TEXT-DECORATION: underline" bgcolor="white">
</td>
</tr>
<tr>
<td bgcolor="#0066cc">
</td>
<td style="FONT-SIZE: x-small; COLOR: black; FONT-FAMILY: Arial" border="0">
Name <asp:TextBox id="TextBox1" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td bgcolor="#0066cc">
</td>
<td>
</td>
</tr>
<tr>
<td bgcolor="#0066cc">
</td>
<td style="FONT-SIZE: x-small; COLOR: black; FONT-FAMILY: Arial">
Email <asp:TextBox id="TextBox2" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td bgcolor="#0066cc">
</td>
<td>
</td>
</tr>
<tr>
<td bgcolor="#0066cc">
</td>
<td style="FONT-SIZE: x-small; COLOR: black; FONT-FAMILY: Arial">
Comments</td>
</tr>
<tr>
<td bgcolor="#0066cc">
</td>
<td>
<asp:TextBox id="TextBox3" runat="server" TextMode="MultiLine" Width="235px" Height="109px"></asp:TextBox>
</td>
</tr>
<tr>
<td bgcolor="#0066cc">
</td>
<td>
</td>
</tr>
<tr>
<td bgcolor="#0066cc">
</td>
<td>
<asp:Button id="Button1" runat="server" Text="Submit" Font-Names="Arial" Font-Size="X-Small" ForeColor="White" BackColor="#0066CC" BorderColor="#0066CC"></asp:Button>
<asp:Button id="Button2" runat="server" Text="Clear" Font-Names="Arial" Font-Size="X-Small" ForeColor="White" BackColor="#0066CC" BorderColor="#0066CC"></asp:Button>
</td>
</tr>
<tr>
<td width="30" bgcolor="#0066cc" height="420">
</td>
<td width="500" bgcolor="white">
<p>
</p>
<blockquote dir="ltr" style="MARGIN-RIGHT: 0px">
<p style="FONT-SIZE: x-small; COLOR: black; FONT-FAMILY: Arial" align="justify">
</p>
</blockquote>
<p>
</p>
</td>
</tr>
</tbody>
</table>
---------------------------------------------------------------------------------------
addressbook.aspx -- using this user will sign in his details and record will be updated in database.
-----------------------------/// addressbook.aspx ///---------------------------------
<%@Register TagPrefix="project" TagName="Header" src="Header.ascx" %>
<%@Register TagPrefix="project" TagName="Body" src="addressbook.ascx" %>
<%@Register TagPrefix="project" TagName="Footer" src="footer.ascx" %>
<%@ Page language="VB" %>
<script runat="server">
' Insert page code here
'
</script>
<html>
<head>
</head>
<body topmargin="1" leftmargin="1">
<Project:Header runat="server" />
<Project:Body runat="server" />
<Project:Footer runat="server" />
<form runat="server">
<!-- Insert content here -->
</form>
</body>
</html>
-------------------------------------------------------------------------
When iam accessing addressbook.aspx this is the error thrown
Server Error in '/dot' Application.
--------------------------------------------------------------------------------
Control '_ctl1_TextBox1' of type 'TextBox' must be placed inside a form tag with runat=server.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: Control '_ctl1_TextBox1' of type 'TextBox' must be placed inside a form tag with runat=server.
What might be the Problem?
Any Help will be highly appreciated.
Thanks
Syed Moiz..