Table Mapping in ADO.NET
http://msdn.microsoft.com/en-us/library/ms810286.aspx
참조 소스]
MySqlConnection conn = new MySqlConnection("server=?.?.?.?;uid=???;pwd=????;database=???;");
conn.Open();
string query = "select * from tb_member_info limit 0,1; select * from member limit 0,1;";
MySqlCommand comm = new MySqlCommand(query, conn);
MySqlDataAdapter adapter = new MySqlDataAdapter(comm);
adapter.TableMappings.Add("Table", "tb_member_info_tt");
adapter.TableMappings.Add("Table1", "member_tt");
DataSet ds = new DataSet();
adapter.Fill(ds);
//ListView1.DataSource = ds.Tables["testTable"];
//ListView1.DataBind();
Response.Write(ds.Tables["tb_member_info_tt"].Rows[0]["rowID"].ToString());
Response.Write(ds.Tables["member_tt"].Rows[0][0].ToString());