How to update SQL Server database from ASP.NET WebPage

Hi Saksham
You should consider familiarizing yourself with entity framework, but if you want to achieve just an update fast and easy:

using System.Data.SqlClient; 

protected void Page_Load(object sender, EventArgs e)
        {
            string connectionString = "blablawhichconnectstomyddatabase";
            string sql = "update tbl_x set MyColumn = '{0}' where MyId = {1}";
            int idKey = 1;
            sql = string.Format(sql, "myvalue", idKey);

            using (var cn = new SqlConnection(connectionString))
            {
                var cmd = new SqlCommand(sql, cn);
                cmd.ExecuteNonQuery();
            }
}

see tbl_x substitute with your table name and MyColumn with your column and MyId with your primary table ID value.

There are many more fancy ways of getting the task done, but just a simple update, note the quoting around string and the non quoting when simple data type like the MyId.

Alternatively you can have a crack at using object data sources, they're very good if you like guides and wysiwyg's http://msdn.microsoft.com/en-us/library/aa581783.aspx[^]