62,243
社区成员
发帖
与我相关
我的任务
分享插入数据问题！！
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load(object sender, EventArgs e)
{
OleDbConnection objConnection = null;
OleDbCommand objCmd = null;
string strConnection, strSQL;
strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=\\genfs1\www11\etning\xml\Northwind.mdb";
// Create and open the connection object
objConnection = new OleDbConnection(strConnection);
objConnection.Open();
// Set the SQL string
strSQL = "INSERT INTO Employees ( FirstName , LastName, Title )" + " VALUES ( 'etning' , 'meng','my name is etning' )";
// Create the Command and set its properties
objCmd = new OleDbCommand(strSQL, objConnection);
// Execute the command
objCmd.ExecuteNonQuery();
lblStatus.Text = "Command run";
}
</script>
<html>
<body>
<h2>Using SQL directly</h2>
<asp:Label id="lblStatus" runat="server"/>
</body>
</html>
代码无法运行，请教各位高手，怎么办才对呢？
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load(object sender, EventArgs e)
{
OleDbConnection objConnection = null;
OleDbCommand objCmd = null;
string strConnection, strSQL;
strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=\\genfs1\www11\etning\xml\Northwind.mdb";
// Create and open the connection object
objConnection = new OleDbConnection(strConnection);
objConnection.Open();
// Set the SQL string
strSQL = "INSERT INTO Employees ( FirstName , LastName, Title )" + " VALUES ( 'etning' , 'meng','my name is etning' )";
// Create the Command and set its properties
objCmd = new OleDbCommand(strSQL, objConnection);
// Execute the command
objCmd.ExecuteNonQuery();
lblStatus.Text = "Command run";
}
</script>
<html>
<body>
<h2>Using SQL directly</h2>
<asp:Label id="lblStatus" runat="server"/>
</body>
</html>
代码无法运行，请教各位高手，怎么办才对呢？
...全文
请发表友善的回复…
发表回复
ameng_2002 2002-12-21
- 打赏
- 举报
Server.MapPath("genfs1/www11/etning/xml/Northwind.mdb");
ameng_2002 2002-12-21
- 打赏
- 举报
try
strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source="+Server.Mappath("genfs1/www11/etning/xml/Northwind.mdb");
strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source="+Server.Mappath("genfs1/www11/etning/xml/Northwind.mdb");
tingningpower 2002-12-21
- 打赏
- 举报
Wolfyee(木子乐乐) :
是的可以用的，！现在就是System.Data.OleDb.OleDbException: Operation must use an updateable query.
是的可以用的，！现在就是System.Data.OleDb.OleDbException: Operation must use an updateable query.
Wolfyee 2002-12-21
- 打赏
- 举报
首先看看SQL语句有没有写错，然后再判断别的。
Wolfyee 2002-12-21
- 打赏
- 举报
你的INSERT INTO Employees ( FirstName , LastName, Title )" + " VALUES ( 'etning' , 'meng','my name is etning' ) 放到查询分析器里可以顺利执行吗？
tingningpower 2002-12-21
- 打赏
- 举报
先说明错误在：
输出错误说：Operation must use an updateable query.
输出错误说：Operation must use an updateable query.
xhan2000 2002-12-21
- 打赏
- 举报
strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=\\genfs1\www11\etning\xml\Northwind.mdb";
这儿有错
strConnection += @"Data Source=\\genfs1\www11\etning\xml\Northwind.mdb";
这儿有错
