Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DataTable t = _conn.GetSchema("Tables");
- public IList<string> ListTables()
- {
- List<string> tables = new List<string>();
- DataTable dt = _connection.GetSchema("Tables");
- foreach (DataRow row in dt.Rows)
- {
- string tablename = (string)row[2];
- tables.Add(tablename);
- }
- return tables;
- }
- SELECT name FROM sysobjects WHERE xtype = 'U'
- System.Data.SqlClient.SqlConnection SqlCon = new System.Data.SqlClient.SqlConnection("server=192.168.0.1;uid=sa;pwd=1234");
- SqlCon.Open();
- System.Data.SqlClient.SqlCommand SqlCom = new System.Data.SqlClient.SqlCommand();
- SqlCom.Connection = SqlCon;
- SqlCom.CommandType = CommandType.StoredProcedure;
- SqlCom.CommandText = "sp_databases";
- System.Data.SqlClient.SqlDataReader SqlDR;
- SqlDR = SqlCom.ExecuteReader();
- while(SqlDR.Read())
- {
- MessageBox.Show(SqlDR.GetString(0));
- }
- string[] GetAllTables(SqlConnection connection)
- {
- List<string> result = new List<string>();
- SqlCommand cmd = new SqlCommand("SELECT name FROM sys.Tables", connection);
- System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
- while(reader.Read())
- result.Add(reader["name"].ToString());
- return result.ToArray();
- }
- public static List<string> GetTableNames(this SqlConnection connection)
- {
- using(SqlConnection conn = connection)
- {
- if(conn.State == ConnectionState.Open)
- {
- return conn.GetSchema("Tables").AsEnumerable().Select(s => s[2].ToString()).ToList();
- }
- }
- //Add some error-handling instead !
- return new List<string>();
- }
- private IEnumerable<string> getAllTables()
- {
- var sqlConnection = new System.Data.SqlClient.SqlConnection(connectionString);
- var serverConnection = new Microsoft.SqlServer.Management.Common.ServerConnection(sqlConnection);
- var server = new Microsoft.SqlServer.Management.Smo.Server(serverConnection);
- var database = server.Databases[databaseName];
- foreach (Microsoft.SqlServer.Management.Smo.Table table in database.Tables)
- {
- yield return table.Name;
- }
- }
- public System.Collections.Generic.Dictionary<string, string> GetAllTables(System.Data.SqlClient.SqlConnection _connection)
- {
- if (_connection.State == System.Data.ConnectionState.Closed)
- _connection.Open();
- System.Data.DataTable dt = _connection.GetSchema("Tables");
- System.Collections.Generic.Dictionary<string, string> tables = new System.Collections.Generic.Dictionary<string, string>();
- foreach (System.Data.DataRow row in dt.Rows)
- {
- if (row[3].ToString().Equals("BASE TABLE", StringComparison.OrdinalIgnoreCase)) //ignore views
- {
- string tableName = row[2].ToString();
- string schema = row[1].ToString();
- tables.Add(tableName, schema);
- }
- }
- _connection.Close();
- return tables;
- }
- <div>
- <asp:Button ID="GridViewTableListButton" runat="server" Text="List all Tables on server"
- onclick="GridViewTableListButton_Click" />
- <asp:GridView ID="GridViewTableList" runat="server">
- </asp:GridView>
- </div>
- protected void GridViewTableListButton_Click(object sender, EventArgs e)
- {
- objConn.Open();
- DataTable t = objConn.GetSchema("Tables");
- GridViewTableList.DataSource = t;
- GridViewTableList.DataBind();
- objConn.Close();
- }
- using System.Data;
- SqlConnection objConn = new SqlConnection();
- objConn.ConnectionString = ConfigurationManager.ConnectionStrings[connString].ConnectionString;
- public class connectionClass
- {
- .....
- public string connClass()
- {
- connString = "LocalSqlServer"; // LOCAL home PC Version
- }
- }
- <add name="LocalSqlServer" connectionString="Data Source=MyPCsNameSQLEXPRESS;Initial Catalog=databasename;Integrated Security=True" providerName="System.Data.SqlClient"/>
Add Comment
Please, Sign In to add comment