-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: commander4u
Message 3 in Discussion
I think not limit or upto MaxValue of long or int(datatype of
DataSet.Tables.Count property)!!!! It just depends on the memory u
have....!!!
BTW, how many tables u r planning to add into a Dataset....
I just created a sample app and tried to add int32.MaxValue datatables
containing just one column with just one row in it. I started that
program one hour back.. and is still running.... no exception!!!!!!
here is the code:
public long CreateDataSetWithMaxTables() {
DataSet dt = new DataSet("MyDataSet");
long rowCount = 0;
try {
for(rowCount = 0; rowCount <= Int32.MaxValue ;
rowCount++) {
DataTable dTable = new
DataTable("MyTable" + rowCount.ToString());
DataColumn dColumn = new
DataColumn("MyColumn");
dTable.Columns.Add(dColumn);
DataRow row = dTable.NewRow();
row["MyColumn"] = 11;
dt.Tables.Add(dTable);
}
}
catch(Exception e) {
Console.WriteLine(e.Message);
return rowCount;
}
return rowCount;
}
just call this method from the Main method and see what count it
returns on your machine.
On 5/13/05, amolgholap <[EMAIL PROTECTED]> wrote:
> -----------------------------------------------------------
>
> New Message on MumbaiUserGroup
>
> -----------------------------------------------------------
> From: amolgholap
> Message 2 in Discussion
>
> hi friends
>
> What is the maximum number of table in dataset?
>
> Regards
> Amol
>
> _________________________________________________________________
> Kareena or Rani? Saif or SRK? http://server1.msn.co.in/sp05/iifa/ Rock your
> vote now at IIFA.
>
> -----------------------------------------------------------
>
> To stop getting this e-mail, or change how often it arrives, go to your
> E-mail Settings.
> http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
>
> Need help? If you've forgotten your password, please go to Passport Member
> Services.
> http://groups.msn.com/_passportredir.msnw?ppmprop=help
>
> For other questions or feedback, go to our Contact Us page.
> http://groups.msn.com/contact
>
> If you do not want to receive future e-mail from this MSN group, or if you
> received this message by mistake, please click the "Remove" link below. On
> the pre-addressed e-mail message that opens, simply click "Send". Your e-mail
> address will be deleted from this group's mailing list.
> mailto:[EMAIL PROTECTED]
>
--
Thanks and Regards,
Commander
visit my blog at : http://dotnetcapsule.blogspot.com
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
