Is there a way to keep adding rows to an existing dataset? I have a stored
procedure that I need to call for every value, I then need to add the
results of the stored procedure to the same dataset or datatable so I can
validate it against my users.
so for example,
I need to call my stored procedure 3 times - once for each user
JSmith, SHenry, GDavid
I need to get the information for each user, collect it somehow, then pass
it all back to my validation method so I can make sure each user has the
correct information associated with it. Is there anyway of doing this?
I'm able to call the stored procedure 3 times by doing a foreach loop, but
its only returning me the data for the last user passed, I need all data for
all users. 2 1878
Steve,
Why not just call the Add method on DataRowCollection instance exposed
by the Rows property on the appropriate DataTable?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com
"Steve" <St***@community.nospam.comwrote in message
news:%2***************@TK2MSFTNGP06.phx.gbl...
Is there a way to keep adding rows to an existing dataset? I have a stored
procedure that I need to call for every value, I then need to add the
results of the stored procedure to the same dataset or datatable so I can
validate it against my users.
so for example,
I need to call my stored procedure 3 times - once for each user
JSmith, SHenry, GDavid
I need to get the information for each user, collect it somehow, then pass
it all back to my validation method so I can make sure each user has the
correct information associated with it. Is there anyway of doing this?
I'm able to call the stored procedure 3 times by doing a foreach loop, but
its only returning me the data for the last user passed, I need all data
for all users.
how does that work? I never used that.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.comwrote in
message news:eO**************@TK2MSFTNGP05.phx.gbl...
Steve,
Why not just call the Add method on DataRowCollection instance exposed
by the Rows property on the appropriate DataTable?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com
"Steve" <St***@community.nospam.comwrote in message
news:%2***************@TK2MSFTNGP06.phx.gbl...
>Is there a way to keep adding rows to an existing dataset? I have a stored procedure that I need to call for every value, I then need to add the results of the stored procedure to the same dataset or datatable so I can validate it against my users.
so for example, I need to call my stored procedure 3 times - once for each user
JSmith, SHenry, GDavid
I need to get the information for each user, collect it somehow, then pass it all back to my validation method so I can make sure each user has the correct information associated with it. Is there anyway of doing this?
I'm able to call the stored procedure 3 times by doing a foreach loop, but its only returning me the data for the last user passed, I need all data for all users. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Christopher Weaver |
last post by:
I'm trying to insert a new Row within an existing Table within an existing
DataSet using the following:
DataRow NewTaskRow = dsTaskActivities.Tables.NewRow();...
|
by: Jim Heavey |
last post by:
Trying to figure out the technique which should be used
to add rows to a datagrid. I am thinking that I would
want an "Add" button on the footer, but I am not quite
sure how to do that. Is that...
|
by: Chris Bingham |
last post by:
Hi,
I'm learning VB.Net at the moment, and while I'm doing it
I'm writing a couple of programs for work!
They all work with the same Access Database, but I'm
having a problem with modifying...
|
by: Graham Blandford |
last post by:
Hi all,
Would someone be able to tell me the most 'graceful' way of removing
unwanted rows from a dataset based on a condition prior to update? OR,
resetting the rows all to unchanged after they...
|
by: Rob |
last post by:
I am trying to copy some data from one datagrid to another. The first
datagrid containing data is called DocList. The blank Datagrid that I am
trying to copy some data to is called DataGrid1.
...
|
by: muntyanu |
last post by:
Hi all,
I have problem when merging existing DataTable into new dataset.
DataSet ds = new DataSet();
while ( done )
{
// fill myCustomDataSet.MyTable with data
ds.Merge(...
|
by: Andrew |
last post by:
Hi all,
I want to keep adding a row of data each time to the datatable of a dataset.
I see on msdn that I could do this:
ie.
workRow = workTable.NewRow();
workTable.Rows.Add(new Object {1,...
|
by: justin |
last post by:
One of the gridviews i'm using now apparently needs to have the added
functionality of re-arranging the order of the records it's
representing. These records have a priority field which the dataset...
|
by: =?Utf-8?B?SiBTdHJlZ2Vy?= |
last post by:
I have 2 methods activated through a context menu that insert and delete rows
from the dataTable linked to a datagrid.
I can delete rows the selected row with no problems, but when I try to use...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |