Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 12th, 2005, 08:16 PM
Registered User
 
Join Date: Aug 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default need help in vb.net update code

SqlConnection1.Open()
        Try
            Dim str = "update tbluser set password='" & txtpass.Text & "',fname='" & txtfn.Text & "',lname='" & txtln.Text & "' where name='" & txtname.Text & "'"

            Dim com = New SqlCommand(str, SqlConnection1)
            com.ExecuteNonQuery()
            lblmsg.Text = "Record Updated Successfully"
            SqlDataAdapter1.Update(Ds1, "tbluser")

        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try
sqlconnection1.close()

the above is my code for updating textbox values...........
i am using vs.net IDE but its not updating the records........
there is no error but still not updation.........
its just like pain in the neck.............
need urgent help..............

Thanks in advance.....





Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem VB.NET 2005 - update data in Ms Access Netuser Pro Visual Basic 2005 0 August 1st, 2008 01:34 PM
Getting VB.NET to load & update XML file kyma XML 0 March 19th, 2005 04:58 PM
Database Insert/Update problem with VB.NET form tino mclaren VB Databases Basics 2 February 4th, 2005 05:12 AM
Can'T find code to Beginning Asp.net using VB.NET darruler All Other Wrox Books 1 August 12th, 2004 05:04 PM
ASP.NET Using VB.NET Chapt 3 Code error? uh6uj All Other Wrox Books 1 February 26th, 2004 10:46 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.