用vs2008 VB检测MySQL字段填零

Question

使用。net连接器:http://dev.mysql.com/doc/refman/5.1/en/connector-net-ref.html

一个字段在MySQL中设置为:

decimal(6) zerofill not null

如何在VB中检测"零填充"标志?

Answer 1

您可以使用SHOW COLUMNS IN tablename获取列信息，该查询返回的内容形式为:

field         type                          null   key   default    extra
fieldname     int(10) unsigned zerofill      no            0    

所以要获得标志zerofill，你必须查看类型，如果int返回的字符串包含'zerofill'字符串:

这样就可以了:

static void Main(string[] args)
{
    dim conn as MySqlConnection
    conn = new MySqlConnection
    conn.ConnectionString = "Server = yourserver; Database = yourdb; Uid = youruser;Pwd = yourpassword;"
    conn.Open
    MySqlCommand cmd = new MySqlCommand
    cmd.Connection = conn
    cmd.CommandText = "SHOW COLUMNS IN yourtable"
    cmd.CommandType = CommandType.Text
    dim reader as MySqlDataReader
    reader = cmd.ExecuteReader
    while reader.Read
        Console.WriteLine("Field:{0}, zerofill:{1}",reader("field"),if(reader("type").ToString().Contains("zerofill"),true,false))
    end while
    conn.Close()
}