 | | From: | =?Utf-8?B?5b+D5LiN5YaN5rWB5rOq?= | | Subject: | =?Utf-8?B?5Li65LuA5LmI55u45ZCM55qE5Luj56CB5Zyod2luZG93c+W6lOeUqOeoiw==?= | | Date: | Thu, 9 Dec 2004 03:53:04 -0800 |
|
|
 | 涓嬮潰杩欐浠ｇ爜鍦╳indows搴旂敤绋嬪簭涓嬪彲浠ヨ皟璇曢氳繃锛岃屽湪asp.net鐜涓嬬己鎶ラ敊锛岃鈥滄搷浣滃繀椤讳娇鐢ㄤ竴涓彲鏇存柊鐨勬煡璇⑩濓紝骞朵笖閿欒鍙戠敓鍦ㄦ渶鍚庝竴鍙ワ紝涔嬪墠鐨勯兘姝ｇ‘銆
鍝綅鑳藉府蹇欑湅涓涓嬪晩銆傝阿
OleDbConnection oConnection=new OleDbConnection();
string oConnectionString;
DataSet oDataSet=new DataSet();
OleDbDataAdapter oOleDbAdapter=new OleDbDataAdapter();
string DataBaseFile=@"E:\test\test.mdb";
oConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="+DataBaseFile;
oConnection.ConnectionString=oConnectionString;
oConnection.Open();
OleDbCommand oSelectCommand=new OleDbCommand();
oSelectCommand.CommandText="SELECT * FROM information";
oSelectCommand.Connection=oConnection;
OleDbCommand oInsertCommand=new OleDbCommand();
oInsertCommand.CommandText="INSERT INTO information
VALUES(?,?,?)";
oInsertCommand.Connection=oConnection;
OleDbParameterCollection
oInsertParameters=oInsertCommand.Parameters;
OleDbParameter oInsertParameter1=oInsertCommand.CreateParameter();
oInsertParameter1.SourceColumn="name";
OleDbParameter oInsertParameter2=oInsertCommand.CreateParameter();
oInsertParameter2.SourceColumn="age";
OleDbParameter oInsertParameter3=oInsertCommand.CreateParameter();
oInsertParameter3.SourceColumn="";
oInsertParameters.Add(oInsertParameter1);
oInsertParameters.Add(oInsertParameter2);
oInsertParameters.Add(oInsertParameter3);
oOleDbAdapter.SelectCommand=oSelectCommand;
oOleDbAdapter.InsertCommand=oInsertCommand;
oOleDbAdapter.Fill(oDataSet);
MessageBox.Show(oDataSet.Tables[0].Rows.Count.ToString());
DataRow oDataRow=oDataSet.Tables[0].NewRow();
oDataRow["name"]="dd";
oDataRow["age"]="dds";
oDataRow[""]="sdfs";
oDataSet.Tables[0].Rows.Add(oDataRow);
MessageBox.Show(oDataSet.Tables[0].Rows.Count.ToString());
oOleDbAdapter.Update(oDataSet);
|
|
| | From: | AOWT | | Subject: | Re: 为什么相同的代码在windows应用程序跟asp.net运行结果不一样呢 | | Date: | Wed, 5 Jan 2005 12:36:26 +0800 |
|
|
| 权限的问题
"心不再流泪" <@discussions.microsoft.com> wrote in message
news:741BBFD2-D4DC-4AB9-B851-96FE087D7296@microsoft.com...
> 下面这段代码在windows应用程序下可以调试通过，而在asp.net环境下缺报错，说“操作必须使用一个可更新的查询”，并且错误发生在最后一句，之前的都正确。
> 哪位能帮忙看一下啊。谢
> OleDbConnection oConnection=new OleDbConnection();
> string oConnectionString;
> DataSet oDataSet=new DataSet();
> OleDbDataAdapter oOleDbAdapter=new OleDbDataAdapter();
> string DataBaseFile=@"E:\test\test.mdb";
> oConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source="+DataBaseFile;
> oConnection.ConnectionString=oConnectionString;
> oConnection.Open();
>
> OleDbCommand oSelectCommand=new OleDbCommand();
> oSelectCommand.CommandText="SELECT * FROM information";
> oSelectCommand.Connection=oConnection;
>
> OleDbCommand oInsertCommand=new OleDbCommand();
> oInsertCommand.CommandText="INSERT INTO information
> VALUES(?,?,?)";
> oInsertCommand.Connection=oConnection;
> OleDbParameterCollection
> oInsertParameters=oInsertCommand.Parameters;
> OleDbParameter
> oInsertParameter1=oInsertCommand.CreateParameter();
> oInsertParameter1.SourceColumn="name";
> OleDbParameter
> oInsertParameter2=oInsertCommand.CreateParameter();
> oInsertParameter2.SourceColumn="age";
> OleDbParameter
> oInsertParameter3=oInsertCommand.CreateParameter();
> oInsertParameter3.SourceColumn="";
>
> oInsertParameters.Add(oInsertParameter1);
> oInsertParameters.Add(oInsertParameter2);
> oInsertParameters.Add(oInsertParameter3);
>
> oOleDbAdapter.SelectCommand=oSelectCommand;
> oOleDbAdapter.InsertCommand=oInsertCommand;
>
>
> oOleDbAdapter.Fill(oDataSet);
> MessageBox.Show(oDataSet.Tables[0].Rows.Count.ToString());
>
>
>
> DataRow oDataRow=oDataSet.Tables[0].NewRow();
> oDataRow["name"]="dd";
> oDataRow["age"]="dds";
> oDataRow[""]="sdfs";
> oDataSet.Tables[0].Rows.Add(oDataRow);
> MessageBox.Show(oDataSet.Tables[0].Rows.Count.ToString());
>
> oOleDbAdapter.Update(oDataSet);
>
|
|
| | From: | 杨云 | | Subject: | Re: 为什么相同的代码在windows应用程序跟asp.net运行结果不一样呢 | | Date: | Fri, 10 Dec 2004 12:03:23 +0800 |
|
|
| 一般是SQL语句的问题,换一个形式试试
--
--
微软社区ASP.NET,C#,ADO.NET组组长之一!
愿我们共同进步!
|
|
