Najam Sikander Awan

covering web stack along with microsoft technologies

Sql Data Srouce Control Updating Data From Database

| Comments

hey guyz finally we have to learn how to update our tables in database so only for you guys here is my sample code

1
2
3
4
5
6
7
string giftId = GridView1.SelectedRow.Cells[0].Text.ToString(); //getting an id
SqlDataSource myDbSource = new SqlDataSource();
myDbSource.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//myDbSource.InsertCommand = "update gifts set giftActivate=1 where giftId=" + Entrydate + ")";
myDbSource.UpdateCommand = "update gifts set giftActivate='1' where giftId=" + giftId;
myDbSource.ProviderName = "System.Data.SqlClient";
myDbSource.Update();

Well this code set giftActive flag to 1 for all the rows matched with giftid value.

Comments