oledb connection

Question

User694604870 posted

hi

i am trying to update my database via a textbox on my web page.

so that when a number is entered into this textbox and the button is clicked, it goes and changes the previous value to the one u have just entered.

but its not working :(

here is my code.

*****************************************************************************

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click

Try
    '       cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Ash\MyDocuments\platypus_holidays.mdb;")   'Connection String
   

cn.Open()
   

str = "update holidays set holidays_left=" & CInt(TextBox3.Text)
   

cmd = New OleDbCommand(str, cn)
   

icount = cmd.ExecuteNonQuery
   

TextBox4.Text = "The value was change to " & icount
   
    Catch
            TextBox4.Text = "The value was not Updated"
    End Try
   
    update_holiday_values()
    cn.Close()
    End Sub

*********************************************************************************************

any help would be greatly appreciated!!

also i am quite new to this so simple answers and samples of code would be great!

thanks in advance.

Answer 1

User-1148431695 posted

Hi,

The method ExecuteNonQuery() will return you the number of records affected. If you want to display the updated value from the table, you will need to write sql select query to get the data from the table and store it in variable. 

Answer 2

User-1696311824 posted

Hi

ExecuteNonQuery() is methods.. and its returns no of afftected rows in Icount...

for changed values write select holidays_left from holiday where.... condition...

it should work. if u have any error. let me know.......

Thanks

Answer 3

User-1696311824 posted

hi

For ur query.. please refere this link

http://rathodbhavesh.wordpress.com/2011/05/08/oledbconnection/

Thanks

Bhavesh Rathod