在开发一个T6导入工具的过程中遇到了几个combobox绑定数据源的问题:
- 获取所有数据库名称,通过下拉框选择
using (System.Data.SqlClient.SqlConnection Conn = new System.Data.SqlClient.SqlConnection(connString)) {
//初始化,comboBox5绑定帐套名称
string Sql = "SELECT Name FROM Master..SysDatabases where name like 'ufdata%' ORDER BY Name";
DataSet Ds = new DataSet();
SqlDataAdapter Da = new SqlDataAdapter(Sql, Conn);
Da.Fill(Ds, "databases");
comboBox5.DataSource = Ds.Tables["databases"];
comboBox5.DisplayMember = "Name";
comboBox1.ValueMember = "Name";
}