15. august 2006 - 11:33Der er
13 kommentarer og 1 løsning
Problemer med at skrive dato til acces
jeg har lidt probelmer med at skrive en dato til accesdatabase, feltet jeg prøver at skrive til er af typen dato og klokkeslet, og datoen jeg prøver at skrive dertil er af typen System.DateTime.Now;
Jeg får fejlen :
Der er en syntaksfejl, fordi der mangler en operator. i forespørgselsudtrykket "15-08-2006 11:32:54". 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: Der er en syntaksfejl, fordi der mangler en operator. i forespørgselsudtrykket "15-08-2006 11:32:54".
Source Error:
The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:
1. Add a "Debug=true" directive at the top of the file that generated the error. Example:
<%@ Page Language="C#" Debug="true" %>
or:
2) Add the following section to the configuration file of your application:
Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.
Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.
-------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
Hos Computerworld it-jobbank er vi stolte af at fortsætte det gode partnerskab med folkene bag IT-DAY – efter vores mening Danmarks bedste karrieremesse for unge og erfarne it-kandidater.
Server Error in '/KrogAndersen' Application. --------------------------------------------------------------------------------
Der er en syntaksfejl, fordi der mangler en operator. i forespørgselsudtrykket "Anders alm. Timer". 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: Der er en syntaksfejl, fordi der mangler en operator. i forespørgselsudtrykket "Anders alm. Timer".
Source Error:
Line 50: ", " + DropDownList1.Text.ToString() + ", " + TextBox2.Text.ToString() + ")"; Line 51: AccessDataSource4.InsertCommand = InsertCommand; Line 52: AccessDataSource4.Insert(); Line 53: Line 54: }
Source File: c:\Documents and Settings\jesg\Dokumenter\KrogAndersen\Default.aspx.cs Line: 52
Stack Trace:
[OleDbException (0x80040e14): Der er en syntaksfejl, fordi der mangler en operator. i forespørgselsudtrykket "Anders alm. Timer".] System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +177 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +194 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +56 System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +105 System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +88 System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +392 System.Web.UI.WebControls.SqlDataSourceView.ExecuteInsert(IDictionary values) +405 System.Web.UI.WebControls.SqlDataSource.Insert() +13 _Default.Button1_Click(Object sender, EventArgs e) in c:\Documents and Settings\jesg\Dokumenter\KrogAndersen\Default.aspx.cs:52 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +75 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +97 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4919
-------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
Ok den havde jeg lige misset når der er tale om en string skal det være ' " + en-tekst + " ' og når det er int "+ et-tal +"
/Websam
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.