i want insert the data into the database through datagrid, how i can possible that..each time a new data must be inserted through datagrid..plzzz anyone help to get that
Maybe you could create an empty row that allows the user to "edit" it.
Then upon completing the edit, add this row of data to the database, re-create the DataSource for the DataGrid to show the row that they have added and another empty blank row that they can use to insert another entry.
I'm not sure why you would need a DataGrid to do this though.
DataGrids are typically used to display data and allow for editing or deleting.
I would recommend just having TextBoxes/DropDownLists etc. and a button that inserts a new entry into your database...then after inserting an entry, you could display all the entries in a DataGrid....
Hope this helps
-Frinny