Search Result

user1980 · Jun 30 '11, 08:46 PM

hi,

I am using datarelation to join two datatables.
Here is my code,

Code:

 Dim dt1 As New DataTable
            dt1.Load(dr1)
            Dim dt2 As New DataTable
            dt2.Load(dr2)

            Dim datarelation As DataRelation
            Dim dc1 As DataColumn
            Dim dc2 As DataColumn
            Dim ds As New DataSet

            ds.Tables.Add(dt1)

...

GaryTexmo · Jun 24 '11, 09:59 PM

NOTE: The source for the utility class is included as an attachment. See the end of this post for details.

So from time to time I've needed to work with DataSets, either to prototype something or just experiment with them and I've always found it a pain to create them. Visual Studio has a designer, but I've always found you need to connect to a database (or an Access file) to create them, which is more than I want to do when I need some...

Siobhan Shum · Feb 11 '11, 08:42 PM

To All,

I have already coded a quantity form to show when a picture is clicked on. I have also created a dataset called 'Menudataset1' to retrieve information from my 'Menu' table and 'Dish Name' column.

I am now trying to code the 'label1' of the quantity form to change to the name of each picturebox when it is clicked on. I have already named each picturebox by their dish name.

Code so far:
...

Siobhan Shum · Feb 11 '11, 12:08 AM

To All,

I have created a 'quantity' form to be displayed when an image of a dish (from my menu) is hovered over:

Code:

quantity.Show()

I am now trying to code the 'quantity' listbox function to store '1,2,3..' and program the prices from the database into each dish. When 'ok' is clicked on the 'quantity' form it should also automatically updates the 'total' textbox.

I think I...

Daniel Halvorse · Jan 22 '11, 11:19 PM

hi I am working on an application that manages the data in a access database. but i cant seem to get past this error.

When i try to run it it says:
"Syntax error in INSERT INTO statement" syntax error, I have made all the fields in database TEXT(255) so it cant be that.

any help regarding this will be much appreciated, i am new to datasets and would love any help or guides i can get on the matter....

sameerdev · Nov 16 '10, 11:28 AM

Hi,

I want to fetch record multiple from tables (present month). I am sending to u code Problem is in bold section.

Question is that how can update dataset & dataadipter ?

string month = DateTime.Now.Mo nth.ToString();
string year = DateTime.Now.Ye ar.ToString();
string days = DateTime.DaysIn Month(Convert.T oInt32(year),Co nvert.ToInt32(m onth)).ToString ();...

Tom Loder · Nov 4 '10, 01:51 PM

I want to create a dataset at runtime from an access database (or another database) but at designtime I don't know the structure.

Ideally what I want to do is:

Code:

Dim ds as new DataSet = OpenAccessDB("MyAccessDB.mdb")

or

Code:

Dim ds as new DataSet = OpenDB("MyConnectString")

At the moment I only want to read in the database,...

Sri13 · Sep 22 '10, 06:42 PM

Hi

I have 3 tables related by some keys. I add these three tables to a dataset and finally write to XML file. The XML file is then sent to the client. Since I added the relations, the XML shows proper hierarchy. I am facing an issue that the XML file shows the related data in sequencial order. Ex:

Code:

<table1>
  <table1_col1>col1</table1_col1>
  <table1_col2>col2</table1_col2>

...

Infog · Sep 20 '10, 09:39 PM

Is it possible to edit a strongly typed dataset so that each table and column has additional properties?

If I could record the ValueMember and DisplayMember for each table I'm using, I could write a general solution for my display layer that is much shorter than coding the "data --> display" part of the windows form every time I need to display a DataGridView, ComboBox, etc.

Parameswar Nayak · Aug 11 '10, 12:58 PM

I have two same tables having same fields but table names are dirrerent.In a report I need all data from the two tables using a dataset in asingle table.So i can pass it to crystal report

louche · Apr 22 '10, 08:17 AM

A dataSet(global variable) is shared between two serial threads. one thread change the dataset, and the other thread save the dataSet to DB2. In the later thread, one action is copy the shared dataset( use the DataSet.Copy()) . After the previous thread run once. the later thread is very slowly. the time used on the copy action is about 22 seconds. But if the previous thread stoped, the time exhausted on copy action is 5 seconds.

...

Pabicoch · Mar 19 '10, 12:25 AM

Hi ok i have 3 tables "pics", "shows" and "showspics" .

I have a list box which displays all the titles of the shows(listbox1) and a list box which shows all the titles of the pictures in that show(listbox2).

Im havin a problem filling the latter listbox (listbox2). I know I need to use data sets, adapters etc but everything i try keeps failing. Heres my code

Code:

...

diaboloent · Jan 29 '10, 11:04 AM

I have three forms similar to the one in the link.
Each form has a table from a dataset attached to it.
I want add a Total textbox to every form.
Meaning 3 forms, 3 tables, 3 total boxes that display the sum of the amount values that were entered by the user during every entry.
The total will add the values that will be entered in the montant textbox.
So the total will take the specific value of that texbox for...

GeorgioBuzz · Jan 5 '10, 10:51 AM

I write this code :

MyCombo.Selecte dIndex = MyCombo.Items.I ndexOf ("MyString")

this line return -1 as the index value ( it means MyString is not found)

"MyString" exists in the items list. MyCombo is filled with the following code :

MyCombo.DataSou rce = MyDataSet.table s
MyCombo.Display Member = "...."
MyCombo.ValueMe mber = "...."...

jchaturv · Nov 6 '09, 08:48 AM

All,

I have a customized DataGridView where I have implemented extra functionality and bounded datasource in the same custom DataGridView (Using

C# and .NET). Now, I could able to use it properly by placing it on a panel control. I have added label as button on panel control to display

data from datasource on to datagrid and create a binding source. Another Label which act as a button is used to update...

Search Result

Question about Datarelation and dataset

Load a DataSet (or DataTable) from a 2D array of objects

How to code the label in form to display the name of each picturebox?

How to link a database into vb studio 2008 to create an order form?

How to fix "Syntax error in INSERT INTO statement" using OLEDB?

How to update dataset ?

How to create a dataset from access database at runtime

How to rearrange datacolumns in a dataset from related datatables

Custom programming of a strongly typed datatable?

two same fields table,I need all data in one dataset in single table

DataSet.Copy is very slowly

Selecting a item from one data table and getting the items from another - csharp

How add data fhat are entered by user in a data table

I would like to get the item index of a string located in a comboBox.

Binding data to the custom DataGridView