Пример #1
0
        public DataTable GetTables()
        {
            //string[] restriction = new string[4];
            //restriction[1] = "dbo";
            //var conn = sqlhelper.GetConnection();
            //DataTable dt = conn.GetSchema("Tables", restriction);
            //conn.Close();

            var myconn = mysqlhelper.GetConnection();
            //DataTable dt = myconn.GetSchema("Tables", restriction);

            var dt = myconn.GetSchema("Tables");

            //myconn.GetSchema( "Restrictions" )
            foreach (System.Data.DataRow row in dt.Rows)
            {
                this.cmbTables.Items.Add(row["TABLE_NAME"]);//row[1]
            }

            this.cmbTables.SelectedIndex = 0;
            return(dt);
        }