how to read from multiple sql tables (knowing only the column names and not table names) c#

See more:

C#

C#4.0

SQL-Server-2014

Hi all,

So here i am asking a question once again! Okay so my question is how do i read data from multiple sql tables if i only know the column names. EG.

eqcas database

[User Info] - cas_user_ext - eqcas
Email adress - "email"
Full Name - "fullname"

[User Pin] - cat_validation - eqcas
Name - "name"
Primary Pin - "primarypin"
Secondary Pin - "secondarypin"

cas_user_ext (table)
cat_validation (table)

"text" (the column names)

    public EQData()
    {
        SQLConnect sqlcon = new SQLConnect();
        SqlDataReader myReader = null;
        //SqlCommand myCommand = new SqlCommand("select x_id, fullname, email FROM cas_user_ext WHERE fullname = @fullname",
                                                                                //sqlcon.Connection);
        SqlCommand myCommand = new SqlCommand("select x_id, fullname, email, name, primarypin, secondarypin FROM cas_user_ext, cat_validation WHERE name = @name",
                                                                    sqlcon.Connection);
        myCommand.Parameters.AddWithValue("@name", "ivan1");
        myReader = myCommand.ExecuteReader();
        while (myReader.Read())
        {
            x_id = myReader["x_id"].ToString();
            fullname = myReader["fullname"].ToString();
            email = myReader["email"].ToString();
            name = myReader["name"].ToString();
            primarypin = myReader["primarypin"].ToString();
            secondarypin = myReader["secondarypin"].ToString();
        }
        sqlcon.Close();
    }
}

and also i'm using a class to get the info (the above is part of my class)



So lets say i want to retrieve data from from both tables for all the columns, but the only info i have is the users "name". How would i achieve that?

When i run my application i am retrieving the correct information for cas_user_ext table but not for cat_validation, cat_validation retrieve a different users information.

Thanks in advance