I am just learning about connecting to a database with vb. The usual handling of tables of a database requires creating TableAdapter and DataSet objects from what I am understanding. I’m not sure exactly what you mean by connect code. I have used Microsoft Access Databases (.mdb files) In Visual Studio only, and it uses a wizard to set the connection, but the generated SELECT statements look the same as SQL. Post the code that you are getting the error on if you can.

Maybe this one could be useful for you…

This function returns the first 10 characters of your string $str followed by three dots.

function TruncateText ($str, $length=10, $trailing=’…’)
{
$length-=strlen($trailing);
if (strlen($str) > $length)
{
// string exceeded length, truncate and add trailing dots
return substr($str,0,$length).$trailing;
}
else
{
// string was already short enough, return the string
$res = $str;
}
return $res;
}