连接到master库中,执行 select name from master..sysdatabases
SELECT Name FROM Master..SysDatabases ORDER BY Name 这是列出你登陆的那个实例下的所有数据库的名称! 至于绑定到下拉文本框中可以用c#操作数据库表一样!最后还是赋值!
use master select * from dbo.sysdatabases
DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("select name from master..sysdatabases", Conn); da.fill(dt); 绑定cmbox数据源为dt就行就行了。
这是列出你登陆的那个实例下的所有数据库的名称!
至于绑定到下拉文本框中可以用c#操作数据库表一样!最后还是赋值!
select * from dbo.sysdatabases
SqlDataAdapter da = new SqlDataAdapter("select name from master..sysdatabases", Conn);
da.fill(dt);
绑定cmbox数据源为dt就行就行了。
/// 获取局域网中SQL Server服务器的机器名
/// </summary>
/// <param name="cmb"></param>
public static void LoadSqlServerList(ComboBox cmb)
{
SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
DataTable dt = instance.GetDataSources();
cmb.DisplayMember = "ServerName";
cmb.ValueMember = "ServerName";
cmb.DataSource = dt;
cmb.SelectedIndex = -1;
}/// <summary>
/// 获取SQL Server数据库列表
/// </summary>
/// <param name="server">服务器地址</param>
/// <param name="user">登录用户名</param>
/// <param name="password">登录密码</param>
/// <returns>SQL服务器列表</returns>
public static List<string> GetDatabaseList(string server, string user, string password)
{
string sql = "Select [name] From Master..sysdatabases Where dbid >= 5 Order By [name]";
string connectionString = String.Format("Data Source={0};Initial Catalog={1};User Id={2};Password={3};", server, "Master", user, password);
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(sql, connectionString);
DataSet ds = new DataSet();
List<string> list = new List<string>();
try
{
da.Fill(ds, "DatabaseName");
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(dr[0].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show("取数据库名称出错,错误描述:" + ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
}
return list;
}
select name from dbo.sysdatabases
这个方法可以查询出数据库中所有的数据库名
string sql = "SELECT Name FROM Master..SysDatabases ORDER BY Name ";
DataTable dt = new DataTable ();
SqlConnection conn = new SqlConnection(connString);
conn.open();
SqlDataAdapter ada = new SqlDataAdapter(sql, conn);
ada.Fill(dt);
this.comboBox1.DisplayMember = "Name ";
this.comboBox1.ValueMember = "Name ";
this.comboBox1.DataSource =dt.DefaultView;