yasser_sajjadi
Member
مندر asp.net كار ميكنم
وقتي مي خوام در يك جدول اكسس چيزي رو اضافه كنم web.config ارور ميده
اين كد هاي صفحه
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicK eyToken=836f606ede05d46a,culture=neutral" %><MM:Insert
runat="server"
CommandText='<%# "INSERT INTO UserA (Password, Username) VALUES (?, ?)" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_STRING_UserP") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_DATABASETYPE_UserP") %>'
Expression='<%# Request.Form("MM_insert") = "form1" %>'
CreateDataSet="false"
SuccessURL='<%# "../Acount/ViewID.aspx" %>'
FailureURL='<%# "../Acount/LED-DEL.aspx" %>'
Debug="true"
><Parameters>
<Parameter Name="@Password" Value='<%# IIf((Request.Form("Password") <> Nothing), Request.Form("Password"), "") %>' Type="WChar" />
<Parameter Name="@Username" Value='<%# IIf((Request.Form("Username") <> Nothing), Request.Form("Username"), "") %>' Type="WChar" />
</Parameters>
</MM:Insert>
<MM
ageBind runat="server" PostBackBind="true" />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<form method="post" name="form1" runat="server">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Username:</td>
<td><asp:textbox id="Username" TextMode="SingleLine" Columns="32" runat="server" />
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Password:</td>
<td><asp:textbox id="Password" TextMode="Password" Columns="32" runat="server" />
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input type="submit" value="Insert record"></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</form>
<p> </p>
</body>
</html>
اين هم اررورش
System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at DreamweaverCtrls.DataSet.DoInit()
وقتي مي خوام در يك جدول اكسس چيزي رو اضافه كنم web.config ارور ميده
اين كد هاي صفحه
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicK eyToken=836f606ede05d46a,culture=neutral" %><MM:Insert
runat="server"
CommandText='<%# "INSERT INTO UserA (Password, Username) VALUES (?, ?)" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_STRING_UserP") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_DATABASETYPE_UserP") %>'
Expression='<%# Request.Form("MM_insert") = "form1" %>'
CreateDataSet="false"
SuccessURL='<%# "../Acount/ViewID.aspx" %>'
FailureURL='<%# "../Acount/LED-DEL.aspx" %>'
Debug="true"
><Parameters>
<Parameter Name="@Password" Value='<%# IIf((Request.Form("Password") <> Nothing), Request.Form("Password"), "") %>' Type="WChar" />
<Parameter Name="@Username" Value='<%# IIf((Request.Form("Username") <> Nothing), Request.Form("Username"), "") %>' Type="WChar" />
</Parameters>
</MM:Insert>
<MM
ageBind runat="server" PostBackBind="true" /><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<form method="post" name="form1" runat="server">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Username:</td>
<td><asp:textbox id="Username" TextMode="SingleLine" Columns="32" runat="server" />
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Password:</td>
<td><asp:textbox id="Password" TextMode="Password" Columns="32" runat="server" />
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input type="submit" value="Insert record"></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</form>
<p> </p>
</body>
</html>
اين هم اررورش
System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at DreamweaverCtrls.DataSet.DoInit()
