how to insert value from dropdownlist to database

Hi, You need to write the one command for Inserting data, one for Updating and one for deleting (if you are deleting data). UPDATE Table SET ....... values and then assigning them to the appropriate DataAdapter Property like follows myAdapter.InsertCommand=comInsert myAdapter.UpdateCommand=comUpdate myAdapter.DeleteCommand=comDelete The Update method of DataAdapter class is responsible for updation. The UpdateCommand property is used if we are updating an existing row, and the DeleteCommand is used if you are deleting an existing row. Regards bhar Knowledge is power http://www.vkinfotek.com