I used the GridView1_RowDeleting Event to delete from the gridview .
use sonia
select * from Info1
drop table Info1
create table Info1(UID integer,FirstName Varchar(100),LastName varchar(100),EMail varchar(100),Address varchar(100),PhoneNo varchar(100))
Insert into Info1 values(1,'Sonia','Sardana','a@yahoo.com','FBD','2222')
Insert into Info1 values(2,'Shouvik','Choudhary','b@yahoo.com','KolKatta','9848484474743')
Insert into Info1 values(3,'A','Ad','ds@yahoo.com','qqwD','9444212270')Suppose I delete record that has UID 2,Now I want that mine records to be in database are
1 Sonia Sardana a@yahoo.com FBD 2222
2 A Ad ds@yahoo.com KolKatta 9444212270
Which Query to be Used that update all the records in database!!