Order column in a datatable

Posted by superartsy on Stack Overflow See other posts from Stack Overflow or by superartsy
Published on 2011-01-12T19:48:35Z Indexed on 2011/01/12 19:54 UTC
Read the original article Hit count: 162

Filed under:

dataset

I have two tables - Parent table (Clients- ClntID,ClntName) And Child Table ( Orders- ClntID,OrderNumber,OrderDate) - Order Number column has a value equal to how many orders the Client has. It is not an autonumber

ClntID ClntName

1 Company A 2 Company B

ClntID OrderNumber OrderDate

1 1 11/1/2009 1 2 11/15/2009 2 1 2/12/2008 2 1 7/13/2009

If I have a dataset for these tables, how do I insert the data in the Orders table and increment the OrderNumber value correctly.

Related posts about dataset

Dataset -> XML Document - Load DataSet into an XML Document - C#.Net

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello I'm trying to read a dataset as xml and load it into an XML Document. XmlDocument contractHistoryXMLSchemaDoc = new XmlDocument(); using (MemoryStream ms = new MemoryStream()) { //XmlWriterSettings xmlWSettings = new XmlWriterSettings(); //xmlWSettings.ConformanceLevel = ConformanceLevel… >>> More
Combine multiple dataset columns to one dataset

as seen on Stack Overflow - Search for 'Stack Overflow'
I have multiple datasets that I would like to combine into one. There is a common ID field that can be associated to each row. Calling Merge on the dataset will add additional rows to the dataset, but I would like to combine the additional columns. There are too many fields to do this in one query… >>> More
Making a DataSet from another DataSet

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi folks I have a client-server project (small project for companies in C#) and the server has a DataSet with some tables (there is no Database for some reasons so we save the DataSet as an XML file). when the clients connect to the server, the server should send some informations to the client depends… >>> More
Declaring variables with New DataSet vs DataSet

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the impact of creating variables using: Dim ds as New DataSet ds = GetActualData() where GetActualData() also creates a New DataSet and returns it? Does the original empty DataSet that was 'New'ed just get left in the Heap? What if this kind of code was in many places? Would… >>> More
DataSet.Copy vs Dataset.Clone

as seen on Stack Overflow - Search for 'Stack Overflow'
Can someone explain me DataSet.Copy vs Dataset.Clone Also let me know some scenario's where we can use these >>> More

Developer IT

Order column in a datatable - Developer IT

Order column in a datatable

dataset

ClntID ClntName

ClntID OrderNumber OrderDate

Related posts about dataset

Dataset -> XML Document - Load DataSet into an XML Document - C#.Net

Combine multiple dataset columns to one dataset

Making a DataSet from another DataSet

Declaring variables with New DataSet vs DataSet

DataSet.Copy vs Dataset.Clone

Categories cloud