티스토리 뷰

정보 보관 ver1.0

Table Mapping in ADO.NET

James Wetzel 2011. 6. 16. 18:18

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());

728x90
반응형