操作sqlite

static string connStr = "Data Source=d:test.db";
        static void Main(string[] args) {
            SQLiteConnection conn = new SQLiteConnection(connStr);
            SQLiteCommand cmd = conn.CreateCommand();
            string sql = "select * from admin";
            conn.Open();
            cmd.CommandText = sql;
            IDataReader dr = cmd.ExecuteReader();
            //输出列名,FieldCount 是列长度
            for (int i = 0; i < dr.FieldCount; ++i)
                Console.Write(dr.GetName(i) + "t");
            Console.WriteLine();
            //输出一行,先read
            while (dr.Read()) {
                Console.Out.WriteLine(dr.GetString(0) + "t" + dr.GetString(1));
            }
            Console.Read();

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!