Configure DataAdapter for DataTable

nitromuse

Can you please tell me how to configure the adapter (DATA
SOURCE AND PROVIDER) for a data table that I generated
myself as a DataTable. It was easy to create it but now
accessing it isn't.
YOUR HELP IS APPRECIATED !!

Nov 20 '05 #1

Subscribe Reply

4833

One Handed Man [ OHM# ]

There is insufficent information here to do this. You have not stated your
source, or your control type or the nature of the data. Nor have you
provided any code.

Regards - OHM#

nitromuse wrote:

Can you please tell me how to configure the adapter (DATA
SOURCE AND PROVIDER) for a data table that I generated
myself as a DataTable. It was easy to create it but now
accessing it isn't.
YOUR HELP IS APPRECIATED !!

Regards - OHM# On**********@BT Internet.com

Nov 20 '05 #2

nitromuse

I was trying to do via the data adapter wizard rather
than code but I need to know how to refer to the data
source and provider for a datatable in order to do so.
Anything you can add is appreciated.

-----Original Message-----
There is insufficent information here to do this. You have not stated yoursource, or your control type or the nature of the data. Nor have youprovided any code.

Regards - OHM#

nitromuse wrote:
Can you please tell me how to configure the adapter (DATA SOURCE AND PROVIDER) for a data table that I generated
myself as a DataTable. It was easy to create it but now accessing it isn't.
YOUR HELP IS APPRECIATED !!

Regards - OHM# On**********@BT Internet.com
.

Nov 20 '05 #3

One Handed Man [ OHM# ]

OK, basically there are the following three things

Connector - Connects to your database source SQL server, Access etc
DataAdapter - This is the go between the DataSet/table and the connector
DataSet - this contains the DataTables and Relations , constraints etc.

Your wizard will have set up something like OLEDBDATACONNEC TOR1,
OLEDBDATADAPTOR 1 and you may or may not have generated a DataSet so far.

In the form load event you need to fill your custom table or dataset.

'If the control is a data grid for example

YourControl.Dat aSource = yourTable

OLEDBDATADAPTOR 1.Fill( yourTable )

OHM#

nitromuse wrote:

I was trying to do via the data adapter wizard rather
than code but I need to know how to refer to the data
source and provider for a datatable in order to do so.
Anything you can add is appreciated.

-----Original Message-----
There is insufficent information here to do this. You have not
stated your source, or your control type or the nature of the data.
Nor have you provided any code.

Regards - OHM#

nitromuse wrote:
Can you please tell me how to configure the adapter (DATA
SOURCE AND PROVIDER) for a data table that I generated
myself as a DataTable. It was easy to create it but now
accessing it isn't.
YOUR HELP IS APPRECIATED !!

Regards - OHM# On**********@BT Internet.com
.

Regards - OHM# On**********@BT Internet.com

Nov 20 '05 #4

Cor

Hi

Nitromuse, did you do a rightclick on the dataadapter on your form,
with that you can configure it and after that make the dataset.

I hope that was what you where looking for?

Cor

Nov 20 '05 #5

nitromuse

My problem is that I don't get anywhere with the Wizard
because I can't tell it the proper data source for my
self created datatable. If it were an outside database
it would be easy. I got all you had to say about the
connector, etc, I just need to know how to declare the
provider and source for a datatable, not a database.
Thanks again,

-----Original Message-----

OK, basically there are the following three things

Connector - Connects to your database source SQL server, Access etcDataAdapter - This is the go between the DataSet/table and the connectorDataSet - this contains the DataTables and Relations , constraints etc.
Your wizard will have set up something like OLEDBDATACONNEC TOR1,OLEDBDATADAPTO R1 and you may or may not have generated a DataSet so far.
In the form load event you need to fill your custom table or dataset.
'If the control is a data grid for example

YourControl.Da taSource = yourTable

OLEDBDATADAPTO R1.Fill( yourTable )

OHM#

nitromuse wrote:
I was trying to do via the data adapter wizard rather
than code but I need to know how to refer to the data
source and provider for a datatable in order to do so.
Anything you can add is appreciated.

-----Original Message-----
There is insufficent information here to do this. You have not stated your source, or your control type or the nature of the data. Nor have you provided any code.

Regards - OHM#

nitromuse wrote:
Can you please tell me how to configure the adapter (DATA SOURCE AND PROVIDER) for a data table that I generated myself as a DataTable. It was easy to create it but now accessing it isn't.
YOUR HELP IS APPRECIATED !!

Regards - OHM# On**********@BT Internet.com
.

Regards - OHM# On**********@BT Internet.com
.

Nov 20 '05 #6

Similar topics

2256

DataTable before DataAdapter possible?

by: randy | last post by:

Hello all, I have a DataTable which I am building column by column and adding rows after each new column. The DataTable columns match the columns in my database table. I'm building the DataTable first and I then want to roll through the DataTable while in memory checking for errors and then commit the rows to my database table (btw this is in ASP.NET). Is it possible to have data in a datable before attaching at DataAdapter? I'm a...

.NET Framework

2091

DataAdapter Not Updating

by: Doug Bell | last post by:

Hi, I thought I had this sorted this morning but it is still a problem. My application has a DataAccess Class. When it starts, it: Connects to a DB (OLE DB) If it connects it uses an OleDbCommand with an SQL String and the connection it has a DataAdapter with the command then it fills the DataSet's DataTable with the streamed data.

Visual Basic .NET

2698

DataAdapter, sedond update

by: Zorpiedoman | last post by:

I keep getting a concurrency exception the second time I make a change and attempt to update a dataadapter. It appears this is by design, so there must be something I can do to avoid it. Example: I have a dataadapter that contains one table with one row. I change the value of the 'FisrtName' column in that row from Jack to John. I call ..update on the dataadapter it goes through fine. Now I change that same column in that same row...

Visual Basic .NET

13969

DataAdapter UpdateCommand not updating record

by: susan.f.barrett | last post by:

Hi, Despite me being able to type the following in to SQL Server and it updating 1 row: > updatestockcategory 1093, 839 In my code, it is not updating any rows. dataSet = new DataSet();

C# / C Sharp

14002

why is dataAdapter.UpdateCommand not updating?

by: Rich | last post by:

Dim da As New SqlDataAdapter("Select * from tbl1", conn) dim tblx As New DataTable da.Fill(tblx) '--works OK up to this point da.UpdateCommand = New SqlCommand da.UpdateCommand.Connection = conn da.UpdateCommand.CommandText = "Update tbl1 set fld1 = 'test' where ID = 1" da.Update(tblx) '--tblx/tbl1 not getting updated here.

Visual Basic .NET

11168

DataAdapter.Update() and DataTable.GetChanges() side effect.

by: George | last post by:

Got a question about the side effect of DataAdapter.Update() and DataTable.GetChanges(). Say I set up a DataTable and a DataAdapter in a class. Delete (Not remove) a row in the data table and call the following method. public void JobListDataTableFromAccessCommitChange() { System.Data.DataTable oChangeDataTable;

C# / C Sharp

5045

DataAdapter.AcceptChangesDuringUpdate not working

by: George | last post by:

I have set DataAdapter.AcceptChangesDuringUpdate = true; However, I find that I still need to call AcceptChanges on the associated DataTable, DataTable.AcceptChanges(); Has anyone encountered that? Am I not setting this field properly? The following are some of the snippets of the codes which may help explain

C# / C Sharp

1460

dataadapter and stored procs in design time

by: limsy | last post by:

Hi ppl, Sorry for asking such a NEWBIE question. I tried looking for answers but cant find. Maybe its too easy. :( I'm used to manual code ADO rather than this .NET wizard and stuff... and i am really having hard time adjusting. *cry* I need to fill a dataadapter with data from a stored procedure. I figured how to create the dataadapter and link it to my database, but my stored proc needs INPUT parameters. Can i set a default value...

Visual Basic .NET

12518

difference between dataAdapter.InsertCommand/dataAdapter.SelectCom

by: Rich | last post by:

What is the diffeence bewtween a dataAdapter.InsertCommand and dataAdapter.SelectCommand (and dataAdapter.UpdateCommand for that matter)? Dim da As SqlDataAdapter conn.Open da.SelectCommand = New SqlCommand da.SelectCommand.Connectoin = conn da.SelectCommand.CommandType = Command.Text da.SelectCommand.CommandText = "insert Into tbl1 Select * from tbl2" da.SelectCommand.ExecuteNonQuery

Visual Basic .NET

9498

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10172

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10110

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8993

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6750

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5536

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4069

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3670

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2894

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General