Help me update data by using textbox and datagrid.

[birdcut]

Sorry for my bad Englush. I've designed a form like this

The textbox show the classID and the datagird will display the list of students of this class. Table Student in my database has classID field too, of course ! But I don't want to display column classID on datagrid. When I click Update button, I want to save all data has been change in datagrid and save the value of classID in the textbox into classID field in Student table. Can anyone help me ?
Thank for reading !

[iburyak]

Make column width = 0

Good Luck.

[birdcut]

Thank you ! But it seems your don't understand my question. I didn't get problem with displaying but with saving. My form display the ID of the class and all students of this class. The table Student in my databes has 6 columns: ID, Name, Sex, Birthday, Address and ClassID. ClassID will be displayed on the textbox and 5 remaining columns will be dislayed on the datagrid. When I click the Update button, I want to save all changes into table Student. All saved rounds have only one value in ClassID column (the value displayed on textbox). And I don't know how to save the value displayed on the textbox along with the value displayed on datagrid.
Can't anyone help me ?

[iburyak]

Can you execute statement like this?

[PHP]
Update Student Set
ID = datagrid1(0),
name = datagrid(1),
Sex = datagrid(2),
Birthday = datagrid(3),
Address = datagrid(4)
Where classID = Text1.text and ID = datagrid(0)[/PHP]

[birdcut]

Thanks again but this can only save an row. User can type many rows in datagrid.

[iburyak]

Loop through all rows in a grid and save each

Thank you