TableAdapter don't store any rows, it just provide communication between your application and a database. try to read this article to get more info:http://msdn.microsoft.com/en-us/library/bz9tthwx(VS.80).aspx[^] The Datatable represents one table of data, so you should depend on the datatable to use the find or select methods.

Like what you do if you can't do what you like :)

CodingLover wrote:

How can I see the image through the label?

set the Backcolor for the label to: Transparent label.Backcolor = Transparent

jrgrobinson wrote:

DishVarTA.Update(CurrentStDishVarRow);

This code will attempts to save changes in the indicated DataRow to the database. You can store the row before updating and then manipulate the new instance of required row. now to locate the row in the datatable before calling the update method for the dataadapter use one of this methods: string s = "primaryKeyValue"; DataRow foundRow = datatable.Rows.Find(s); DataRow[] foundRows; foundRows = datatable.Select("put filter expression ");