Atrocios1
سه شنبه 11 فروردین 1388, 04:52 صبح
سلام دوستان
اگه میشه بگید که مشکل این کد من چیه:
Dim Command1 As New OleDbCommand("Select UserName, Password From Admin_TBL Where UserName='" + Session.Contents("UserName") + "'", Connection)
Connection.Open()
Dim DR1 As OleDbDataReader = Command1.ExecuteReader
If DR1.Read Then
If DR1.Item(1) = TextBox1.Text Then
Dim Command2 As New OleDbCommand("Update Admin_TBL Set Password='" + TextBox2.Text + "' Where UserName='" + Session.Contents("UserName") + "'", Connection)
Command2.ExecuteNonQuery()
ElseIf DR1.Item(1) <> TextBox1.Text Then
Response.Write("<SCRIPT>alert('لطفآ پسورد قبلی را صحیح وارد نمایید!')</SCRIPT>")
GoTo EndLabel
End If
End If
Connection.Close()
EndLabel:
آخه وقتی این کد را تست می کنم این ارور میاد!!!
Server Error in '/Test' Application.
Syntax error in UPDATE 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 UPDATE statement.
Source Error:
Line 33: If DR1.Item(1) = TextBox1.Text Then
Line 34: Dim Command2 As New OleDbCommand("Update Admin_TBL Set Password='" + TextBox2.Text + "' Where UserName='" + UserName + "'", Connection)
Line 35: Command2.ExecuteNonQuery()
Line 36: ElseIf DR1.Item(1) <> TextBox1.Text Then
Line 37: Response.Write("<SCRIPT>alert('ظ„ط·ظپط¢ ظ¾ط³ظˆط±ط¯ ظ‚ط¨ظ„غŒ ط±ط§ طµطغŒط ظˆط§ط±ط¯ ظ†ظ…ط§غŒغŒط¯!')</SCRIPT>")
Source File: C:\Documents and Settings\Atrocios\Desktop\Files\Test\Administrator \Pass.aspx.vb Line: 35
Stack Trace:
[OleDbException (0x80040e14): Syntax error in UPDATE statement.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult) +177
System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult) +194
System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult) +56
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method) +105
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +88
Administrator_Pass.Button1_Click(Object sender, EventArgs e) in C:\Documents and Settings\Atrocios\Desktop\Files\Test\Administrator \Pass.aspx.vb:35
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +75
System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +97
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4885
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
من می خوام با این دستور فیلد Password را در جدول Admin_TBLویرایش کنم
ببخشید اگه خیلی مقدماتی و پیش پا افتاده است!:ناراحت:
اگه میشه بگید که مشکل این کد من چیه:
Dim Command1 As New OleDbCommand("Select UserName, Password From Admin_TBL Where UserName='" + Session.Contents("UserName") + "'", Connection)
Connection.Open()
Dim DR1 As OleDbDataReader = Command1.ExecuteReader
If DR1.Read Then
If DR1.Item(1) = TextBox1.Text Then
Dim Command2 As New OleDbCommand("Update Admin_TBL Set Password='" + TextBox2.Text + "' Where UserName='" + Session.Contents("UserName") + "'", Connection)
Command2.ExecuteNonQuery()
ElseIf DR1.Item(1) <> TextBox1.Text Then
Response.Write("<SCRIPT>alert('لطفآ پسورد قبلی را صحیح وارد نمایید!')</SCRIPT>")
GoTo EndLabel
End If
End If
Connection.Close()
EndLabel:
آخه وقتی این کد را تست می کنم این ارور میاد!!!
Server Error in '/Test' Application.
Syntax error in UPDATE 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 UPDATE statement.
Source Error:
Line 33: If DR1.Item(1) = TextBox1.Text Then
Line 34: Dim Command2 As New OleDbCommand("Update Admin_TBL Set Password='" + TextBox2.Text + "' Where UserName='" + UserName + "'", Connection)
Line 35: Command2.ExecuteNonQuery()
Line 36: ElseIf DR1.Item(1) <> TextBox1.Text Then
Line 37: Response.Write("<SCRIPT>alert('ظ„ط·ظپط¢ ظ¾ط³ظˆط±ط¯ ظ‚ط¨ظ„غŒ ط±ط§ طµطغŒط ظˆط§ط±ط¯ ظ†ظ…ط§غŒغŒط¯!')</SCRIPT>")
Source File: C:\Documents and Settings\Atrocios\Desktop\Files\Test\Administrator \Pass.aspx.vb Line: 35
Stack Trace:
[OleDbException (0x80040e14): Syntax error in UPDATE statement.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult) +177
System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult) +194
System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult) +56
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method) +105
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +88
Administrator_Pass.Button1_Click(Object sender, EventArgs e) in C:\Documents and Settings\Atrocios\Desktop\Files\Test\Administrator \Pass.aspx.vb:35
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +75
System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +97
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4885
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
من می خوام با این دستور فیلد Password را در جدول Admin_TBLویرایش کنم
ببخشید اگه خیلی مقدماتی و پیش پا افتاده است!:ناراحت: