Editing record does not bring about any result in asp.net

Question

I have following code to fill my dataset (ASP.Net).

Dim conStr As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbTest.mdf;Integrated Security=True;User Instance=True"
    Dim sqlQry As String = "SELECT * FROM tblTest"
Dim dAdt As New SqlDataAdapter(sqlQry, conStr)
Dim dSet As New DataSet()

dAdt.Fill(dSet, "tblTest")

Then I am using following to edit my record

Dim dRow As DataRow
    dRow = dSet.Tables("tblTest").Rows(1)
    dRow.BeginEdit()
    dRow.Item("Name") = txtName.Text
    dRow.EndEdit()
    dSet.Tables("tblTest").AcceptChanges()

it does not generate any error but does not edit the record too. Same is happening when I try to delete record using delete command. Please advise. Thanks

Does not edit the record in the DataSet or in the Database? It will not update the Database if that is what you are wanting — Tim B James, Sep 06 '11 at 15:05
I need to change record in the Database........ Could you kindly help me? — Furqan Sehgal, Sep 06 '11 at 15:14
You need to look into updating the database with ado.net http://msdn.microsoft.com/en-us/library/aa302325.aspx — Tim B James, Sep 06 '11 at 15:18
Yes and no. Yes in the way that you need to look into how to update a database using ado.net, and NO in the way that your code will not update the database the way you are doing it. — Tim B James, Sep 06 '11 at 15:24
Could you kindly modify my code to make it so? I shall be really thankful for you as this is really confusing for me. — Furqan Sehgal, Sep 06 '11 at 15:31
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/3215/discussion-between-furqan-sehgal-and-tim-b-james) — Furqan Sehgal, Sep 06 '11 at 15:41
It is not really for us to give you the answer to something which you have not even attempted to answer for yourself. — Tim B James, Sep 06 '11 at 16:03

score 0 · Answer 1 · answered Sep 06 '11 at 15:05

0

I think you need to call "update" before AcceptChanges.

Something like:

dset.Update();

answered Sep 06 '11 at 15:05

Jack Marchetti

15,536
14
81
117

score 0 · Answer 2 · answered Sep 06 '11 at 15:06

0

Try adding the BeginEdit() and AcceptChanges() methods, like this:

drRow.BeginEdit()
drRow("Name") = txtName.Text

dsSet.Tables("tblTest").AcceptChanges()

answered Sep 06 '11 at 15:06

James Johnson

45,496
8
73
110

Do you mean just remove drRow.EndEdit()? I tried it did not work. Result is the same, unchanged data. – Furqan Sehgal Sep 06 '11 at 15:14
Are you sure that drRow.Item("Name") works? Shouldn't it be drRow("Name") = txtName.Text? – James Johnson Sep 06 '11 at 15:43
Well I changed it but did not make any changes to my database – Furqan Sehgal Sep 06 '11 at 16:14

Editing record does not bring about any result in asp.net

2 Answers2