◀ Previous Next ▶ Up ▲


witpoko.com


มีปํญหาเกี่ยวกับการติดต่อฐานข้อมูลครับ access

ช่วยดูให้หน่อยครับ มันบอกว่าอะไรไม่รู้ (เปิดดิก ก็แล้ว)
Server Error in '/IRC_1' Application.
--------------------------------------------------------------------------------

No value given for one or more required parameters.
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: No value given for one or more required parameters.

Source Error:


Line 48: Dim cmdUpdate As New OleDbCommand("UPDATE table1 SET ccounter = A" & " WHERE ID =1", Myconn)
Line 49: Dim myUpdate As Integer
Line 50: myUpdate = cmdUpdate.ExecuteNonQuery
Line 51: 'cmdUpdate.ExecuteNonQuery()
Line 52: Myconn.Close()


Source File: c:\inetpub\wwwroot\IRC_1\contents.aspx.vb Line: 50

Stack Trace:


[OleDbException (0x80040e10): No value given for one or more required parameters.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) +41
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +174
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +92
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +65
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +112
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +66
IRC_1.sss.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\IRC_1\contents.aspx.vb:50
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573


จากคุณ : Spy_heart -[ 19 มี.ค. 51 - 11:57:46 A:118.173.156.161 X: ]





กระทู้ยอดนิยม