update and delete query using sql server 2014

Question

hello  how can i use update and delete query in c# application form. i'm using SQL Server 2014 database name is : Test1 table name is : First Column's are : Name Address Number . if u guys have any idea then plz help me out

Sneha Sneha · Answer

To update and delete you need a unique identity column first on that basis you can update and delete. lets say u have name as unique identity on that basis i will give you query of both. To update .... update tablename set column name1 = value columnname2=value where columnname=unique identity; now according to your table.....the update query will be:- update First set Address=NepalNumber=4567687 where Name=Irfan; _______________________________________________________________ now similarly to delete query will be:- Delete * from First where Name=Irfan; _________________________________________________________________ if any doubt then reply me. Regards.

g s · Answer

Update & Delete Query http://dotnetdrizzles.blogspot.in/2014/09/delete-query-in-sql-server-using-aspnet.html http://dotnetdrizzles.blogspot.in/2014/09/update-query-in-sql-server-using-aspnet.html

Sneha Sneha · Answer

My pleasure. Are that queries help you somewhat?

Muhammad Irfan · Answer

bundle of thanks...........Sneha