stack trace :
[MySqlConversionException: Unable to convert MySQL date/time value to
System.DateTime]
MySql.Data.Types.MySqlDateTime.GetDateTime() +139
MySql.Data.MySqlClient.MySqlDataReader.GetDateTime(Int32 i) +258
DbLinq.Util.IDataRecordExtensions.GetAsNullableDateTime(IDataRecord
dataRecord, Int32 index) in D:\Mes Documents\01-téléchargements\LINQ
\DbLinq-0.18\src\DbLinq\Util\IDataRecordExtensions.cs:137
lambda_method(ExecutionScope , IDataRecord , MappingContext ) +5236
DbLinq.Data.Linq.Sugar.Implementation.<Select>d__0`1.MoveNext() in
D:\Mes Documents\01-téléchargements\LINQ\DbLinq-0.18\src\DbLinq\Data
\Linq\Sugar\Implementation\QueryRunner.cs:131
System.Web.UI.WebControls.GridView.CreateAutoGeneratedColumns(PagedDataSource
dataSource) +284
System.Web.UI.WebControls.GridView.CreateColumns(PagedDataSource
dataSource, Boolean useDataSource) +418
System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable
dataSource, Boolean dataBinding) +640
System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable
data) +57
System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable
data) +14
System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable
data) +114
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments
arguments, DataSourceViewSelectCallback callback) +31
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +142
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73
System.Web.UI.WebControls.GridView.DataBind() +4
AdminGepi.gepiLinq.Page_Load(Object sender, EventArgs e) in D:\Mes
documents\Mes sites Web\gepi\WebApplication1\gepiLinq.aspx.vb:16
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+627
On 25 sep, 22:41, "Pascal Craponne" <[EMAIL PROTECTED]> wrote:
> Hi,
> could you provide a stack trace?
>
> Thanks.
>
>
>
>
>
> On Thu, Sep 25, 2008 at 11:48, frevidoc <[EMAIL PROTECTED]> wrote:
>
> > my connection string is "Server=serv-iis;User
> > ID=root;Password=blabla;Persist Security
> > Info=True;Database=gepi1501;Allow Zero Datetime=True" the connection
> > works fine in the server explorer, but when test it via Dblinq it
> > occurs thirs error
> > "Unable to convert MySQL date/time value to System.DateTime error"
> > my code is :
>
> > Dim MyConnexionString As New
> > MySql.Data.MySqlClient.MySqlConnectionStringBuilder
> > MyConnexionString.ConnectionString =
>
> > ConfigurationManager.ConnectionStrings("gepi1501ConnectionString").ConnectionString
> > Dim MyConnexion As MySqlConnection = New
> > MySqlConnection(MyConnexionString.ConnectionString)
> > Dim db As GePi1501 = New GePi1501(MyConnexion)
> > Dim MyUsers = From u In db.UtIlIsaTeURS _
> > Select u _
> > Order By u.NoM
> > GridView2.DataSource = MyUsers
> > GridView2.DataBind()
>
> > in the web.config the connectionString is :
>
> > <connectionStrings>
> > <add name="gepi1501ConnectionString" connectionString="Server=serv-
> > iis;User ID=root;Password=blabla;Persist Security
> > Info=True;Database=gepi1501;Allow Zero Datetime=True"
> > providerName="MySql.Data.MySqlClient"/>
> > </connectionStrings>
>
> > any idea ?
>
> --
> Pascal.
>
> jabber/gtalk: [EMAIL PROTECTED]
> msn: [EMAIL PROTECTED] Masquer le texte des messages précédents -
>
> - Afficher le texte des messages précédents -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---
