asp.net (C#)DropDownList从不同数据库进行数据绑定

开发使用了master 以及工厂架构  代码没有我没有再重写  后台代码只留了个  绑定代码  主要是看个思路

前台页面

<%@ Page Language="C#" MasterPageFile="~/Consortium/MasterPage.master" AutoEventWireup="true" CodeFile="ConDuty_Add.aspx.cs" Inherits="Consortium_ConDuty_Add" Title="Untitled Page" %>
<%@ Register Src="ConMenu.ascx" TagName="ConMenu" TagPrefix="men" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<men:ConMenu ID="ConMenu1" runat="server" /> 
<div id="SpacesMiddle" style="left: 330px; top: 101px">
    <div id="Whatever">
    <ul class="TabBarLevel1" id="TabPage1">
                <li id="Tab1"><a href="Manage_Consortium.aspx">基本信息</a></li><li id="Tab2" >
                    <a href="News_Add.aspx" >发布新闻</a></li><li id="Tab3" >
                    <a href="Manage_ConDuty.aspx">管理职务</a></li><li id="Tab4" class="Selected">
                    <a href="ConDuty_Add.aspx">添加职务</a></li></ul>
                    <div class="HackBox" style="display: block">
                         <fieldset>
                        <legend>类别管理</legend>
                        <p>
                            <label for="author">
                               职务名称: <span class="required">(必填)</span></label>
                            <asp:TextBox ID="txtSortName" runat="server"></asp:TextBox>
                            <asp:DropDownList ID="dstConUser" runat="server">
                            </asp:DropDownList></p>
                        <p>

                               <asp:Button ID="btnSave" runat="server" Text="保存信息" CssClass="ButtonCss" OnClick="btnSave_Click" />
                        </p>
                         </fieldset>              
                     </div>
                    </div>
                    </div>
</asp:Content>

 

后台代码页

 using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Consortium_ConDuty_Add : System.Web.UI.Page
{
    public string ConId = String.Empty;
    protected void Page_Load(object sender, EventArgs e)
    {
        ConUserData();
    }

    protected void ConUserData()
    {
        SchoolShop.Common.Common com = new SchoolShop.Common.Common();
        DataSet ds = new DataSet();
        DataSet ds1 = null;
        ds = com.GetList(SchoolShop.DBUtility.MsSql.ConnectionStringSpaces, "ConUser", "ConId='" + ConId + "'");
        ds.Tables[0].Columns.Add(new DataColumn("TrueName",typeof(string)));
        for( int i=0;i<ds.Tables[0].Rows.Count;i++)
        {
        ds1 = com.GetList(SchoolShop.DBUtility.MsSql.ConnectionStringSchoolShop, "UserInfo", "UserId='" + ds.Tables[0].Rows[i]["UserId"].ToString() + "'");
        ds.Tables[0].Rows[i]["TrueName"] = ds1.Tables[0].Rows[0]["TrueName"];
        }
        dstConUser.DataSource = ds.Tables[0].DefaultView;
        dstConUser.DataTextField = "TrueName";
        dstConUser.DataValueField = "UserId";
        dstConUser.DataBind();
    }
}