Hi. friends

I am usind the following code to update the table.
this event occure when the submit button hits.

Sub submit_Click(ByVal sender As Object, ByVal e As ImageClickEventArgs)


             Dim strSQL As String
             Dim strStuID As String



             Dim Cookie as HttpCookie = Request.Cookies("dashUser")


             strSQL = "UPDATE alt_ed_attendance SET ATTEND_RSN= " & txtReason.SelectedItem.Value & " WHERE permnum = " & strStuID & " "



                'Dim myConnection As OleDbConnection = New OleDbConnection("PROVIDER=MSDAORA.1;Password="";Us er ID="";Data Source="";Persist Security Info=true")
               'Dim myCommand As OleDbDataAdapter = New OleDbDataAdapter(strSQL, myConnection)
               'Dim mybuild as OleDbCommandBuilder= new OleDbCommandBuilder(myCommand)
               'myCommand.updateCommand = mybuild.GetUpdateCommand()



                Dim myConnection As OleDbConnection = New OleDbConnection("PROVIDER=MSDAORA.1;Password="";Us er ID="";Data Source="";Persist Security Info=true")
                Dim myCommand As OleDbCommand = New OleDbCommand(strSQL, myConnection)
                Dim result

                Try
                    myConnection.Open()
                    result = myCommand.ExecuteNonQuery




                Catch err as Exception

                Finally
                  If (Not myConnection is Nothing) Then


                     myConnection.Close()
                     Response.Redirect ("data_taft1.aspx")
                  End If
                End Try


    end Sub



if anybody can guide me please .....


Aashish Shah

__________________
Aashish Shah

What data type is the field ATTEND_RSN? Unless it's a numeric field you'll need to wrap the value in single quotes. Or you could use the parameters collection of the command class.

Peter
------------------------------------------------------
Work smarter, not harder.

thanks peter..

it is string .. if have also tried it with wraping it in a single quotes too.. I have tried both the method of connection to data base.
but not able to understand that what is the problem..
did i coded wrong for update query or what ...
I dont understand .. can you help me out for this problme .. It will be grate help of yours... thanks
aashish

Aashish Shah

What is the actual error you are getting?

error is not comming out.. but when I am checking the table when I am running query in PLSQL the data is not there..


thats the problem.. thanks
aashish

Aashish Shah

Try
                    myConnection.Open()
                    result = myCommand.ExecuteNonQuery




                Catch err as Exception
                    response.write(err.message)
                Finally
                  If (Not myConnection is Nothing) Then


                     myConnection.Close()
                     Response.Redirect ("data_taft1.aspx")
                  End If
                End Try

Also here is how you can use ado.net to update:

strSQLQuery = "UPDATE [table_name] SET [column_name1]=@YourNamedParameter1, [column_name2]=@YourNamedParameter2 WHERE ([table_name].[id] = 1)"

        objCommand = New OleDbCommand(strSQLQuery, objConn)

        objCommand.Parameters.Add(New OleDbParameter("@YourNamedParameter1", OleDbType.Date, 25))
        objCommand.Parameters("@YourNamedParameter1").Valu e = now()

        objCommand.Parameters.Add(New OleDbParameter("@YourNamedParameter2", OleDbType.Char, 100))
        objCommand.Parameters("@YourNamedParameter2").Valu e = txtEvent.Text

        objConn.Open()
        objCommand.ExecuteNonQuery()
        objConn.Close()

thanks
with the ado.net it work out.. thanks


Aashish Shah