C# (CSharp) MySql.Data.MySqlClient SchemaProvider.FillTable示例

FillTable() protected static method

protected static FillTable ( DataTable dt, object data ) : void
dt	System.Data.DataTable
data	object
return	void

示例#1

        protected override MySqlSchemaCollection GetCollections()
        {
            MySqlSchemaCollection collections = base.GetCollections();

            object[][] data = new object[][]
            {
                new object[]
                {
                    "Views",
                    2,
                    3
                },
                new object[]
                {
                    "ViewColumns",
                    3,
                    4
                },
                new object[]
                {
                    "Procedure Parameters",
                    5,
                    1
                },
                new object[]
                {
                    "Procedures",
                    4,
                    3
                },
                new object[]
                {
                    "Triggers",
                    2,
                    4
                }
            };
            SchemaProvider.FillTable(collections, data);
            return(collections);
        }

示例#2

        protected override MySqlSchemaCollection GetRestrictions()
        {
            MySqlSchemaCollection restrictions = base.GetRestrictions();

            object[][] data = new object[][]
            {
                new object[]
                {
                    "Procedure Parameters",
                    "Database",
                    "",
                    0
                },
                new object[]
                {
                    "Procedure Parameters",
                    "Schema",
                    "",
                    1
                },
                new object[]
                {
                    "Procedure Parameters",
                    "Name",
                    "",
                    2
                },
                new object[]
                {
                    "Procedure Parameters",
                    "Type",
                    "",
                    3
                },
                new object[]
                {
                    "Procedure Parameters",
                    "Parameter",
                    "",
                    4
                },
                new object[]
                {
                    "Procedures",
                    "Database",
                    "",
                    0
                },
                new object[]
                {
                    "Procedures",
                    "Schema",
                    "",
                    1
                },
                new object[]
                {
                    "Procedures",
                    "Name",
                    "",
                    2
                },
                new object[]
                {
                    "Procedures",
                    "Type",
                    "",
                    3
                },
                new object[]
                {
                    "Views",
                    "Database",
                    "",
                    0
                },
                new object[]
                {
                    "Views",
                    "Schema",
                    "",
                    1
                },
                new object[]
                {
                    "Views",
                    "Table",
                    "",
                    2
                },
                new object[]
                {
                    "ViewColumns",
                    "Database",
                    "",
                    0
                },
                new object[]
                {
                    "ViewColumns",
                    "Schema",
                    "",
                    1
                },
                new object[]
                {
                    "ViewColumns",
                    "Table",
                    "",
                    2
                },
                new object[]
                {
                    "ViewColumns",
                    "Column",
                    "",
                    3
                },
                new object[]
                {
                    "Triggers",
                    "Database",
                    "",
                    0
                },
                new object[]
                {
                    "Triggers",
                    "Schema",
                    "",
                    1
                },
                new object[]
                {
                    "Triggers",
                    "Name",
                    "",
                    2
                },
                new object[]
                {
                    "Triggers",
                    "EventObjectTable",
                    "",
                    3
                }
            };
            SchemaProvider.FillTable(restrictions, data);
            return(restrictions);
        }