473,287 Members | 1,663 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

TableAdaptor Update Access database

I used the wizard in VS2005 to create my connection, dataset, and tableadaptor

I have a typed dataset named dsUserInfo
I have a tableadaptor named taFillUserInfo

I would like to on the vb side be able to do update the database when a
button is clicked executing the following code.

if me.textbox1.text = "x" then
taFillUserInfo.text1 = me.textbox1
else
some message
End if

What I can't get is how to "call" my tableadaptor taFillUserInfo to get the
column names.
Jun 27 '07 #1
1 1390
Ysgrifennodd Andre:
I used the wizard in VS2005 to create my connection, dataset, and tableadaptor

I have a typed dataset named dsUserInfo
I have a tableadaptor named taFillUserInfo

I would like to on the vb side be able to do update the database when a
button is clicked executing the following code.

if me.textbox1.text = "x" then
taFillUserInfo.text1 = me.textbox1
else
some message
End if

What I can't get is how to "call" my tableadaptor taFillUserInfo to get the
column names.

I can't remember if this answers your question directly, but it should help:

http://www.peredur.uklinux.net/TypedDataSets.pdf

This example project (which is really about forms authentication), uses
a Typed DataSet. It definitely shows you how to use the Typed DataSet
using the column names:

http://www.peredur.uklinux.net/Forms...icationSln.zip

Note that the zip file contains a complete .NET solution. I cannot
guarantee that it is virus-free. I think it is; but I can't guarantee
it. So please examine the code and recompile it before running it.

Both the above use C# rather than VB, but I don't think that should give
you too much trouble. It might even persuade you to use C# :)

HTH
Peter
Jun 27 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Steve | last post by:
Hi, I currently display all the data on a website using tableadaptors and objectdatasources. Would it be significantly faster if I was to display the data by writing the code for a datareader...
0
by: G .Net | last post by:
Hi Can anybody give me a step by step guide on how to access a sql DataAdaptor via the new TableAdaptor in VS2005? More specifically, I want to override RowUpdated and I can't see how to do...
2
by: Andy B | last post by:
Is there an easy way to convert tableAdaptor queries into stored procs without messing up the dataTables in the dataSet or losing the queries themselves?
0
by: Rob | last post by:
Hi i'am working with Visual Basic 2005 using Ado.The problem is that I had to change a table in MsAccess (change several textfield/boolean into numeric fields). Now i want to update...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.