What could be wrong on my function=

    Sub MyDataList_Update(Sender As Object, E As DataListCommandEventArgs)

    Dim Conn as OleDbConnection
    Dim edit_price as string
        Dim EditText As HtmlInputText
        Dim MyConnection as String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("bd1.mdb") & ";"
        Dim SQL as String = "update Tabela set numero='" & edit_price & "' Where nome=@nome"
    Dim Cmd as OleDbCommand

        EditText = E.Item.FindControl("edit_price")
    conn = New OleDbConnection(MyConnection)
    Cmd = New OleDbCommand(SQL, conn)
    Cmd.Parameters.Add(New OleDbParameter("@numero", "edit_price"))

    Conn.Open()
    cmd.ExecuteNonQuery()
    Conn.close
        MyDataList.EditItemIndex = -1
        Message.InnerHtml = "Price Updated: " & EditText.Value
        PopulateList()
    End Sub

Please help!

hi there..

first of all use a try catch construction in the executenonquery to receive an error and be able to correct it faster ;)

secodn, you have a parameter named @nome but you are passing the parameter @numero to the query...

HTH

Gonzalo

Thanx fot replying.
With all the changes I've been trying some code was missing there:


Dim SQL as String = "update Tabela set numero=@numero Where nome=@nome"
Dim Cmd as OleDbCommand

EditText = E.Item.FindControl("edit_price")
conn = New OleDbConnection(MyConnection)
Cmd = New OleDbCommand(SQL, conn)
Cmd.Parameters.Add(New OleDbParameter("@numero", "edit_price"))
Cmd.Parameters.Add(New OleDbParameter("@nome", "Nome"))
                                                ^====
I think the problem must be here:
I want to change @numero and I want to keep @nome
and I don't know what code shall I use to keep @nome

Ghozt

The code I posted is a conversion from a Datagrid.
With Datagrid it works but not with Datalist.
The main change and where I think the source of the problem is is on this line of code:

(datagrid)
  MyCommand.Parameters.Add(New OleDbParameter("@EmpID", e.Item.Cells(1).Text ))

I don't know how to convert it to Datalist.
Can someone help me?

Ghozt