مشكل در c#

F

fariborz2004

Member
سلام من يك صفحه دارم كه خطا ميگيره اگه كسي ميتونه كمكم كنه
<%@ Page Language="C#" %>
<%@ import Namespace="Global" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">

// Insert page code here
//

void Page_Load(object sender, EventArgs e) {

AddRecord(1);
}




void AddRecord(int page_id)
{
string connString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:/WWW/tebyanwebsite/m-amozeshi/counter/counter.mdb";
OleDbConnection con = new OleDbConnection (connString);
String strQuery = "insert into counter(ip,date,time,page_id) values('test','test','test',1)";
OleDbCommand cmd = new OleDbCommand(strQuery);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}

</script>
<html>
<head>
</head>
<body>
<form runat="server">
<!-- Insert content here -->
اينم صفحه خطا

Syntax error in INSERT INTO statement.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.

Source Error:


Line 37: cmd.Connection = con;
Line 38: con.Open();
Line 39: cmd.ExecuteNonQuery();
Line 40: con.Close();
Line 41: }
 
برای ارسال پاسخ شما باید وارد سیستم شوید.

آخرین مطالب مجیدآنلاین

جدیدترین ارسال ها

بالا