int numCols = e.Item.Cells.Count;
for (int i=2; i<numCols-1; i++) //skip first, second and last column
{
String colvalue =((System.Web.UI.WebControls.TextBox)
e.Item.Cells[i].Controls[0]).Text;
// check for invalid values
switch (cols[i-1])
{
case "@LName":
if ( !InputValidator.IsValidAnsiName(colvalue) )
{
Message.InnerHtml += "ERROR: Last Name - " + InputValidator.AnsiNameErrorString + "<br>";
}
break;
case "@FName":
if ( !InputValidator.IsValidAnsiName(colvalue) )
{
Message.InnerHtml += "ERROR: First Name - " + InputValidator.AnsiNameErrorString + "<br>";
}
break;
case "@Phone":
if ( !InputValidator.IsValidAnsiPhoneNumber(colvalue) )
{
Message.InnerHtml += "ERROR: Phone - " + InputValidator.AnsiPhoneErrorString + "<br>";
}
break;
case "@Address":
if ( !InputValidator.IsValidAnsiAddress(colvalue) )
{
Message.InnerHtml += "ERROR: Address - " + InputValidator.AnsiAddressErrorString + "<br>";
}
break;
case "@City":
if ( !InputValidator.IsValidAnsiCityOrState(colvalue) )
{
Message.InnerHtml += "ERROR: City - " + InputValidator.AnsiCityStateErrorString + "<br>";
}
break;
case "@State":
if ( !InputValidator.IsValidAnsiTwoCharacterState(colvalue) )
{
Message.InnerHtml += "ERROR: State - " + InputValidator.AnsiTwoCharacterStateErrorString + "<br>";
}
break;
case "@Zip":
if ( !InputValidator.IsValidFiveDigitZipCode(colvalue) )
{
Message.InnerHtml += "ERROR: Zip Code - " + InputValidator.AnsiBasicZipCodeErrorString + "<br>";
}
break;
}
// check for null values in required fields
if (i<6 && colvalue == "")
{
Message.InnerHtml += "ERROR: Null values not allowed for " + cols[i-1] + "<br>";
}
dim cmd as SqlCommand=new SqlCommand(strsql,cn)
dim dr as SqlDataReader
cn.open()
dr=cmd.ExecuteNonQuery()
if dr.Read() then
TextBox1.Text=dr.GetString(1)
end if