Hi Everyone I need a syntax for update statement LIke this:
cmd.CommandText = "UPDATE tab(tab_id,tab_name) SET tab_name=@tname WHERE tab_id=@tab_id";
this one aint working ,Somebody please help.
I have two textboxes tab_id,tab_name
I have to Update tab_name based on tab_id,...when i Click content of datagridview then I will get the content into textboxes like tab_id ,tab_name will be drawn from the grid to the textboxes.
If I change the values from tab_name and click update button it should update both grid as well as underlying database.
Thanks In advance.