Gridview not updating DB - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Gridview not updating DB

FabioFabio Posts: 3Member
Hi all,
it's been a long long time I don't came here, but here I am again!

I'm sorry if this is (shurely) a stupid question, but I'm not able to solve a problem with an asp net 2.0/vb net code behind web application.
Here it is:

Event: "GridView1_RowUpdating"
After modifing values in "gridview1" control, i press "update" button, that obviously calls "gridview1_rowupdating" event.
All fine till here but... data values in DB (it's an access db) are not updated, they still remain the same as before.

Here below is the code, what I'm doing wrong?

[code]
Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridView1.RowUpdating

Dim strConnString As String = ConfigurationManager.ConnectionStrings("conn_oledb").ConnectionString
Dim conn As New OleDb.OleDbConnection(strConnString)
Dim objreader As OleDb.OleDbDataReader
Dim command As New OleDb.OleDbCommand
command.Connection = conn

Dim f1 As Long
Dim id As Integer

f1 = DirectCast(GridView1.Rows(e.RowIndex).Cells(1).Controls(0), TextBox).Text
id = Integer.Parse(e.RowIndex)

'i valori id ed f1 fin qua vengoo correttamente assegnati

e.Cancel = True
conn.Open()
command.CommandText = "UPDATE tabella SET f1= @f1 where id= @id"
command.Parameters.AddWithValue("@f1", f1)
command.Parameters.Addwithvalue("@id", id)
command.ExecuteNonQuery()
GridView1.EditIndex = -1
[/code]

P.S.
Last but not least: sorry for my so bad english, hope you understand!
Sign In or Register to comment.