摘要：
private void button1_Click(object sender, EventArgs e) { // this.bindingSource1.DataSource = Bmk.FindAll(); this.bindingSource1.DataSource = OleDbHelper.ExecuteDataTable(Conn.AccessConnection, @"select * from bmk order by bmxh "); this.dataGridView1.DataSource = bindingSource1; this.label1 阅读全文
摘要：
System.Data.SQLite .net4.0You have to add a section to your .config file to be able to load the 2.0 assembly in 4.0. I won't have a 4.0-built assembly out for a bit yet.<?xml version="1.0" encoding="utf-8" ?><configuration> <startup useLegacyV2RuntimeActivation 阅读全文
摘要：
stringstrSql="insertintotest_table"+"(zdsxh,zdsbm,mc,fzrbh,bxrbh,bxrq,sjfrom,sjto)values"+"(@zdsxh,@zdsbm,@mc,@fzrbh,@bxrbh,@bxrq,@sjfrom,@sjto)";将strSql替换成stringstrSql="insertintotest_table"+"(zdsxh,zdsbm,mc,fzrbh,bxrbh,bxrq,sjfrom,sjto)values"+&quo 阅读全文
摘要：
http://blog.sina.com.cn/s/blog_54b576bb0100anku.html在使用access数据时，经常使用string strSql="insert table_name(col1,col2,...,coln) values(@col1,@col2,...,@coln)";来向数据库插入数据，写法居然是有毛病的，参照msdn,应该改为string strSql="insert table_name(col1,col2,...,coln) values(?,?,...,?)";来自msdn的解释：如果 CommandType 阅读全文