ADO.Net >> how to verify the data set filling the right data table

by Hello » Sun, 21 Sep 2003 18:21:41 GMT

Hi all,

I am now writing 1 stored procedure(sp) which execute
other 2 sp, therefore result of 2 data set and 2 dataset
tables. But how can I ensure the right dataset filling
the right tables so that .net crystal report can access
the table's result to generate report.
Please help me, it drive me nearly crazy because I cannot
generate the subreport. Please help me.

P.S. I want 2 sp are independent for query. But just have
1 key of them can be joined.

Thanks and regards,

ADO.Net >> how to verify the data set filling the right data table

by William Ryan » Sun, 21 Sep 2003 22:48:38 GMT

I'm kind of confusted but I think we can figure it out. Datasets don't fill
datatables, they simply contain them. From your post, it sounds like you
are making only one call to the stored proc and trying to fill four tables?
Can you post the code, it might be a little more clear and I could probably
give you some better suggestions.

Similar Threads

1. Object reference not set to an instance of an object for data table fill - VB.Net

2. Need help with populating table control with data from a data set


I don't have much knowledge of the table control. I am basically trying to 
use a table thats populated with data rows from a dataSet but currently 
things aren't working for me.

below is the sample HTML that I have:

	<asp:TableCell Text="Company" ID="CompanyCode" 
	<asp:TableCell Text="Paygroup" ID="PaygroupCode" 
	<asp:TableCell Text="paygroup descr" ID="PaygroupDescr" 


In addition, I think I need some VB code to assign the particular data rows 
to the table columns, but I'm not sure of the syntax:

 Table1.ID("Company") = Dr("Company")

Any help would be much appreciated.



You've got to live and learn...

3. Convert an untyped Data Table to a typed Data Table - VB.Net

4. Data Adapters, Data Sets, Data TableMappings, and XML

Here's what I'm trying to do:

1. Create a data adapter with Select and Insert commands.

2. Use DataTableMappings to map XML tags into columns in a 
data base table.

3. Create a dataset

3. Read in a schema using dataset.ReadXmLSchema

4. Read in an xml file that contains the data using 
dataset.Read XML

5. Add 3 new columns to the dataset. (These columns have 
already been mapped in step 2).

6. Put data in the 3 new columns.

7. Modify some data in the other columns using xpath 
queries to find the nodes that need changing.

8. Use datadapter.update(dataset, tablename)

Everything seems to work fine until step 8. I get all the 
data, the extra columns get added, and the data in other 
columns gets modified. When I execute step 8 I get:

Run-time exception thrown : 
System.InvalidOperationException - Cannot add or remove 
columns from the table once the DataSet is mapped to a 
loaded XML document.

Any ideas about how I can either fix this or do it another 


5. problem with data adapter and data set while inserting and retrieving data - VB.Net

6. Fill Database Table with Sample data

I want to load some sample data for my nunit unit tests in the database. 
And I want to do this by taking the data from a file, preferably an xml file that is generated by the command "SELECT * FROM SomeTbl FOR XML AUTO". I want to load this back to the table without much effort. 
Is there a simple way of doing this?
Is there any adapter that lets me fill the database table using the xml file?


7. fill some tables is dataset with cached data ? - ADO.Net

8. Fill data in Excel table

I need to fill data in Excel table. I have an Excel workbook, where
some values should be filled in specified cells. I need to do this
without COM interop, because i don't have Excel installed. I red that
ADO.NET does not support 'Insert' and 'Update' statments against excel
files. Any ideas how to fill the table?