OleDbConnection oleConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + @"\MIEDataBase.mdb");
oleConn.Open();
OleDbCommand AICmd = new OleDbCommand();
AICmd.Connection = oleConn;
OleDbDataAdapter AIOleDbDataAdapter = new OleDbDataAdapter();
AIOleDbDataAdapter.SelectCommand = AICmd;
DataSet AIDataSet = new DataSet();
OleDbCommandBuilder AIOleDbCommandBuilder = new OleDbCommandBuilder(AIOleDbDataAdapter); AIOleDbDataAdapter.Fill(AIDataSet, AItableName); DataRow AIRow = AIDataSet.Tables[0].NewRow();
float AItimeOfEveryData = 0; for (int i = 0; i < countOfDataNeededToStore; i++)
{
AIRow["模拟量时间"] = Math.Round(AItimeOfEveryData, 5);
AIRow["MP1"] = Math.Round((float)mcMP1arrayy[i], 2);
AIRow["MP2"] = Math.Round((float)mcMP2arrayy[i], 2);
AIRow["MP3"] = Math.Round((float)mcMP3arrayy[i], 2);
AIRow["MP4"] = Math.Round((float)mcMP4arrayy[i], 2);
AIRow["MP5"] = Math.Round((float)mcMP5arrayy[i], 2);
AIRow["MP6"] = Math.Round((float)mcMP6arrayy[i], 2);
AIRow["MP7"] = Math.Round((float)mcMP7arrayy[i], 2);
AIRow["MP8"] = Math.Round((float)mcMP8arrayy[i], 2);
AIRow["MP9"] = Math.Round((float)mcMP9arrayy[i], 2);
AIRow["MP10"] = Math.Round((float)mcMP10arrayy[i], 2);
AIRow["MP11"] = Math.Round((float)mcMP11arrayy[i], 2);
AIRow["MP12"] = Math.Round((float)mcMP12arrayy[i], 2);
AIRow["MP13"] = Math.Round((float)mcMP13arrayy[i], 2);
AIRow["MP14"] = Math.Round((float)mcMP14arrayy[i], 2);
AIRow["MP15"] = Math.Round((float)mcMP15arrayy[i], 2);
AIRow["CF1"] = Math.Round((float)mcCF1arrayy[i], 2);
AIRow["CF2"] = Math.Round((float)mcCF2arrayy[i], 2);
AIRow["JJY"] = Math.Round((float)mcJJYarrayy[i], 2);
AIDataSet.Tables[0].Rows.Add(AIRow); AItimeOfEveryData += AICaiYangZhouQi; } AIOleDbDataAdapter.Update(AIDataSet, AItableName);
AICmd.Dispose();
AIOleDbDataAdapter.Dispose();
执行这一句 AIOleDbDataAdapter.Fill(AIDataSet, AItableName);异常:没有为命令对象设置命令。 什么原因呀
oleConn.Open();
OleDbCommand AICmd = new OleDbCommand();
AICmd.Connection = oleConn;
OleDbDataAdapter AIOleDbDataAdapter = new OleDbDataAdapter();
AIOleDbDataAdapter.SelectCommand = AICmd;
DataSet AIDataSet = new DataSet();
OleDbCommandBuilder AIOleDbCommandBuilder = new OleDbCommandBuilder(AIOleDbDataAdapter); AIOleDbDataAdapter.Fill(AIDataSet, AItableName); DataRow AIRow = AIDataSet.Tables[0].NewRow();
float AItimeOfEveryData = 0; for (int i = 0; i < countOfDataNeededToStore; i++)
{
AIRow["模拟量时间"] = Math.Round(AItimeOfEveryData, 5);
AIRow["MP1"] = Math.Round((float)mcMP1arrayy[i], 2);
AIRow["MP2"] = Math.Round((float)mcMP2arrayy[i], 2);
AIRow["MP3"] = Math.Round((float)mcMP3arrayy[i], 2);
AIRow["MP4"] = Math.Round((float)mcMP4arrayy[i], 2);
AIRow["MP5"] = Math.Round((float)mcMP5arrayy[i], 2);
AIRow["MP6"] = Math.Round((float)mcMP6arrayy[i], 2);
AIRow["MP7"] = Math.Round((float)mcMP7arrayy[i], 2);
AIRow["MP8"] = Math.Round((float)mcMP8arrayy[i], 2);
AIRow["MP9"] = Math.Round((float)mcMP9arrayy[i], 2);
AIRow["MP10"] = Math.Round((float)mcMP10arrayy[i], 2);
AIRow["MP11"] = Math.Round((float)mcMP11arrayy[i], 2);
AIRow["MP12"] = Math.Round((float)mcMP12arrayy[i], 2);
AIRow["MP13"] = Math.Round((float)mcMP13arrayy[i], 2);
AIRow["MP14"] = Math.Round((float)mcMP14arrayy[i], 2);
AIRow["MP15"] = Math.Round((float)mcMP15arrayy[i], 2);
AIRow["CF1"] = Math.Round((float)mcCF1arrayy[i], 2);
AIRow["CF2"] = Math.Round((float)mcCF2arrayy[i], 2);
AIRow["JJY"] = Math.Round((float)mcJJYarrayy[i], 2);
AIDataSet.Tables[0].Rows.Add(AIRow); AItimeOfEveryData += AICaiYangZhouQi; } AIOleDbDataAdapter.Update(AIDataSet, AItableName);
AICmd.Dispose();
AIOleDbDataAdapter.Dispose();
执行这一句 AIOleDbDataAdapter.Fill(AIDataSet, AItableName);异常:没有为命令对象设置命令。 什么原因呀
解决方案 »
- 主键与唯一索引
- 已经重写了类的GetHashCode()和Equals(),为什么做字典的键时依然无效?
- byte转为string 乱码
- 我用vs2005 + windows mobile 5.0 SDK 只能创建qqvga屏幕的应用程序,怎么才能创建QVGA屏的应用程序呢?
- C# 导出 word 表格如何设置标题行重复,我现在也想实现这个,知道说下
- [在线等高手解答]将dataGrid中选中的一条数据显示到richTextBox中
- 托盘程序闪动图标问题!
- c#.net數據庫連接的問題.
- codefirst创建MySQL数据库报错: Specified key was too long; max key length i
- 请问怎样可以在一条程序中实现延时?
- 数据库链接的问题
- 一个非常烦人的问题。例如想用.Checked=true让程序选中选项钮,却在暗中自动激发了它的CheckedChanged事件。类似的问题,在一个有5万行以上的代码中如何去发现它呢?难道要经常一句一句
AICmd.Connection = oleConn;
AIOleDbDataAdapter.SelectCommand = AICmd;这三句话注析掉看看行不行!