how to use Update command from tableadapter

Question

Hello Everyone I have retrieved data in Grid View from wizard.. I have modified 2 fields in Grid View I need to update the same using update command using table-adapter. Can anyone help me how to use update command... Thanks in advance..

Nir Bar · Answer

Hi Chetan You should use a derived class of DbDataAdapter that matches the DB server you're using. Then You need to set the DbDataAdapter. UpdateCommand with your command text (such as SQL command or whatever DB you're using) Then you call DbDataAdapter. Update () Please mark this post as an answer if it helps you Nir

chetan bhattad · Answer

Hi Can you give me a example code. Thanks