C#-direct SQL

lionking · December 24th, 2003, 03:35 PM

can somebody tell me whats wrong with this direct SQL code i took from book. its showing error at the line

   objCmd.ExecuteNonQuery();

OleDbException (0x80040e10): No value given for one or more required parameters.

---------------------------------------------------

<%@ Page Language="C#" Debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script 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=C:\Documents and Settings\Jenu\Desktop\testing\northwind.mdb";

       // Create and open the connection object

       objConnection = new OleDbConnection(strConnection);
       objConnection.Open();

       // Set the SQL string
       strSQL = "INSERT INTO Employees (FirstName,LastName) VALUES ( `Beth` , `Hart` )";

       // Create the Command and set its properties

       objCmd = new OleDbCommand(strSQL, objConnection);

       // Execute the command

       objCmd.ExecuteNonQuery();

       lblStatus.Text = " Command run ";
     }

</script>
<html>
<head>
</head>
<body>
    <h2>Using SQL directly
    </h2>
    <asp:Label id="lblStatus" runat="server"></asp:Label>
</body>
</html>

lionking · December 29th, 2003, 10:55 AM

guys I'm still waiting for some help....
coudnt figure out what parameter its asking for

Imar · December 29th, 2003, 11:01 AM

Hi there,

Take a look here: http://www.adopenstatic.com/faq/80040e10.asp
It discusses various solutions to 80040e10 errors.

Another thing to check are the access rights to your database. The Web server will use the IUSR_MachineName account where MachineName is the name of your computer. Depending on your set up, this account does not have permission to access your desktop. If I were you, I'd move the database to a specific folder (e.g. c:\Databases) and then set the correct permissions on that folder. IUSR_MachineName needs at least change permission on the Databases folder to change the .MDB file and to create lock file (.ldb).

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Imar · December 29th, 2003, 11:03 AM

One more thing to check:

Code:

strSQL = "INSERT INTO Employees (FirstName,LastName) VALUES ( `Beth` , `Hart` )";

I don't think you can use these extended quotes. Change it to this:

Code:

strSQL = "INSERT INTO Employees (FirstName,LastName) VALUES ('Beth', 'Hart')";

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

lionking · December 29th, 2003, 08:45 PM

Thanks a lot....
that was an invisible error
the code worked