Hello I've been debugging this for about an hour now would be really grateful if someone could lend a hand with this. I'm getting errors saying a method can't find a function associated with it, but I've used the same thing throughout the application and it didn't used to cause problems until now. I've been told errors like these can have their root far away from the flagged line of code. Here's the error:
Code:
Compiler Error Message: CS0117: 'System.Data.OleDb.OleDbCommand' does not contain a definition for 'ExecutenonOverv'
Source Error:
Line 33: String sql = "INSERT into products (PID, Name, Price, Stock) values(" + PIDStr + "," + NameStr + "," + PriceStr + "," + StockStr + ")";
Line 34: OleDbCommand command = new OleDbCommand(sql, oleconn);
Line 35: int rowsAffected = (int)command.ExecutenonOverv();
Line 36: Session["PID"] = PIDTxt.Text;
Line 37: Session["Name"] = NameTxt.Text;
Source File: c:\Documents and Settings\H\workspace\Voipshop\products.aspx.cs Line: 35
I've attached the two files. One is the main file and the other is the code file, the products_aspx_cs.txt is the one with the problem. Due to the board's extension limitations I can't post the files with their default extensions.
I'd really appreciate the advice.
Thanks.