Order by tables with table name ascending on Dataset

Question

0.00/5 (No votes)

See more:

Hi fellow programmers,

I have a dataset having table names like
aa002500T0,hb004400T0,ba000300T0,ba000100T0,...
is it possible to change there order in ascending like below in front end
aa002500T0,ba000100T0,ba000300T0,hb004400T0,...

thanks & regards
george

Posted 12-Jan-15 18:33pm

george4986

Add a Solution

Comments

dan!sh 13-Jan-15 0:54am

Why would you need to do that?

george4986 13-Jan-15 1:14am

i am using a 3rd party reporting tool,by default it loads dataset tables without order

dan!sh 13-Jan-15 1:16am

And why does the order matter? You know the names of all the tables so you can access data whenever needed.

george4986 13-Jan-15 1:17am

yes but my client needs the ordering

dan!sh 13-Jan-15 1:18am

Why? Sorry, but this just does not make sense to me. Why does it matter how tables are stored in dataset?

george4986 13-Jan-15 2:05am

these tables are loaded on a reporting tools datasource section.I can access this dataset.Now am trying a way to reorder the tables.

4 solutions

Solution 3

Linq will simplify the stuff, using linq you can get many functionalities similar to sql
hope it helps you.

You can use orderby in linq

Find the sample below

http://msdn.microsoft.com/en-us/library/vstudio/bb534966%28v=vs.100%29.aspx[^]

Regards,
Santosh

Posted 14-Jan-15 22:48pm

santosh.yadav198613

Updated 14-Jan-15 22:49pm

v2

Comments

george4986 15-Jan-15 5:00am

I will check the link.thanks for ur effort.use improve solution option & plz dont post multiple answer threads.

santosh.yadav198613 15-Jan-15 6:01am

oops sorry did it by mistake.

CHill60 15-Jan-15 5:01am

Dataset doesn't implement IEnumerable - I don't think Linq will work in this instance

santosh.yadav198613 15-Jan-15 5:58am

system.data.datasetextensions use this dll into your dataaccesslayer to support IEnumerable.

CHill60 15-Jan-15 6:39am

I can only see how that would work on the tables themselves not the dataset. Could you provide an example of how you would get it to work?

santosh.yadav198613 15-Jan-15 6:57am

Below is the sample code , and you are right you need to get datatable.
using (SqlClient sa = new SqlClient(constring))
{
op = sa.GetDataTable(new StringBuilder("[dbo].[usp_GetData]"), CommandType.StoredProcedure);

if (op.Success && op.Data != null)
{
banksList = (from b in op.Data.AsEnumerable()
select new EBank
{
BankName = (b.Field<string>("Key"),
ProgramId = b.Field<int>("Value")
}).ToList();

}
}

CHill60 15-Jan-15 7:17am

Sorry - I meant an example with a DataSet ... like in the OPs question

santosh.yadav198613 15-Jan-15 7:55am

Please find the sample, the datasets contains the tables, you need to just define the index of datatable which you want to read.

using (SqlClient sa = new SqlClient(constring))
{
op = sa.GetDataSet(new StringBuilder("[dbo].[usp_getData]"), CommandType.StoredProcedure);

if (op.Success && op.Data != null)
{
banksList = (from b in op.Data.Tables[0].AsEnumerable()
select new EBank
{
BankName = (b.Field<string>("Key") ,
ProgramId = b.Field<int>("value")
}).ToList();

}
}

Let me know if any more help is required.

Solution 1

you can use below query:

select * from sys.tables

hope it will help.

Regards,
Santosh

Posted 14-Jan-15 18:27pm

santosh.yadav198613

Comments

george4986 15-Jan-15 4:37am

is it possible in front end? i know its possible in backend.
thanks for ur reply.

Solution 2

You need to use Sort option provide by Dataset. Check this links for samples.

http://stackoverflow.com/questions/15618682/sorting-dataset-in-asp-net-c-sharp[^]

http://stackoverflow.com/questions/11029823/dataset-sorting[^]

Posted 14-Jan-15 18:52pm

ArunRajendra

Comments

george4986 15-Jan-15 4:39am

i have checked ur links , i know its possible to filter/sort contents of tables in a dataset . but my requirement is ordering tablenames in dataset.hope its clear to u.thanks for the effort.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2015-01-14T23:27:00

Based on your responses to the other comments and solutions I think this might do what you need ...

My "sample data":

C#

DataSet ds = new DataSet();
ds.Tables.Add("aTable");
ds.Tables.Add("cTable");
ds.Tables.Add("bTable");

I use CopyTo to get the tables within the dataset into an array - on which I can then use Linq

C#

DataTable[] dta = new DataTable[ds.Tables.Count];
ds.Tables.CopyTo(dta, 0);

Here's the actual sort

C#

foreach (DataTable t in dta.OrderBy(c => c.TableName))
      Console.WriteLine(t.TableName);

which gives me the output

aTable
bTable
cTable

as expected

Edit - Forgot to mention to ensure you have included

using System.Linq;

Order by tables with table name ascending on Dataset

4 solutions

Solution 4

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us