本文整理汇总了C#中MySqlDataAdapter.FillSchema方法的典型用法代码示例。如果您正苦于以下问题:C# MySqlDataAdapter.FillSchema方法的具体用法?C# MySqlDataAdapter.FillSchema怎么用?C# MySqlDataAdapter.FillSchema使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类MySqlDataAdapter
的用法示例。
在下文中一共展示了MySqlDataAdapter.FillSchema方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SemicolonAtEndOfSQL
public void SemicolonAtEndOfSQL()
{
execSQL("CREATE TABLE Test (id INT NOT NULL, name VARCHAR(100), PRIMARY KEY(id))");
execSQL("INSERT INTO Test VALUES(1, 'Data')");
DataSet ds = new DataSet();
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM `Test`;", conn);
da.FillSchema(ds, SchemaType.Source, "Test");
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
dt.Rows[0]["id"] = 2;
da.Update(dt);
dt.Clear();
da.Fill(dt);
cb.Dispose();
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual(2, dt.Rows[0]["id"]);
}
示例2: GetCharLengthInUTF8
public void GetCharLengthInUTF8()
{
execSQL(
@"CREATE TABLE `t62094` ( `id` int(11) NOT NULL, `name` char(1) DEFAULT NULL,
`longname` char(20) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
MySqlCommand cmd = new MySqlCommand("select * from t62094", conn);
MySqlDataAdapter ad = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
ad.FillSchema(ds, SchemaType.Mapped);
Assert.AreEqual(1, ds.Tables[0].Columns["name"].MaxLength);
Assert.AreEqual(20, ds.Tables[0].Columns["longname"].MaxLength);
}
示例3: GetSchema2
public void GetSchema2()
{
if (Version.Major < 5) return;
execSQL(@"CREATE TABLE Test(id INT AUTO_INCREMENT, PRIMARY KEY (id)) ");
execSQL(@"CREATE PROCEDURE spTest (OUT id INT)
BEGIN INSERT INTO Test VALUES (NULL); SET id=520; END");
MySqlCommand cmd = new MySqlCommand("spTest", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("?id", MySqlDbType.Int32);
cmd.Parameters[0].Direction = ParameterDirection.Output;
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataTable dt = new DataTable();
if (prepare) cmd.Prepare();
cmd.ExecuteNonQuery();
da.Fill(dt);
da.FillSchema(dt, SchemaType.Mapped);
}
示例4: GetSchema
public void GetSchema()
{
if (Version < new Version(5, 0)) return;
execSQL("CREATE PROCEDURE spTest() BEGIN SELECT * FROM Test; END");
execSQL(@"CREATE TABLE Test(id INT AUTO_INCREMENT, name VARCHAR(20), PRIMARY KEY (id)) ");
MySqlCommand cmd = new MySqlCommand("spTest", conn);
cmd.CommandType = CommandType.StoredProcedure;
MySqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly);
reader.Read();
reader.Close();
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataTable schema = new DataTable();
da.FillSchema(schema, SchemaType.Source);
Assert.AreEqual(2, schema.Columns.Count);
}