Another thought:
Do you allow NULL value in your database for LastName field?
If yes then you need to handle tat NULL in your code.

Postmaster
<snipped>

You may use: File Field (Html control) - to locate image file from your system and upload to your database. I found an example at http://www.programmingknowledge.com/ImageUpload.aspx

You may want to use Templet item

Postmaster

your SELECT as well as other statement should be like :

SelectCommand="SELECT UID, a, b, c FROM [table] WHERE [UID] = " & @UID
NOT SelectCommand="SELECT UID, a, b, c FROM [table] WHERE...

Try this link:

http://www.programmingknowledge.com/ImageUpload.aspx

Try this link:
http://www.programmingknowledge.com/simpleDataGrid.aspx

check this link if it helps:

http://www.programmingknowledge.com/simpleDataGrid.aspx

Did you set File control as 'Run as Server Control'

There is an article at http://www.programmingknowledge.com/ImageUpload.aspx

Here is an example:

Add, Edit & Delete with DataGrid ASP.NET (http://www.programmingknowledge.com/simpleDataGrid.aspx)



Good Luck

Following is a part of code to search a record and diaplay that record.

http://www.programmingknowledge.com/simpleDataGrid.aspx

=================================

Private Sub LoadPage() ...

There are two examples at :

http://www.programmingknowledge.com/dataControl.aspx

http://www.programmingknowledge.com/simpleDataGrid.aspx

There is an example on
http://www.programmingknowledge.com/ImageUpload.aspx

For an example, please visit http://www.programmingknowledge.com/DataList.aspx (http://www.programmingknowledge.com/DataList.aspx)[^ (http://www.programmingknowledge.com/DataList.aspx)]

There is an example at
http://www.programmingknowledge.com/ImageUpload.aspx

How to upload Images to SQL Server database using ASP.NET tools.
Also how to retrieve those saved images from SQL Server and display them onto DataGrid.
Visit:...

Visit : http://www.programmingknowledge.com/dataControl.aspx

add templet column with textbox in it.
set textbox multiline to true.

Open Target database in Access.
Click File Menu
Click Get External Data
Click Import...

You will be prompted for Source database.
Follow instructions

http://www.programmingknowledge.com/...