Sql Data Srouce Control Updating Data From Database

Apr 30, 2008 in ADO.NET • ASP.NET • C#
1 min read

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.