Question - Dataset

[Anddmx]

Hi,

I have question on dataset that is getting is data from store procedure from mssql server. Once I get the data in to dataset all records are group by City then I need all the same City's to be send to its own datatable or dataset not sure which one would be better to use. I just don't know how to get the grouped records out from dataset and send it to another datatable / dataset with one city at time then send it to method that well then go through the step of creating pdf that then well be fax to hotels in that city.

Don't need help with creating pdf just need the help with getting records from dataset and sending it to method which then does the rest.


Connect to Database > Exec SP > Dataset > Get Grouped By City > Datatable or Dataset > New Method to Build PDF


Thanks

Chris A

 

[jmeckley]

google "DataSet grouping" there are countless tutorials on this process.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[Anddmx]

I did try that before I posted and didnt find anything that would get me in the right direction.

 

[jmeckley]

http://support.microsoft.com/kb/326145

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[Anddmx]

Thanks Jason,