Solved

Vb.net Updating records

Posted on 2014-09-11
1
151 Views
Last Modified: 2014-09-15
Hi Experts

I have inherited some one's VB code and trying to learn it

He uses DataConnectors and readers he has created

My Question is I have a new Table I created and 4 TextBoxes and I want the TextBox.text for the 4 of them
to be added to the Table Fields 1 - 4
How using code like

Dim MySQL as string = "Select Field1, field2, field3, field44 from MYTable"
Dim prameters as New DataParameterConnector("@Id", Nothing)
Dim Reader1 as Data.IDataReader = Company.DataConnector.getreader(sql, nothing)

Thanks
0
Comment
Question by:Kevinfeening
1 Comment
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 40323318
If you have an IDataReader, then you can access the fields like this:

TextBox1.Text = Reader1("Field1").ToString()

Open in new window

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction During my participation as a VBScript contributor at Experts Exchange, one of the most common questions I come across is this: "I have a script that runs against only one computer. How can I make it run against a list of computers in …
This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now