Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SiThia
Starting Member
1 Post |
 Posted - 2009-12-03 : 14:17:13
|
| Hi, Is it possible to use a dataset value as a default value for a second dataset?Here is the problem:I have to create two datasets, the first one is populated by a stored procedure and returns the data list for a simple tablix and a single value. Which shows no difficulty. The second dataset must be populated by a stored procedure also, but the problem is, it has to get a parameter(single value) from the first dataset results.Is there a way to do it easily, or do I have to use tricks (or maybe magic...) |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-12-03 : 14:26:45
|
| I think temp table will solve your problem!Store the data list into a temp table and make use of it for next result set.Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2009-12-07 : 05:16:00
|
| There are 3 methods for copying DataSet. U can check them at MSDN for description & details..1) .Copyhttp://msdn.microsoft.com/en-us/library/system.data.dataset.getchanges(VS.71).aspx2) .Clonehttp://msdn.microsoft.com/en-us/library/system.data.dataset.clone(VS.71).aspx3) .GetChangeshttp://msdn.microsoft.com/en-us/library/system.data.dataset.getchanges(VS.71).aspxRAQ Report: Web-based Excel-like Java reporting tool |
|
|
|
|
|
|
Dependency beetween different datasets