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, 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 ?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
