- /*列出局域网中所有数据库的电脑名称*/
- private void button1_Click(object sender, EventArgs e)
- {
- SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
- DataTable dt = instance.GetDataSources();
- DisplayData(dt);
- }
- private void DisplayData(System.Data.DataTable table)
- {
- foreach (System.Data.DataRow row in table.Rows)
- {
- //RichTextB
- richTextBox1.Text+=String.Format("服务器名 = {0} /t", row["ServerName"]);
- richTextBox1.Text+=String.Format("实例名 = {0}/t", row["InstanceName"]);
- richTextBox1.Text+=String.Format("是否集成验证 = {0}/t", row["IsClustered"]);//即Windows身份验证和SQL Server验证
- richTextBox1.Text += String.Format("版本 = {0} /t", row["Version"]);//8.*是SQL 2000,9.*是SQL 2005
- richTextBox1.Text += String.Format("/r/n");
- }
- }
- /*选择所有表名*/
- SELECT * FROM sysobjects WHERE xtype='U'
- U = User table
- /*
- xtype char(2) Object type. Can be one of these object types:
- C = CHECK constraint
- D = Default or DEFAULT constraint
- F = FOREIGN KEY constraint
- L = Log
- FN = Scalar function
- IF = Inlined table-function
- P = Stored procedure
- PK = PRIMARY KEY constraint (type is K)
- RF = Replication filter stored procedure
- S = System table
- TF = Table function
- TR = Trigger
- U = User table
- UQ = UNIQUE constraint (type is K)
- V = View
- X = Extended stored procedure
- */