dataset

SSRS - Dataset(s) order of execution

I have a report that runs a Stored Procedure in Oracle. This procedure fills several tables with data in Oracle. I then want to query those tables and load several Tablix(s) in my SSRS report. I need the Stored Proc to run first. How can I ensure the Stored Proc runs before the DataSet queries that I use to fill the Tablix(s)? ...

Convert dataset to generic list of myclass

how can i convert dataset to generic lst of mycass using linq ...

Cascading auto-increment keys and C# DataSets - MS SQL vs MySQL

Hi Does anybody know why the cascading foreign key relationships to auto-incrementing primary keys in a .net DataSet behaves differently with MySQL vs. MS SQL? I'll flesh it out a bit. I created a parent table with an AI PK, and a child table with an AI PK and a foreign key field to the parent PK. Then I created a cascading relationshi...

Transforming XML so it can be read with DataSet.ReadXML

I have been given an XML document in a rather strange format and I need to load it into a DataSet, but unsurprisingly I get an error when I try to do so. I can see how I could transform the document into something that would work, but I'm kinda going around in circles with the XSLT stuff... The document looks something like this: <map>...

Trouble with Nullable Types, DBNulls and Data Rows

I saw this thread on Stack Overflow regarding converting between DBNull and nullable types but I am still confused. I have written code like this with some hack code to deal with nullable types for DateTime and ints that I will show below but it'sa mess and I want to use Nullable types: DataTable dt = ds.Tables[0]; List<RON> list = (f...

C# WinForms - how to send updates from DataGridView to DataBase

Hey, I have a .mdb file with a Customers table and an Agents table. The only thing that the Agents table does as yet is populate the Agent dropdown for each customer... I have a DataGridView linked to the customerBindingSource. The customerBindingSource has DataMember set to Customer and DataSource set to bindingSource1. This has the D...

Python XML Parse (using schema to generate dataset)

I'm looking to parse a xml file using Python and I was wondering if there was any way of automating the task over manually walking through all xml nodes/attributes using xml.dom.minidom library. Essentially what would be sweet is if I could load a xml schema for the xml file I am reading then have that automatically generate some kind o...

Mysql LIMIT statement in .NET TableAdapter query

Hi, I am adding the following query to a .NET dataset TableAdapter. select * from users ORDER BY RAND() LIMIT 0,10 But the LIMIT word is not recognized as a part of the query and I am unable to proceed further. Is there any workaround for this issue? ...

Undefined datatype: 'token'

Scenario: I am trying to collect information from xml file. To do so, i am using the xmlschema provided. plan is to readxmlschema against dataset and later read xml file. Please suggest me best process if the existing is not appropriate. Anways during this process i encountered this following issue. I am trying to readxmlschema into a d...

How to assign dataset dynamically to Fast report?

Hi all, I have created a report using Fast Report Designer and calling this using Delphi 6. But datasets for the master databad and the fields are not assinged at design time. Iwant to set these properties at runtime depends on the selected dataset. How can I do that. How can I access the dataset property of the master band in Delphi be...