find datatable in dataset by name(pattern name not exact name)

Question

0.00/5 (No votes)

See more:

i want to find a datatable in a dataset when exact name is unknown.
i cannot use DataTable abc = set["xyz"]; or xyz[0].

DataTable sweepon = Set.Tables.Contains("sweep-on$");
passtosomemethod(sweepon, true);

Posted 3-Aug-12 5:17am

Gufran_khan

Add a Solution

4 solutions

Solution 1

Can you check that you have spelld it right with this code:

C#

private void GetTableNames(DataSet dataSet)
{
    // Print each table's TableName.
    foreach(DataTable table in dataSet.Tables)
    {
        Console.WriteLine(table.TableName);
    }
}

WIth the code above you can find the ecxact name that contains your input, so all youll have to do is designa a string function :)

Posted 3-Aug-12 5:42am

Kenneth Haugland

Updated 3-Aug-12 6:05am

v2

Solution 2

foreach(DataTable table in dataSet.Tables)
{
if(table.TableName=="tableName")
{
//do something
}

}

Posted 7-Aug-12 2:08am

Member 8647314

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)

_Amy · Accepted Answer · 2012-08-07T02:16:00

Hi,
Try this:

C#

//ds is your dataset object
foreach (DataTable dt in ds.Tables) {
    //Searching for the table whose name contains "sweep"
    if (dt.TableName.Contains("sweep")) 
    {
        //Console.WriteLine(dt.TableName);
        // do your work here. you found your table name
        passtosomemethod(dt.TableName, true); 
    }
}

--Amit

Santhosh Kumar Jayaraman · Accepted Answer · 2012-08-07T02:16:00

Solution 4

C#

private void GetTableNames(DataSet dataSet)
{

string datatablepartialName="xyz";
    // Print each table's TableName.
    foreach(DataTable table in dataSet.Tables)
    {
        If(table.TableName.Contains(datatablepartialName))
{
//then do something
}

    }
}

Posted 7-Aug-12 2:16am

Santhosh Kumar Jayaraman