Click here to Skip to main content
16,006,749 members
Home / Discussions / C#
   

C#

 
GeneralRe: generic collections of generic collections - .net 2.0 Pin
led mike6-Mar-07 4:24
led mike6-Mar-07 4:24 
QuestionLocking data to user Pin
Dominik Reichl5-Mar-07 5:40
Dominik Reichl5-Mar-07 5:40 
AnswerRe: Locking data to user Pin
Dave Kreskowiak5-Mar-07 5:48
mveDave Kreskowiak5-Mar-07 5:48 
QuestionRe: Locking data to user Pin
Dominik Reichl5-Mar-07 5:58
Dominik Reichl5-Mar-07 5:58 
GeneralRe: Locking data to user Pin
Dominik Reichl5-Mar-07 7:54
Dominik Reichl5-Mar-07 7:54 
Questionhow to create SetUp package for my app in VS2005 setup project ? Pin
hdv2125-Mar-07 4:17
hdv2125-Mar-07 4:17 
AnswerRe: how to create SetUp package for my app in VS2005 setup project ? Pin
kubben5-Mar-07 4:55
kubben5-Mar-07 4:55 
Question.TableMappings.Add Pin
arkiboys5-Mar-07 4:15
arkiboys5-Mar-07 4:15 
Hi,
A stored procedure runs three select queries.
Each of these select queries is being assigned to a table (See below).
The question is: In this case I know how many tables are returned so I use the "oDA.TableMappings.Add" three times. But what if I do not know how many tables are returned? How can I make a dynamic loop arouond "oDA.TableMappings.Add"?

Alternatively, Is it better to retrieve the whole of data into one dataset and then separate the data into datatables?

This is what I am doing at present:
SqlDataAdapter oDA = new SqlDataAdapter(oCmd);

//use Tablemappings to name the retrieved tables...
//otherwise have to use indexes to refer to each table...
oDA.TableMappings.Add("Table", "Curves1");
oDA.TableMappings.Add("Table1", "Curves2");
oDA.TableMappings.Add("Table2", "Curves3");

DataSet dsData = new DataSet();

oDA.Fill(dsData);


This is what I am trying to do:
SqlDataAdapter oDA = new SqlDataAdapter(oCmd);

int i = 0;
foreach(table in oDA)
{
oDA.TableMappings.Add("Table" + i, "Curves" + i);
}

DataSet dsData = new DataSet();

oDA.Fill(dsData);
QuestionScrolling panel while drag & drop picturebox Pin
pettera5-Mar-07 3:47
pettera5-Mar-07 3:47 
QuestionRegex help required Pin
matthias s.5-Mar-07 3:46
matthias s.5-Mar-07 3:46 
AnswerRe: Regex help required Pin
andyharman5-Mar-07 7:02
professionalandyharman5-Mar-07 7:02 
GeneralRe: Regex help required Pin
matthias s.5-Mar-07 7:28
matthias s.5-Mar-07 7:28 
Questionto make checkboxes visible in datagrid C# windows application Pin
salon5-Mar-07 3:36
salon5-Mar-07 3:36 
QuestionHow can I build plugins? Pin
olivervoll5-Mar-07 3:22
olivervoll5-Mar-07 3:22 
AnswerRe: How can I build plugins? Pin
Pete O'Hanlon5-Mar-07 4:10
mvePete O'Hanlon5-Mar-07 4:10 
GeneralRe: How can I build plugins? Pin
olivervoll6-Mar-07 0:26
olivervoll6-Mar-07 0:26 
QuestionUpdating GUI controls from C# Class Library...??? Pin
zinc_z5-Mar-07 2:47
zinc_z5-Mar-07 2:47 
AnswerRe: , Pin
sharpiesharpie5-Mar-07 3:02
sharpiesharpie5-Mar-07 3:02 
GeneralRe: , Pin
zinc_z5-Mar-07 4:55
zinc_z5-Mar-07 4:55 
GeneralRe: , Pin
Pete O'Hanlon5-Mar-07 5:08
mvePete O'Hanlon5-Mar-07 5:08 
QuestionSmpp Pin
saltcode5-Mar-07 1:32
professionalsaltcode5-Mar-07 1:32 
AnswerRe: Smpp Pin
sharpiesharpie5-Mar-07 3:02
sharpiesharpie5-Mar-07 3:02 
GeneralRe: Smpp Pin
saltcode5-Mar-07 4:05
professionalsaltcode5-Mar-07 4:05 
QuestionGetting Error while creating a Web Application....Please help Pin
Jayaraman B5-Mar-07 1:26
Jayaraman B5-Mar-07 1:26 
AnswerRe: Getting Error while creating a Web Application....Please help Pin
Paddy Boyd5-Mar-07 4:28
Paddy Boyd5-Mar-07 4:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.