Why this error is giving - Invalid use of '.', '!', or '()'. in query expression ''IT Software'.'1 to 1965''.
my code is given below
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="cv_posting.aspx.vb" Inherits="cv" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>CV Bank of India</title>
<link href="css/menu.css" rel="stylesheet" type="text/css" />
<link href="css/menumain.css" rel="stylesheet" type="text/css" />
<link href="css/sidemenu.css" rel="stylesheet" type="text/css" />
<link href="css/tabmenu.css" rel="stylesheet" type="text/css"/>
<style type="text/css">
<!--
a{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; text-decoration:none}
a.Link{color:#000000}
a.Visited{color:#333333}
a.Active{color:#FF0000}
a.hover{color:#FFFFFF}
.style1 {
color: #000000;
font-size: 10px;
font-family: Verdana, Arial, Helvetica, sans-serif;
}
.style2 {color: #FF9900}
.style4 {
font-size: 12px;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-weight: bold;
color: #990000;
}
.style5 {color: #FFFFFF}
.style6 {
font-size: 14px;
font-weight: bold;
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #FFFFFF;
}
.style9 {font-family: Verdana, Arial, Helvetica, sans-serif; color: #000000; font-size: 12px; }
.style11 {
font-size: 10px;
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #FFFFFF;
}
.style12 {
font-size: 12px;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-weight: bold;
}
.style14 {
font-size: x-small;
color: #ff0000;
font-family: Verdana, Arial, Helvetica, sans-serif;
}
.style16 {color: #000000}
.style17 { font-family: Verdana, Arial, Helvetica, sans-serif;
color: #FFFFFF;
font-size: x-small;
}
.style18 {
font-size: x-small;
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #febf01;
}
.style20 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px;}
.style21 {
color: #FFFFFF;
font-size: 16px;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-weight: bold;
}
.style35 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 16px;
color: #000000;
font-weight: bold;
}
.style36
{
height: 15px;
}
-->
</style>
<script type="text/javascript" src="js/jquery-1.5.1.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
$(".tab_content").hide();
$("ul.tabs li:first").addClass("active").show();
$(".tab_content:first").show();
$("ul.tabs li").click(function () {
$("ul.tabs li").removeClass("active");
$(this).addClass("active");
$(".tab_content").hide();
var activeTab = $(this).find("a").attr("href");
$(activeTab).fadeIn();
return false;
});
});
function MM_jumpMenu(targ, selObj, restore) {
eval(targ + ".location='" + selObj.options[selObj.selectedIndex].value + "'");
if (restore) selObj.selectedIndex = 0;
}
</script>
</head>
<body background="images/bg.gif" bgcolor="#FFFFFF"leftmargin="0" rightmargin="0" topmargin="0" bottommargin="0" marginheight="0" marginwidth="0">
<form id="Form1" runat="server">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="50%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="417" height="26" removed="images/index_01.jpg"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%"> </td>
<td width="90%">Welcome to cvbankofindia.com</td>
<td width="5%"> </td>
</tr>
</table></td>
<td width="26"><img src="images/index_02.jpg" width="26" height="26" /></td>
<td width="309" height="26" removed="images/index_03.jpg"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3%"> </td>
<td width="92%">Call us:- +91-657-2420015/2441862</td>
<td width="5%"> </td>
</tr>
</table></td>
<td width="260" height="26" removed="images/index_04.jpg"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%"> </td>
<td width="88%"><a href="opportunity.html"><font color="#000000"> Opportunity</font> </a>|<a href="who_are.html"><font color="#000000"> Who we are? </font></a>|<a href="contact_us.html"><font color="#000000"> Contact us </font></a></td>
<td width="7%"> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td width="1000" height="1" bgcolor="#cccccc"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="29" height="130" bgcolor="#febf01"><h3><img src="images/blank.gif" width="1" height="1" /></h3></td>
<td width="749"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#febf01">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/index_07.jpg" width="319" height="49" /></td>
</tr>
<tr>
<td width="319" height="22" bgcolor="#febf01"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="21%"> </td>
<td width="71%">For Education | For Placement</td>
<td width="8%"> </td>
</tr>
</table></td>
</tr>
<tr>
<td width="319" height="26" bgcolor="#febf01"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
</table></td>
<td width="421" height="97" bgcolor="febf01"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
</table></td>
</tr>
<tr>
<td width="740" height="33" bgcolor="#febf01"><div id="glowingtabs">
<ul>
<li id="current"><a href="#" title="Post Requirement"><span>Post Requirement</span></a></li>
<li><a href="#" title="Post your CV"><span>Post your CV</span></a></li>
<li><a href="#" title="Post your Resume"><span>Post your Resume</span></a></li>
<li><a href="#" title="Post your Bio-Data"><span>Post your Bio-Data</span></a></li>
</ul>
</div></td>
</tr>
</table></td>
<td width="202"><table width="99%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="202" height="24" bgcolor="#febf01"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td><img src="images/index_11.jpg" width="202" height="73" /></td>
</tr>
<tr>
<td width="202" height="33" bgcolor="#febf01"> </td>
</tr>
</table></td>
<td width="32" height="130" bgcolor="#febf01"> </td>
</tr>
</table></td>
</tr>
<tr>
<td width="1000" height="1" bgcolor="#af8300"><img src="images/blank.gif" /></td>
</tr>
<tr>
<td width="1000" height="10" bgcolor="#ffffff"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="29" height="239" bgcolor="#ffffff"><img src="images/blank.gif" width="1" height="1" /></td>
<td width="663"><img src="images/index_19.jpg" width="663" height="239" /></td>
<td width="21" height="239"><img src="images/blank.gif" width="1" height="1" /></td>
<td width="270" height="239" bgcolor="#ff0000">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="4%"> </td>
<td width="90%">Register User Login here:-</td>
<td width="6%"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="10"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="4%"> </td>
<td width="31%" class="style9">Username</td>
<td width="65%"><label>
<input type="text" name="textfield" id="textfield" />
</label></td>
</tr>
</table></td>
</tr>
<tr>
<td height="5"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="4%"> </td>
<td width="31%" class="style9">Password</td>
<td width="65%"><label>
<input type="text" name="textfield2" id="textfield2" />
</label></td>
</tr>
</table></td>
</tr>
<tr>
<td height="5"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="37%"> </td>
<td width="12%"><label>
<input type="submit" name="button" id="button" value="Go" />
</label></td>
<td width="4%"> </td>
<td width="41%"><div align="center">Forgot Password?</div></td>
<td width="6%"> </td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="4%"><img src="images/blank.gif" width="1" height="1" /></td>
<td width="92%" height="15" bgcolor="#F0F0F0"><img src="images/blank.gif" width="1" height="1" /></td>
<td width="4%"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td> </td>
<td bgcolor="#F0F0F0"><div align="center">Don't have a CV Bank of India ID?</div></td>
<td> </td>
</tr>
<tr>
<td><img src="images/blank.gif" width="1" height="1" /></td>
<td height="12" bgcolor="#F0F0F0"><img src="images/blank.gif" width="1" height="1" /></td>
<td><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td> </td>
<td bgcolor="#F0F0F0"><div align="center">
<label>
<input type="submit" name="button2" id="button2" value="Click Here" />
</label>
</div></td>
<td> </td>
</tr>
<tr>
<td height="5"><img src="images/blank.gif" width="1" height="1" /></td>
<td height="5" bgcolor="#F0F0F0"><img src="images/blank.gif" width="1" height="1" /></td>
<td><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td height="5"> </td>
<td height="15" bgcolor="#F0F0F0"><div align="center" class="style14"><img src="images/blank.gif" width="1" height="1" />www.cvbankofindia.com</div></td>
<td> </td>
</tr>
<tr>
<td height="5"><img src="images/blank.gif" width="1" height="1" /></td>
<td height="5" bgcolor="#F0F0F0"><img src="images/blank.gif" width="1" height="1" /></td>
<td><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
</table></td>
</tr>
<tr>
<td height="8"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
</table>
</td>
<td width="29" height="239" bgcolor="#ffffff"> </td>
</tr>
</table></td>
</tr>
<tr>
<td width="1000" height="9" bgcolor="#FFFFFF"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td><div id="vdividermenu">
<ul>
<li id="current"><a href="index.html" title="Home">Home</a></li>
<li><a href="#" title="List of Institutions">List of Institutions</a></li>
<li><a href="#" title="Search Database">Search Database</a></li>
<li><a href="#" title="Services">Services</a></li>
<li><a href="#" title="Avvertise with us">Advertise with us</a></li>
<li><a href="#" title="Refer2Needy">Refer2Needy</a></li>
<li><a href="#" title="Useful-Links">Useful-Links</a></li>
<li><a href="#" title="What's New">What's New</a></li>
</ul>
</div></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="29" height="698"><img src="images/blank.gif" width="1" height="1" /></td>
<td valign="top" width="232"><table width="32%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/index_29.jpg" width="232" height="31" /></td>
</tr>
<tr>
<td><ul class="buttonmenu">
<li><a href="#">Acadmic Institute</a></li>
<li><a href="#">Professional Institute</a></li>
<li><a href="#">Technical Institute</a></li>
<li><a href="#">Vocational Training</a></li>
<li><a href="#">Tution (Private)</a></li>
<li><a href="#">Coaching Institute</a></li>
<li><a href="#">Admission</a></li>
<li><a href="#">Counsellors</a></li>
<li><a href="#">Consultants</a></li>
<li><a href="#">Educational Stores</a></li>
<li><a href="#">Edu-Material-Supplier</a></li>
<li><a href="#">Miscellenous</a></li>
<li><a href="#">Candidate Available</a></li>
<li><a href="#">Candidate Required</a></li>
<li><a href="#">Agencies</a></li>
<li><a href="#">Education Online</a></li>
<li><a href="#">Distance Learning</a></li>
</ul></td>
</tr>
<tr>
<td><img src="images/index_35.jpg" width="232" height="31" /></td>
</tr>
<tr>
<td><ul class="buttonmenu">
<li><a href="#">Consultant</a></li>
<li><a href="#">Employers</a></li>
<li><a href="#">Job Providers</a></li>
<li><a href="#">Agencies</a></li>
<li><a href="#">Campus Selection</a></li>
<li><a href="#">Walk-in-Interview</a></li>
<li><a href="#">Covering Letter</a></li>
<li><a href="#">Resignation Letter</a></li>
<li><a href="#">Resume Builder</a></li>
<li><a href="#">Negotiation Salary</a></li>
<li><a href="#">Interview Preparation</a></li>
<li><a href="#">C.V(Resume) Posting Tips</a></li>
</ul></td>
</tr>
</table></td>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="8"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="2%"> </td>
<td width="96%">Free CV Posting Service Information</td>
<td width="2%"> </td>
</tr>
</table></td>
</tr>
<tr>
<td><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="2%"> </td>
<td width="96%"><div class="container">
<ul class="tabs">
<li><a href="#tab1">Personal</a></li>
<li><a href="#tab2">Educational</a></li>
<li><a href="#tab3">Skill and Experience</a></li>
<li><a href="#tab4">Others</a></li>
</ul>
<div class="tab_container">
<div id="tab1" class="tab_content">
<h2>Personal Information</h2>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="33%">E-mail</td>
<td width="50%">
<asp:TextBox ID="TextBox1" runat="server">
<label>
</label</td>
</label>
<asp:Label ID="Label1" runat="server" Text="Label">
<td width="17%"> </td>
</tr>
<tr>
<td> </td>
<td><asp:RegularExpressionValidator ID="rev1" runat="server" Text="This is Not an Email ID" ControlToValidate="TextBox1" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"/></td>
<td> </td>
</tr>
<tr>
<td>Password</td>
<td><label>
<asp:TextBox ID="TextBox2" runat="server" TextMode="Password">
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Confirm Password</td>
<td><label>
<asp:TextBox ID="TextBox3" runat="server" TextMode="Password">
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>First Name</td>
<td><label>
<asp:TextBox ID="TextBox4" runat="server">
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Last Name</td>
<td><label>
<asp:TextBox ID="TextBox5" runat="server">
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Mobile No.</td>
<td><label>
<asp:TextBox ID="TextBox6" runat="server">
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Current Address</td>
<td><label>
<textarea name="textfield9" id="textfield9" runat="server"></textarea>
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="3"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="33%">Location</td>
<td width="14%">
<label>
<asp:TextBox ID="TextBox7" runat="server">
</label></td>
<td width="8%"> </td>
<td width="23%">Nationality</td>
<td width="22%"><label>
<asp:DropDownList ID="DropDownList2" runat="server">
<asp:ListItem>Indiia
</label></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="3"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="33%">Date of Birth</td>
<td width="15%"><label>
<asp:DropDownList ID="DropDownList3" runat="server">
<asp:ListItem>1
<asp:ListItem>2
<asp:ListItem>3
<asp:ListItem>4
<asp:ListItem>5
<asp:ListItem>6
<asp:ListItem>7
<asp:ListItem>8
<asp:ListItem>9
<asp:ListItem>10
<asp:ListItem>11
<asp:ListItem>12
<asp:ListItem>13
<asp:ListItem>14
<asp:ListItem>15
<asp:ListItem>16
<asp:ListItem>17
<asp:ListItem>18
<asp:ListItem>19
<asp:ListItem>20
<asp:ListItem>21
<asp:ListItem>22
<asp:ListItem>23
<asp:ListItem>24
<asp:ListItem>25
<asp:ListItem>26
<asp:ListItem>27
<asp:ListItem>28
<asp:ListItem>29
<asp:ListItem>30
<asp:ListItem>31
</label></td>
<td width="13%"><label>
<asp:DropDownList ID="DropDownList4" runat="server">
<asp:ListItem>1
<asp:ListItem>2
<asp:ListItem>3
<asp:ListItem>4
<asp:ListItem>5
<asp:ListItem>6
<asp:ListItem>7
<asp:ListItem>8
<asp:ListItem>9
<asp:ListItem>10
<asp:ListItem>11
<asp:ListItem>12
</label></td>
<td width="3%"> </td>
<td width="36%"><label>
<asp:DropDownList ID="DropDownList5" runat="server">
<asp:ListItem>1965
<asp:ListItem>1966
<asp:ListItem>1967
<asp:ListItem>1967
<asp:ListItem>1968
<asp:ListItem>1969
<asp:ListItem>1970
<asp:ListItem>1971
<asp:ListItem>1972
<asp:ListItem>1973
<asp:ListItem>1974
<asp:ListItem>1975
<asp:ListItem>1976
<asp:ListItem>1977
<asp:ListItem>1978
<asp:ListItem>1979
<asp:ListItem>1980
<asp:ListItem>1981
<asp:ListItem>1982
<asp:ListItem>1983
<asp:ListItem>1984
<asp:ListItem>1985
<asp:ListItem>1986
<asp:ListItem>1987
<asp:ListItem>1988
<asp:ListItem>1989
<asp:ListItem>1990
<asp:ListItem>1990
<asp:ListItem>2000
<asp:ListItem>2001
<asp:ListItem>2002
<asp:ListItem>2003
<asp:ListItem>2004
<asp:ListItem>2005
<asp:ListItem>2006
<asp:ListItem>2007
<asp:ListItem>2008
<asp:ListItem>2009
<asp:ListItem>2010
<asp:ListItem>2011
<asp:ListItem>2012
<asp:ListItem>2013
<asp:ListItem>2014
<asp:ListItem>2015
</label></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="3"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="33%">Gender</td>
<td width="18%"><label>
<asp:DropDownList ID="DropDownList6" runat="server">
<asp:ListItem>Male
<asp:ListItem>Female
</label></td>
<td width="7%"> </td>
<td width="20%">Marital Status</td>
<td width="22%"><label>
<asp:DropDownList ID="DropDownList7" runat="server">
<asp:ListItem>Married
<asp:ListItem>Unmarried
</label></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>Eg. Java, C++, Programmer, Engineer</td>
<td> </td>
</tr>
<tr>
<td>Key Skill</td>
<td><label>
<textarea name="textfield10" id="textfield10" runat="server"></textarea>
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Industry</td>
<td><label>
<asp:DropDownList ID="DropDownList8" runat="server">
<asp:ListItem>Accounting & Finance
<asp:ListItem>Advertising/PR/MR/Events
<asp:ListItem>Agriculture
<asp:ListItem>Animation
<asp:ListItem>Architecture/Interior Designing
<asp:ListItem>Aviation/Aerospace Firm
<asp:ListItem>Banking/Financial/Services/Broking
<asp:ListItem>BPO
<asp:ListItem>Chemical/Petro Chamical/Plastic/Rubber
<asp:ListItem>Construction/Engineering/Cement/Metals
<asp:ListItem>Courier/Transportation/Freight
<asp:ListItem>Defence/Governmence
<asp:ListItem>Education/Teaching/Training
<asp:ListItem>Electricals/Switch Gear
<asp:ListItem>Export/Import
<asp:ListItem>Facility Managment
<asp:ListItem>Fertilizers/Pasticides
<asp:ListItem>Food Processing
<asp:ListItem>Gems & Jewellery
<asp:ListItem>Glass
<asp:ListItem>Hotel/Resturent/Airlines/Travel
<asp:ListItem>Industrial Product/Heavy Machinery
<asp:ListItem>Insurance
<asp:ListItem>IT - Hardware Networking
<asp:ListItem>IT - Software/IT Web Designing/IT Web Application
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="3"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="33%">Experience </td>
<td width="10%"><label>Year</label></td>
<td width="18%"><label>
<asp:DropDownList ID="DropDownList9" runat="server" EnableTheming="True">
<asp:ListItem>1
<asp:ListItem>2
<asp:ListItem>3
<asp:ListItem>4
<asp:ListItem>5
<asp:ListItem>6
<asp:ListItem>7
<asp:ListItem>9
<asp:ListItem>10
<asp:ListItem>11
<asp:ListItem>12
<asp:ListItem>13
<asp:ListItem>14
<asp:ListItem>15
<asp:ListItem>16
<asp:ListItem>17
<asp:ListItem>18
<asp:ListItem>19
<asp:ListItem>20
<asp:ListItem>21
<asp:ListItem>22
<asp:ListItem>23
<asp:ListItem>24
<asp:ListItem>25
<asp:ListItem>26
<asp:ListItem>27
<asp:ListItem>28
<asp:ListItem>29
<asp:ListItem>30>
<asp:ListItem>31
<asp:ListItem>32
<asp:ListItem>33
<asp:ListItem>34
<asp:ListItem>35
<asp:ListItem>36
<asp:ListItem>37
<asp:ListItem>38
<asp:ListItem>39
<asp:ListItem>40
<asp:ListItem>41
<asp:ListItem>42
<asp:ListItem>43
<asp:ListItem>44
<asp:ListItem>45
</label></td>
<td width="12%">Month</td>
<td width="27%"><label>
<asp:DropDownList ID="DropDownList10" runat="server">
<asp:ListItem>0
<asp:ListItem>1
<asp:ListItem>2
<asp:ListItem>3
<asp:ListItem>4
<asp:ListItem>5
<asp:ListItem>6
<asp:ListItem>7
<asp:ListItem>8
<asp:ListItem>9
<asp:ListItem>10
<asp:ListItem>11
<asp:ListItem>12
</label></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</div>
<div id="tab2" class="tab_content">
<h2>Educational Information</h2>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>Qualification</td>
<td>
<label>
<asp:TextBox ID="TextBox8" runat="server">
</label>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>City & Town</td>
<td>
<label>
<asp:TextBox ID="TextBox9" runat="server">
</label></td>
<td> </td>
</tr>
<tr>
<td class="style36"></td>
<td class="style36"></td>
<td class="style36"></td>
</tr>
<tr>
<td>Year of Passing</td>
<td><label>
<asp:DropDownList ID="DropDownList11" runat="server">
<asp:ListItem>1965
<asp:ListItem>1966
<asp:ListItem>1967
<asp:ListItem>1967
<asp:ListItem>1968
<asp:ListItem>1969
<asp:ListItem>1970
<asp:ListItem>1971
<asp:ListItem>1972
<asp:ListItem>1973
<asp:ListItem>1974
<asp:ListItem>1975
<asp:ListItem>1976
<asp:ListItem>1977
<asp:ListItem>1978
<asp:ListItem>1979
<asp:ListItem>1980
<asp:ListItem>1981
<asp:ListItem>1982
<asp:ListItem>1983
<asp:ListItem>1984
<asp:ListItem>1985
<asp:ListItem>1986
<asp:ListItem>1987
<asp:ListItem>1988
<asp:ListItem>1989
<asp:ListItem>1990
<asp:ListItem>1990
<asp:ListItem>2000
<asp:ListItem>2001
<asp:ListItem>2002
<asp:ListItem>2003
<asp:ListItem>2004
<asp:ListItem>2005
<asp:ListItem>2006
<asp:ListItem>2007
<asp:ListItem>2008
<asp:ListItem>2009
<asp:ListItem>2010
<asp:ListItem>2011
<asp:ListItem>2012
<asp:ListItem>2013
<asp:ListItem>2014
<asp:ListItem>2015
<asp:ListItem>
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Type</td>
<td><label>
<asp:DropDownList ID="DropDownList12" runat="server">
<asp:ListItem>IT in Software BCA /MCA/B Tech/M Tech
<asp:ListItem>IT in Hardware Bsc IT/Msc IT/other
<asp:ListItem>Managment MBA
<asp:ListItem>Bachelors in Arts BA
<asp:ListItem>Bachelors in Science Bsc
<asp:ListItem>Bachelors in Commerse B Com
<asp:ListItem>Master in Arts MA
<asp:ListItem>Master in Science Msc
<asp:ListItem>Master in Commerse M Com
<asp:ListItem>PHD
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="3"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="33%">Duration</td>
<td width="10%">Year</td>
<td width="15%"><label>
<asp:DropDownList ID="DropDownList13" runat="server">
<asp:ListItem>1965
<asp:ListItem>1966
<asp:ListItem>1967
<asp:ListItem>1967
<asp:ListItem>1968
<asp:ListItem>1969
<asp:ListItem>1970
<asp:ListItem>1971
<asp:ListItem>1972
<asp:ListItem>1973
<asp:ListItem>1974
<asp:ListItem>1975
<asp:ListItem>1976
<asp:ListItem>1977
<asp:ListItem>1978
<asp:ListItem>1979
<asp:ListItem>1980
<asp:ListItem>1981
<asp:ListItem>1982
<asp:ListItem>1983
<asp:ListItem>1984
<asp:ListItem>1985
<asp:ListItem>1986
<asp:ListItem>1987
<asp:ListItem>1988
<asp:ListItem>1989
<asp:ListItem>1990
<asp:ListItem>1990
<asp:ListItem>2000
<asp:ListItem>2001
<asp:ListItem>2002
<asp:ListItem>2003
<asp:ListItem>2004
<asp:ListItem>2005
<asp:ListItem>2006
<asp:ListItem>2007
<asp:ListItem>2008
<asp:ListItem>2009
<asp:ListItem>2010
<asp:ListItem>2011
<asp:ListItem>2012
<asp:ListItem>2013
<asp:ListItem>2014
<asp:ListItem>2015
</label></td>
<td width="11%"> Year </td>
<td width="31%"><label>
<asp:DropDownList ID="DropDownList14" runat="server">
<asp:ListItem>1965
<asp:ListItem>1966
<asp:ListItem>1967
<asp:ListItem>1967
<asp:ListItem>1968
<asp:ListItem>1969
<asp:ListItem>1970
<asp:ListItem>1971
<asp:ListItem>1972
<asp:ListItem>1973
<asp:ListItem>1974
<asp:ListItem>1975
<asp:ListItem>1976
<asp:ListItem>1977
<asp:ListItem>1978
<asp:ListItem>1979
<asp:ListItem>1980
<asp:ListItem>1981
<asp:ListItem>1982
<asp:ListItem>1983
<asp:ListItem>1984
<asp:ListItem>1985
<asp:ListItem>1986
<asp:ListItem>1987
<asp:ListItem>1988
<asp:ListItem>1989
<asp:ListItem>1990
<asp:ListItem>1990
<asp:ListItem>2000
<asp:ListItem>2001
<asp:ListItem>2002
<asp:ListItem>2003
<asp:ListItem>2004
<asp:ListItem>2005
<asp:ListItem>2006
<asp:ListItem>2007
<asp:ListItem>2008
<asp:ListItem>2009
<asp:ListItem>2010
<asp:ListItem>2011
<asp:ListItem>2012
<asp:ListItem>2013
<asp:ListItem>2014
<asp:ListItem>2015
</label></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Note</td>
<td><label>
<textarea name="textfield13" id="textfield13" runat="server"></textarea>
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</div>
<div id="tab3" class="tab_content">
<h2>Skill and Experience</h2>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="25%"> </td>
<td width="74%">Eg. Java, C++, Programmer. This will be search by Employe</td>
<td width="1%"> </td>
</tr>
<tr>
<td>Key Skill</td>
<td><label>
<textarea name="textfield14" id="textfield14" runat="server"></textarea>
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Industry</td>
<td><label>
<asp:DropDownList ID="DropDownList15" runat="server">
<asp:ListItem>Accounting/Finance
<asp:ListItem>Advertising/PR/MR/Events"
<asp:ListItem>Agriculture
<asp:ListItem>Animation
<asp:ListItem>Architecture/Interior Designing
<asp:ListItem>Aviation/Aero Space
<asp:ListItem>Banking/Financial/Services/Broking
<asp:ListItem>BPO
<asp:ListItem>Chemicals/Petro Chemicals/Plastic/Rubber
<asp:ListItem>Construction/Engineering/Cement/Metals
<asp:ListItem>Courier/Transportation/Freight
<asp:ListItem>Defence/Government
<asp:ListItem>Education/Teaching/Training
<asp:ListItem>Electrical/Switch Gears
<asp:ListItem>Export/Import
<asp:ListItem>Facility Managment
<asp:ListItem>Fartilizer Pasticides
<asp:ListItem>Food Processing
<asp:ListItem>Gems & Jewellery
<asp:ListItem>Glass
<asp:ListItem>Hotel/Resturent/Airlines/Travels
<asp:ListItem>Industrial Products/Heavy Machinery
<asp:ListItem>Insurence
<asp:ListItem>IT Hardware / Networking
<asp:ListItem>IT Software/IT Web Designing/IT Web Development
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="2"><h2>Work Experience</h2></td>
<td> </td>
</tr>
<tr>
<td>Job role</td>
<td>
<label>
<asp:TextBox ID="TextBox10" runat="server">
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Company</td>
<td>
<label>
<asp:TextBox ID="TextBox11" runat="server">
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Location</td>
<td>
<label>
<asp:TextBox ID="TextBox12" runat="server">
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Join Date</td>
<td>
<label>
<asp:TextBox ID="TextBox13" runat="server">
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="3"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="25%">Duration</td>
<td width="9%">Year</td>
<td width="16%"><label>
<asp:DropDownList ID="DropDownList16" runat="server">
<asp:ListItem>1965
<asp:ListItem>1966
<asp:ListItem>1967
<asp:ListItem>1967
<asp:ListItem>1968
<asp:ListItem>1969
<asp:ListItem>1970
<asp:ListItem>1971
<asp:ListItem>1972
<asp:ListItem>1973
<asp:ListItem>1974
<asp:ListItem>1975
<asp:ListItem>1976
<asp:ListItem>1977
<asp:ListItem>1978
<asp:ListItem>1979
<asp:ListItem>1980
<asp:ListItem>1981
<asp:ListItem>1982
<asp:ListItem>1983
<asp:ListItem>1984
<asp:ListItem>1985
<asp:ListItem>1986
<asp:ListItem>1987
<asp:ListItem>1988
<asp:ListItem>1989
<asp:ListItem>1990
<asp:ListItem>1990
<asp:ListItem>2000
<asp:ListItem>2001
<asp:ListItem>2002
<asp:ListItem>2003
<asp:ListItem>2004
<asp:ListItem>2005
<asp:ListItem>2006
<asp:ListItem>2007
<asp:ListItem>2008
<asp:ListItem>2009
<asp:ListItem>2010
<asp:ListItem>2011
<asp:ListItem>2012
</label></td>
<td width="10%"> Year </td>
<td width="40%"><label>
<asp:DropDownList ID="DropDownList17" runat="server">
<asp:ListItem>1965
<asp:ListItem>1966
<asp:ListItem>1967
<asp:ListItem>1967
<asp:ListItem>1968
<asp:ListItem>1969
<asp:ListItem>1970
<asp:ListItem>1971
<asp:ListItem>1972
<asp:ListItem>1973
<asp:ListItem>1974
<asp:ListItem>1975
<asp:ListItem>1976
<asp:ListItem>1977
<asp:ListItem>1978
<asp:ListItem>1979
<asp:ListItem>1980
<asp:ListItem>1981
<asp:ListItem>1982
<asp:ListItem>1983
<asp:ListItem>1984
<asp:ListItem>1985
<asp:ListItem>1986
<asp:ListItem>1987
<asp:ListItem>1988
<asp:ListItem>1989
<asp:ListItem>1990
<asp:ListItem>1990
<asp:ListItem>2000
<asp:ListItem>2001
<asp:ListItem>2002
<asp:ListItem>2003
<asp:ListItem>2004
<asp:ListItem>2005
<asp:ListItem>2006
<asp:ListItem>2007
<asp:ListItem>2008
<asp:ListItem>2009
<asp:ListItem>2010
<asp:ListItem>2011
<asp:ListItem>2012
<asp:ListItem>2013
<asp:ListItem>2014
<asp:ListItem>2015
</label></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Note</td>
<td><label>
<textarea name="textfield19" id="textfield19" runat="server"></textarea>
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</div>
<div id="tab4" class="tab_content">
<h2>Others</h2>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="38%"><h3>Carrier Objectives</h3></td>
</tr>
<tr>
<td height="5"> </td>
</tr>
<tr>
<td><label>
<textarea name="textfield20" cols="40" id="textfield20" runat="server"></textarea>
</label></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><h3>Interests</h3></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><textarea name="textfield21" cols="40" id="textfield21" runat="server"></textarea></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><h3>Any Memberships</h3></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><textarea name="textfield22" cols="40" id="textfield22" runat="server"></textarea></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><h3>References</h3></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><textarea name="textfield23" cols="40" id="textfield23" runat="server"></textarea></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="7%"> </td>
<td width="38%"> </td>
<td width="55%">
<asp:Button ID="Button3" runat="server" Text="Submit CV/Resume" />
<label>
</label></td>
</tr>
</table></td>
</tr>
</table>
</div>
</div>
</div></td>
<td width="2%"> </td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
<td width="192" height="698" bgcolor="#ff0000"><div align="center" class="style21"><img src="images/blank.gif" width="1" height="1" />Space for ADV</div></td>
<td width="29" height="698"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
</table></td>
</tr>
<tr>
<td width="1000" height="9" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#febf01">
<tr>
<td width="34" height="139" bgcolor="#febf01"><img src="images/blank.gif" width="1" height="1" /></td>
<td width="227"><table width="99%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="227" height="20" bgcolor="#febf01"> </td>
</tr>
<tr>
<td><img src="images/index_47.jpg" width="227" height="24" /></td>
</tr>
<tr>
<td width="227" height="95" bgcolor="#febf01"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="14%"> </td>
<td width="74%"><a href="#" class="style16">CV Login</a></td>
<td width="12%"> </td>
</tr>
<tr>
<td height="4" colspan="3"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td> </td>
<td><a href="#" class="style16">Resume Login</a></td>
<td> </td>
</tr>
<tr>
<td colspan="3" height="4"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td> </td>
<td><a href="#" class="style16">Bio-Data Login</a></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></td>
</tr>
</table></td>
<td width="10"><img src="images/index_41.jpg" width="9" height="139" /></td>
<td width="228"><table width="99%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="225" height="20" bgcolor="#febf01"> </td>
</tr>
<tr>
<td><img src="images/index_48.jpg" width="225" height="24" /></td>
</tr>
<tr>
<td width="225" height="95" bgcolor="#febf01"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="18%"> </td>
<td width="70%"><a href="#" class="style16">CV Login</a></td>
<td width="12%"> </td>
</tr>
<tr>
<td height="4" colspan="3"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td> </td>
<td><a href="#" class="style16">Resume Login</a></td>
<td> </td>
</tr>
<tr>
<td colspan="3" height="4"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td> </td>
<td><a href="#" class="style16">Bio-Data Login</a></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></td>
</tr>
</table></td>
<td width="10"><img src="images/index_43.jpg" width="10" height="139" /></td>
<td width="227"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="225" height="20" bgcolor="#febf01"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td width="225" height="119" bgcolor="#febf01"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="14%"> </td>
<td width="74%"><a href="#" class="style16">Home</a></td>
<td width="12%"> </td>
</tr>
<tr>
<td height="2" colspan="3"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td> </td>
<td><a href="#" class="style16">Institutions Listiners Login</a></td>
<td> </td>
</tr>
<tr>
<td colspan="3" height="2"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td> </td>
<td><a href="#" class="style16">FAQ's</a></td>
<td> </td>
</tr>
<tr>
<td colspan="3" height="2"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td> </td>
<td><a href="#" class="style16">Notification</a></td>
<td> </td>
</tr>
<tr>
<td colspan="3" height="2"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td> </td>
<td><a href="#" class="style16">Coming Soon</a></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></td>
</tr>
</table></td>
<td width="10"><img src="images/index_45.jpg" width="10" height="139" /></td>
<td width="266"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="260" height="20" bgcolor="#febf01"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="14%"> </td>
<td width="74%"><a href="#" class="style16">Terms & Conditions</a></td>
<td width="12%"> </td>
</tr>
<tr>
<td height="5" colspan="3"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td> </td>
<td><a href="#" class="style16">Privacy Policy</a></td>
<td> </td>
</tr>
<tr>
<td colspan="3" height="5"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td> </td>
<td><a href="#" class="style16">Site Map</a></td>
<td> </td>
</tr>
<tr>
<td colspan="3" height="5"><img src="images/blank.gif" width="1" height="1" /></td>
</tr>
<tr>
<td> </td>
<td><a href="#" class="style16">Contact us</a></td>
<td> </td>
</tr>
</table></td>
</tr>
<tr>
<td><img src="images/index_53.jpg" width="260" height="31" border="0" usemap="#Map" /></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="#febf01"> </td>
</tr>
<tr>
<td bgcolor="#febf01"> </td>
</tr>
<tr>
<td height="25" bgcolor="#000000"><div align="center">Copyright © 2011, CV BANK OF INDIA, all rights reserved. Design and Hosted by <a rel="htmltooltip">AMSCO INDIA</a></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</form>
<map name="Map" id="Map">
<area shape="circle" coords="155,15,14" href="#" />
<area shape="circle" coords="188,15,14" href="#" />
<area shape="circle" coords="123,14,13" href="#" />
</map></body>
</html>
vb part is
Imports System.Data.OleDb
Imports System.Data
Imports System.Data.OleDb.OleDbException
Imports System.Data.OleDb.OleDbDataReader
Partial Class cv
Inherits System.Web.UI.Page
Dim cn As OleDb.OleDbConnection
Dim da As OleDb.OleDbDataAdapter
Dim ds As New DataSet
Dim cmd As OleDb.OleDbCommand
Dim dr As OleDbDataReader
Dim sql As String
Dim a, b1, c, d, d1, f, g, h, i, j, k, t1, t2, t3, t4, t5, t6, t7, t8, t9, z, z1, z2, z3, z4 As String
Protected Sub form_load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\CV Website\cvbank.mdb;")
cn.Open()
sql = "select * from cv"
da = New OleDb.OleDbDataAdapter(sql, cn)
da.Fill(ds, " cv")
Label1.Text = "connection establised"
cn.Close()
End Sub
Protected Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click
a = DropDownList3.SelectedItem.Value.Trim()
b1 = DropDownList4.SelectedItem.Value.Trim()
c = DropDownList5.SelectedItem.Value.Trim()
d = DropDownList7.SelectedItem.Value.Trim()
d1 = DropDownList9.SelectedItem.Value.Trim()
f = DropDownList10.SelectedItem.Value.Trim()
g = DropDownList11.SelectedItem.Value.Trim()
h = DropDownList14.SelectedItem.Value.Trim()
i = DropDownList15.SelectedItem.Value.Trim()
j = TextBox4.Text.Trim()
k = TextBox5.Text.Trim()
t1 = textfield9.Value
t2 = textfield10.Value
t3 = textfield13.Value
t4 = textfield14.Value
t5 = textfield19.Value
t6 = textfield20.Value
t7 = textfield21.Value
t8 = textfield22.Value
t9 = textfield23.Value
z = a + " /" + " " + b1 + " /" + " " + c
z1 = d + " Year &" + d1 + " Months"
z2 = f + " to " + g
z3 = h + " to " + i
z4 = j + " " + " " + k
TextBox1.Text = z
Dim ph As String
Dim str As String
Dim s As String
Dim b As Boolean
s = TextBox1.Text.Trim()
ph = Len(TextBox1.Text)
Try
cn.Open()
cmd = New OleDbCommand("Select email from cv where email='" & s & "'", cn)
dr = cmd.ExecuteReader
dr.Read()
b = dr.HasRows()
If b Then
Label1.Text = "User already exist"
ElseIf TextBox2.Text <> TextBox3.Text Then
Label1.Text = "Password did not match"
TextBox1.Focus()
ElseIf (TextBox1.Text.Length() = 0 And TextBox2.Text.Length() = 0 And TextBox3.Text.Length() = 0 And TextBox4.Text.Length() = 0 And TextBox5.Text.Length() = 0 And TextBox6.Text.Length() = 10 And TextBox7.Text.Length() = 0 And TextBox8.Text.Length() = 0 And TextBox9.Text.Length() = 0 And TextBox10.Text.Length() = 0 And TextBox11.Text.Length() = 0 And TextBox12.Text.Length() = 0 And TextBox13.Text.Length() = 0 And textfield9.Value.Length() = 0 And textfield10.Value.Length() = 0 And textfield13.Value.Length() = 0 And textfield14.Value.Length() = 0 And textfield19.Value.Length() = 0 And textfield20.Value.Length() = 0 And textfield21.Value.Length() = 0 And textfield22.Value.Length() = 0 And textfield23.Value.Length() = 0) Then
Label1.Text = "Please ENTER valid ENTRY for all mendetory field"
TextBox1.Focus()
Else
Try
str = "Insert into ctable values('" & TextBox1.Text.Trim() & "','" & TextBox2.Text.Trim() & "','" & z4 & "','" & TextBox6.Text.Trim() & "','" & t1 & "','" & TextBox7.Text.Trim() & "','" & DropDownList2.SelectedItem.ToString() & "','" & z & "','" & DropDownList6.SelectedItem.ToString() & "','" & DropDownList7.SelectedItem.ToString() & "','" & t2 & "','" & DropDownList8.SelectedItem.ToString() & "','" & z1 & "','" & TextBox8.Text.Trim() & "','" & TextBox9.Text.Trim() & "','" & DropDownList11.SelectedItem.ToString() & "','" & DropDownList12.SelectedItem.ToString() & "'.'" & z2 & "','" & t3 & "','" & t4 & "','" & DropDownList14.SelectedItem.ToString() & "','" & TextBox10.Text.Trim() & "','" & TextBox11.Text.Trim() & "','" & TextBox12.Text.Trim() & "','" & TextBox13.Text.Trim() & "','" & z3 & "','" & t5 & "','" & t6 & "','" & t7 & "','" & t8 & "','" & t9 & "')"
cmd = New OleDbCommand(str, cn)
cmd.ExecuteNonQuery()
Label1.Text = "Record Added"
Catch ex As Exception
Response.Write(ex.Message)
End Try
End If
Catch ex As Exception
Response.Write(ex.Message)
End Try
cn.Close()
End Sub
Public Sub New()
End Sub
End Class