/// <summary>         /// 获得目标服务器所有数据库名         /// </summary>         /// <param name="serverName"></param>         /// <param name="userName"></param>         /// <param name="password"></param>         public void getDataBaseNameList(string serverName, string userName, string password)         {             SQLDMO.Application sqlApplication = new SQLDMO.ApplicationClass();             SQLDMO.SQLServer sqlServer = new SQLDMO.SQLServerClass();             sqlServer.Connect(serverName, userName, password);          // 连接服务器             foreach (SQLDMO.Database databBase in sqlServer.Databases)             {                 if (databBase.Name != null)                 {                     this.DataBaseTreeView.Nodes.Add(databBase.Name);                     getDataBaseTableList(serverName, userName, password, databBase.Name);                 }             }         }         /// <summary>         /// 加载数据库中表         /// </summary>         /// <param name="serverName">服务器名</param>         /// <param name="userName">用户名</param>         /// <param name="password">密码</param>         /// <param name="dataBaseName">数据库名</param>         private void getDataBaseTableList(string serverName, string userName, string password, string dataBaseName)         {             SQLDMO.SQLServer Server = new SQLDMO.SQLServerClass();             //连接到服务器             Server.Connect(serverName, userName, password);             //对所有的数据库遍历，获得指定数据库             for (int i = 0; i < Server.Databases.Count; i++)             {                 //判断当前数据库是否是指定数据库                 if (Server.Databases.Item(i + 1, "dbo").Name == dataBaseName)                 {                     //获得指定数据库                     SQLDMO._Database db = Server.Databases.Item(i + 1, "dbo");                     //获得指定数据库中的所有表                     for (int j = 0; j < db.Tables.Count; j++)                     {                         this.DataBaseTreeView.Nodes[i].Nodes.Add(db.Tables.Item(j + 1, "dbo").Name);                     }                 }             }         }     /// <summary>         /// 获得表中所有列名         /// </summary>         /// <param name="serverName">服务器名</param>         /// <param name="userName">用户名</param>         /// <param name="password">密码</param>         /// <param name="tableName">表名</param>         /// <param name="dataBaseName">数据库名</param>         /// <returns></returns>         public string getRowListFromTable(string serverName, string userName, string password, string tableName, string dataBaseName)         {             string result = string.Empty;             string connectionString = string.Empty;             connectionString += "server=" + serverName;             connectionString += ";Pwd=" + password;             connectionString += ";UID=" + userName;             connectionString += ";Database=" + dataBaseName;             string commandString = string.Empty;             commandString += "select   name   from   syscolumns   where   id=object_id('";             commandString += tableName;             commandString += "')";                         SqlConnection sqlConnection = new SqlConnection(connectionString);             SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection);             SqlDataAdapter dataAdapter = new SqlDataAdapter(commandString, sqlConnection);             DataSet dataSet = new DataSet();             dataAdapter.Fill(dataSet);             DataTable dataTable = dataSet.Tables[0];             // DataTable dataTable = sqlConnection.GetSchema("Tables");             foreach (DataRow row in dataTable.Rows)             {                 result += row[0].ToString() + "-";             }             if (result != null)             {                 return result;              }             else             {                 return "0";             }         }