两个资料库内,如何资料表互相查询?

Question

user.mdf内UserA资料表的getno相等于
detail.mdf的乱码资料表。当我查询user.mdf资料时(例如UserA) ,
从UserA资料表得到getno乱码,
从而显示detail.mdf的乱码资料表內 detail 资料 。有没有人明白我的思路?
这样设计复杂吗?　　　　　　

Answer 1

UserA中的id与tl20090217214905169中的id是否對應?

Answer 2

UserA 中的 getno 与 tl20090217214905169 是對應

Answer 3

declare @tl varchar(50)
select @tl= [getno] from [user].[dbo].[UserA] where id=你要查詢嘅id
declare @sql varchar(500)
set @sql='select * from [detail].[dbo].' + @tl 
exec (@sql)
試下，唔知啱唔啱

Answer 4

這樣???
            string connString = WebConfigurationManager.ConnectionStrings["DataString"].ConnectionString;
            SqlConnection conn = new SqlConnection(connString);
            conn.Open();SqlCommand cmd = new SqlCommand("declare @tl varchar(50)
select @tl= [getno] from [user].[dbo].[UserA] where id='" + temp_getno + "'
declare @sql varchar(500)
set @sql='select * from [detail].[dbo].' + @tl 
exec (@sql)
", conn);            SqlDataReader dr = cmd.ExecuteReader();
            GridView1.DataSource = dr;
            GridView1.DataBind();
            dr.Close();
            conn.Close();

Answer 5

            string connString = WebConfigurationManager.ConnectionStrings["DataString"].ConnectionString;
            string connString2 = WebConfigurationManager.ConnectionStrings["Data2String"].ConnectionString;
如何兩者連線？？？??

Answer 6

temp_getno  從UserA中get_no 取的 tl20090217214905169

Answer 7

既然已经有了这个值那就直接这样就可以了:
            string connString = WebConfigurationManager.ConnectionStrings["DataString"].ConnectionString;
            SqlConnection conn = new SqlConnection(connString);
            conn.Open();SqlCommand cmd = new SqlCommand("select * from [detail].[dbo].["+temp_getno+"]");            SqlDataReader dr = cmd.ExecuteReader();
            GridView1.DataSource = dr;
            GridView1.DataBind();
            dr.Close();
            conn.Close();

Answer 8

多謝會員 ojlovecd            #region 两个资料库内,如何资料表互相查询            MembershipUser singleUser = Membership.GetUser();            string connString1 = WebConfigurationManager.ConnectionStrings["1String"].ConnectionString;
            SqlConnection conn1 = new SqlConnection(connString1);
            conn1.Open();
            SqlCommand cmd1 = new SqlCommand("select getno from " + singleUser.UserName, conn1);
            object obj = cmd1.ExecuteScalar();
            conn1.Close();
            string getno = string.Empty;
            if (obj != null)
            {
                getno = obj.ToString();
                string connString2 = WebConfigurationManager.ConnectionStrings["2String"].ConnectionString;
                SqlConnection conn2 = new SqlConnection(connString2);
                conn2.Open();                SqlCommand cmd2 = new SqlCommand("select * from " + getno, conn2);
                SqlDataReader dr2 = cmd2.ExecuteReader();
                GridView2.DataSource = dr2;
                GridView2.DataBind();
                dr2.Close();
                conn2.Close();
            }
            else
            {
                errormessage.Text = "没有内容 ! ";
                return;
            }            #endregion
但假如有十笔资料, getno只有头一笔资料,如何解决??