assign values to textbox before insertion

[classic]

I am new to Asp.net and a lot of solutions are there but can not understand. please elaborately reply following question in some easy manners.

I am using Form View to Insert Data using ObjectDataSource Visual Studio2010.

It is running fine, taking values inserting and then showing in grid view using SqlDataSource.. also editing in detailsview using SqlDataSource.

1. My Column EmployeeID is of String nature.now i dont want the user to input Employeeid, i want E-123 type value. and i want to get the max id from table and +1 before inserting new record. what are the step to do it.

2. I want to display status column as check box in detailsview. it is again string type and taking values T or F. how to do it?

3. Status Checkbox need to be displayed in Grid View also.

help required to do it....some easiest way to achieve this.

Regards

[sapator]

Yo.
http://msdn.microsoft.com/en-us/library/bb288032.aspx
Also don't use sqldatasource if possible, unless you have very limited data requirements.
Either use straight ADO or objectDatasource.