110,571
社区成员
发帖
与我相关
我的任务
分享
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "Insert into Caidan (Name,Cat,Price,Date) Values ('" + 内容1 + "','" + 内容2 + "','" + 内容3 + "','" + 内容4 + "')";
cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery();
/// <summary>
/// 填充数据表,原来的会被清空
/// </summary>
/// <param name="sqlSconn">执行语句:“select * form Tabel1 where 1 = 2”</param>
public virtual void DataFill(string sqlSconn)
{
this.myTable = new DataTable();
myAdapter=new OleDbDataAdapter(sqlSconn,dbconn);
OleDbCommandBuilder myBuilder=new OleDbCommandBuilder(myAdapter);
myAdapter.Fill(myTable);
this.s_baseConnSql = sqlSconn;
}
/// <summary>
/// 数据回写
/// </summary>
public void SaveChanges()
{
//myAdapter.Fill(this.Table);
myAdapter.Update(myTable);
myTable.AcceptChanges();
}