in

C1 Community

ComponentOne Community is a free source for developers and help authors to collaborate and communicate.
C1 Community » NET » ADO.NET DataExtender » Unable to update Boolean value

Unable to update Boolean value

Last post 10-31-2006 4:15 AM by C1_AlexI. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next

  • 10-29-2006 2:10 PM

    Unable to update Boolean value

    Reply Contact
    OS: MS Windows XP SP2 Czech
    Datasource: MS SQL2000 SP4
    C1.C1DataExtender.2 v 2.0.20063.39

    I have table on MS SQL with column of datatype bit, typed dataset with this
    table (bit column has CLR type Boolean)
    C1DataViewSet1 with one view - table with this boolean column.
    I change value of boolean column and do C1DataViewSet1.Update().
    It raises error:"Failed to convert parameter value from a String to a
    Boolean."
    If I don't use C1DataViewSet and do update using table adapter, everything
    is OK.

    ViktorS

    ....

    A first chance exception of type 'System.FormatException' occurred in
    C1.C1DataExtender.2.dll
    System.Transactions Critical: 0 : <TraceRecord
    xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord"
    Severity="Critical"><TraceIdentifier>http://msdn.microsoft.com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/Unhandled</TraceIdentifier><Description>Unhandled
    exception</Description><AppDomain>WindowsApplication1.vshost.exe</AppDomain><Exception><ExceptionType>System.FormatException,
    mscorlib, Version=2.0.0.0, Culture=neutral,
    PublicKeyToken=b77a5c561934e089</ExceptionType><Message>Failed to convert
    parameter value from a String to a Boolean.</Message><StackTrace> at
    System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)
    at System.Data.SqlClient.SqlParameter.GetCoercedValue()
    at System.Data.SqlClient.SqlParameter.Validate(Int32 index)
    at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser,
    SqlParameterCollection parameters)
    at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior
    behavior, String commandText, SqlParameterCollection parameters,
    _SqlRPC&amp; rpc)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
    DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior,
    String method)
    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
    behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at ao.a(cq A_0, DataRow A_1)
    at ao.c(cq A_0, DataRow A_1)
    at ao.f()
    at dp.v()
    at fb.p()
    at C1.C1DataExtender.C1DataViewSet.Update()
    at WindowsApplication1.Form1.Button1_Click(Object sender, EventArgs e) in
    C:\Documents and Settings\viktors\Local Settings\Data aplikac\Temporary
    Projects\WindowsApplication1\Form1.vb:line 4
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
    at System.Windows.Forms.Control.WmMouseUp(Message&amp; m, MouseButtons
    button, Int32 clicks)
    at System.Windows.Forms.Control.WndProc(Message&amp; m)
    at System.Windows.Forms.ButtonBase.WndProc(Message&amp; m)
    at System.Windows.Forms.Button.WndProc(Message&amp; m)
    at
    System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp;
    m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp;
    m)
    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32
    msg, IntPtr wparam, IntPtr lparam)
    at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp;
    msg)
    at
    System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32
    dwComponentID, Int32 reason, Int32 pvLoopData)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.Run(ApplicationContext context)
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[]
    commandLine)
    at WindowsApplication1.My.MyApplication.Main(String[] Args) in
    17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
    at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
    at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
    assemblySecurity, String[] args)
    at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
    at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext,
    ContextCallback callback, Object state)
    at
    System.Threading.ThreadHelper.ThreadStart()</StackTrace><ExceptionString>System.FormatException:
    Failed to convert parameter value from a String to a Boolean. ---&gt;
    System.FormatException: String was not recognized as a valid Boolean.
    at System.Boolean.Parse(String value)
    at System.String.System.IConvertible.ToBoolean(IFormatProvider provider)
    at System.Convert.ChangeType(Object value, Type conversionType,
    IFormatProvider provider)
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)
    --- End of inner exception stack trace ---
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)
    at System.Data.SqlClient.SqlParameter.GetCoercedValue()
    at System.Data.SqlClient.SqlParameter.Validate(Int32 index)
    at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser,
    SqlParameterCollection parameters)
    at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior
    behavior, String commandText, SqlParameterCollection parameters,
    _SqlRPC&amp; rpc)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
    DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior,
    String method)
    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
    behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at ao.a(cq A_0, DataRow A_1)
    at ao.c(cq A_0, DataRow A_1)
    at ao.f()
    at dp.v()
    at fb.p()
    at C1.C1DataExtender.C1DataViewSet.Update()
    at WindowsApplication1.Form1.Button1_Click(Object sender, EventArgs e) in
    C:\Documents and Settings\viktors\Local Settings\Data aplikac\Temporary
    Projects\WindowsApplication1\Form1.vb:line 4
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
    at System.Windows.Forms.Control.WmMouseUp(Message&amp; m, MouseButtons
    button, Int32 clicks)
    at System.Windows.Forms.Control.WndProc(Message&amp; m)
    at System.Windows.Forms.ButtonBase.WndProc(Message&amp; m)
    at System.Windows.Forms.Button.WndProc(Message&amp; m)
    at
    System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp;
    m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp;
    m)
    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32
    msg, IntPtr wparam, IntPtr lparam)
    at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp;
    msg)
    at
    System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32
    dwComponentID, Int32 reason, Int32 pvLoopData)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.Run(ApplicationContext context)
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[]
    commandLine)
    at WindowsApplication1.My.MyApplication.Main(String[] Args) in
    17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
    at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
    at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
    assemblySecurity, String[] args)
    at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
    at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext,
    ContextCallback callback, Object state)
    at
    System.Threading.ThreadHelper.ThreadStart()</ExceptionString><InnerException><ExceptionType>System.FormatException,
    mscorlib, Version=2.0.0.0, Culture=neutral,
    PublicKeyToken=b77a5c561934e089</ExceptionType><Message>String was not
    recognized as a valid Boolean.</Message><StackTrace> at
    System.Boolean.Parse(String value)
    at System.String.System.IConvertible.ToBoolean(IFormatProvider provider)
    at System.Convert.ChangeType(Object value, Type conversionType,
    IFormatProvider provider)
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)</StackTrace><ExceptionString>System.FormatException: String
    was not recognized as a valid Boolean.
    at System.Boolean.Parse(String value)
    at System.String.System.IConvertible.ToBoolean(IFormatProvider provider)
    at System.Convert.ChangeType(Object value, Type conversionType,
    IFormatProvider provider)
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)</ExceptionString></InnerException></Exception></TraceRecord>

  • 10-30-2006 11:52 AM In reply to

    Re: Unable to update Boolean value

    Reply Contact
    Hi Viktor
     
    I can't reproduce it, I played with Products.Discontinued field from NorthWind database, via the both SqlClient and OleDB providers. Do you see any difference between this environment and yours?
     
    TIA,
    Alex
     
    <viktors> wrote in message news:188105@test.componentone.com...
    OS: MS Windows XP SP2 Czech
    Datasource: MS SQL2000 SP4
    C1.C1DataExtender.2 v 2.0.20063.39

    I have table on MS SQL with column of datatype bit, typed dataset with this
    table (bit column has CLR type Boolean)
    C1DataViewSet1 with one view - table with this boolean column.
    I change value of boolean column and do C1DataViewSet1.Update().
    It raises error:"Failed to convert parameter value from a String to a
    Boolean."
    If I don't use C1DataViewSet and do update using table adapter, everything
    is OK.

    ViktorS

    ....

    A first chance exception of type 'System.FormatException' occurred in
    C1.C1DataExtender.2.dll
    System.Transactions Critical: 0 : <TraceRecord
    xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord"
    Severity="Critical"><TraceIdentifier>http://msdn.microsoft..com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/Unhandled</TraceIdentifier><Description>Unhandled
    exception</Description><AppDomain>WindowsApplication1.vshost.exe</AppDomain><Exception><ExceptionType>System.FormatException,
    mscorlib, Version=2.0.0.0, Culture=neutral,
    PublicKeyToken=b77a5c561934e089</ExceptionType><Message>Failed to convert
    parameter value from a String to a Boolean.</Message><StackTrace> at
    System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)
    at System.Data.SqlClient.SqlParameter.GetCoercedValue()
    at System.Data.SqlClient.SqlParameter.Validate(Int32 index)
    at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser,
    SqlParameterCollection parameters)
    at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior
    behavior, String commandText, SqlParameterCollection parameters,
    _SqlRPC&amp; rpc)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
    DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior,
    String method)
    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
    behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at ao.a(cq A_0, DataRow A_1)
    at ao.c(cq A_0, DataRow A_1)
    at ao.f()
    at dp.v()
    at fb.p()
    at C1.C1DataExtender.C1DataViewSet.Update()
    at WindowsApplication1.Form1.Button1_Click(Object sender, EventArgs e) in
    C:\Documents and Settings\viktors\Local Settings\Data aplikac\Temporary
    Projects\WindowsApplication1\Form1.vb:line 4
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
    at System.Windows.Forms.Control.WmMouseUp(Message&amp; m, MouseButtons
    button, Int32 clicks)
    at System.Windows.Forms.Control.WndProc(Message&amp; m)
    at System.Windows.Forms.ButtonBase.WndProc(Message&amp; m)
    at System.Windows.Forms.Button.WndProc(Message&amp; m)
    at
    System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp;
    m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp;
    m)
    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32
    msg, IntPtr wparam, IntPtr lparam)
    at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp;
    msg)
    at
    System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32
    dwComponentID, Int32 reason, Int32 pvLoopData)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.Run(ApplicationContext context)
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase..OnRun()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase..DoApplicationModel()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase..Run(String[]
    commandLine)
    at WindowsApplication1.My.MyApplication.Main(String[] Args) in
    17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
    at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
    at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
    assemblySecurity, String[] args)
    at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
    at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext,
    ContextCallback callback, Object state)
    at
    System.Threading.ThreadHelper.ThreadStart()</StackTrace><ExceptionString>System.FormatException:
    Failed to convert parameter value from a String to a Boolean. ---&gt;
    System.FormatException: String was not recognized as a valid Boolean.
    at System.Boolean.Parse(String value)
    at System.String.System.IConvertible.ToBoolean(IFormatProvider provider)
    at System.Convert.ChangeType(Object value, Type conversionType,
    IFormatProvider provider)
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)
    --- End of inner exception stack trace ---
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)
    at System.Data.SqlClient.SqlParameter.GetCoercedValue()
    at System.Data.SqlClient.SqlParameter.Validate(Int32 index)
    at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser,
    SqlParameterCollection parameters)
    at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior
    behavior, String commandText, SqlParameterCollection parameters,
    _SqlRPC&amp; rpc)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
    DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior,
    String method)
    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
    behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at ao.a(cq A_0, DataRow A_1)
    at ao.c(cq A_0, DataRow A_1)
    at ao.f()
    at dp.v()
    at fb.p()
    at C1.C1DataExtender.C1DataViewSet.Update()
    at WindowsApplication1.Form1.Button1_Click(Object sender, EventArgs e) in
    C:\Documents and Settings\viktors\Local Settings\Data aplikac\Temporary
    Projects\WindowsApplication1\Form1.vb:line 4
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
    at System.Windows.Forms.Control.WmMouseUp(Message&amp; m, MouseButtons
    button, Int32 clicks)
    at System.Windows.Forms.Control.WndProc(Message&amp; m)
    at System.Windows.Forms.ButtonBase.WndProc(Message&amp; m)
    at System.Windows.Forms.Button.WndProc(Message&amp; m)
    at
    System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp;
    m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp;
    m)
    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32
    msg, IntPtr wparam, IntPtr lparam)
    at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp;
    msg)
    at
    System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32
    dwComponentID, Int32 reason, Int32 pvLoopData)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.Run(ApplicationContext context)
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase..OnRun()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase..DoApplicationModel()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase..Run(String[]
    commandLine)
    at WindowsApplication1.My.MyApplication.Main(String[] Args) in
    17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
    at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
    at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
    assemblySecurity, String[] args)
    at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
    at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext,
    ContextCallback callback, Object state)
    at
    System.Threading.ThreadHelper.ThreadStart()</ExceptionString><InnerException><ExceptionType>System.FormatException,
    mscorlib, Version=2.0.0.0, Culture=neutral,
    PublicKeyToken=b77a5c561934e089</ExceptionType><Message>String was not
    recognized as a valid Boolean.</Message><StackTrace> at
    System.Boolean.Parse(String value)
    at System.String.System.IConvertible.ToBoolean(IFormatProvider provider)
    at System.Convert.ChangeType(Object value, Type conversionType,
    IFormatProvider provider)
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)</StackTrace><ExceptionString>System.FormatException: String
    was not recognized as a valid Boolean.
    at System.Boolean.Parse(String value)
    at System.String.System.IConvertible.ToBoolean(IFormatProvider provider)
    at System.Convert.ChangeType(Object value, Type conversionType,
    IFormatProvider provider)
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)</ExceptionString></InnerException></Exception></TraceRecord>
    http://home.componentone.com/cs/forums/188105/ShowPost.aspx

  • 10-30-2006 4:49 PM In reply to

    Re: Unable to update Boolean value

    Reply Contact
    It is very interesting. When I create simple table with Id int identity 1,1 and data bit not null default 0 it works fine.
     
    But on my table:
     
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    CREATE TABLE [dbo].[Zbozi_BarCode](
    [id_sklad] [smallint] NOT NULL,
    [id_sortiment] [int] NOT NULL,
    [externi] [bit] NOT NULL CONSTRAINT [DF_Zbozi_BarCode_externi] DEFAULT (0),
    [BarCode] [varchar](20) COLLATE Czech_CI_AS NOT NULL,
    CONSTRAINT [PK_Zbozi_BarCode] PRIMARY KEY CLUSTERED
    (
    [id_sklad] ASC,
    [id_sortiment] ASC,
    [BarCode] ASC
    ) ON [PRIMARY]
    ) ON [PRIMARY]
     
    it fails as I've described.
    It seems that killing is column BarCode as member of primary key.
    <C1_AlexI> wrote in message news:188138@test.componentone.com...
    Hi Viktor
     
    I can't reproduce it, I played with Products.Discontinued field from NorthWind database, via the both SqlClient and OleDB providers. Do you see any difference between this environment and yours?
     
    TIA,
    Alex
     
    <viktors> wrote in message news:188105@test.componentone.com...
    OS: MS Windows XP SP2 Czech
    Datasource: MS SQL2000 SP4
    C1.C1DataExtender.2 v 2.0.20063.39

    I have table on MS SQL with column of datatype bit, typed dataset with this
    table (bit column has CLR type Boolean)
    C1DataViewSet1 with one view - table with this boolean column.
    I change value of boolean column and do C1DataViewSet1.Update().
    It raises error:"Failed to convert parameter value from a String to a
    Boolean."
    If I don't use C1DataViewSet and do update using table adapter, everything
    is OK.

    ViktorS

    ....

    A first chance exception of type 'System.FormatException' occurred in
    C1.C1DataExtender.2.dll
    System.Transactions Critical: 0 : <TraceRecord
    xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord"
    Severity="Critical"><TraceIdentifier>http://msdn.microsoft...com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/Unhandled</TraceIdentifier><Description>Unhandled
    exception</Description><AppDomain>WindowsApplication1.vshost.exe</AppDomain><Exception><ExceptionType>System.FormatException,
    mscorlib, Version=2.0.0.0, Culture=neutral,
    PublicKeyToken=b77a5c561934e089</ExceptionType><Message>Failed to convert
    parameter value from a String to a Boolean.</Message><StackTrace> at
    System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)
    at System.Data.SqlClient.SqlParameter.GetCoercedValue()
    at System.Data.SqlClient.SqlParameter.Validate(Int32 index)
    at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser,
    SqlParameterCollection parameters)
    at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior
    behavior, String commandText, SqlParameterCollection parameters,
    _SqlRPC&amp; rpc)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
    DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior,
    String method)
    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
    behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at ao.a(cq A_0, DataRow A_1)
    at ao.c(cq A_0, DataRow A_1)
    at ao.f()
    at dp.v()
    at fb.p()
    at C1.C1DataExtender.C1DataViewSet.Update()
    at WindowsApplication1.Form1.Button1_Click(Object sender, EventArgs e) in
    C:\Documents and Settings\viktors\Local Settings\Data aplikac\Temporary
    Projects\WindowsApplication1\Form1.vb:line 4
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
    at System.Windows.Forms.Control.WmMouseUp(Message&amp; m, MouseButtons
    button, Int32 clicks)
    at System.Windows.Forms.Control.WndProc(Message&amp; m)
    at System.Windows.Forms.ButtonBase.WndProc(Message&amp; m)
    at System.Windows.Forms.Button.WndProc(Message&amp; m)
    at
    System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp;
    m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp;
    m)
    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32
    msg, IntPtr wparam, IntPtr lparam)
    at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp;
    msg)
    at
    System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32
    dwComponentID, Int32 reason, Int32 pvLoopData)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.Run(ApplicationContext context)
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase...OnRun()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase...DoApplicationModel()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase...Run(String[]
    commandLine)
    at WindowsApplication1.My.MyApplication.Main(String[] Args) in
    17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
    at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
    at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
    assemblySecurity, String[] args)
    at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
    at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext,
    ContextCallback callback, Object state)
    at
    System.Threading.ThreadHelper.ThreadStart()</StackTrace><ExceptionString>System.FormatException:
    Failed to convert parameter value from a String to a Boolean. ---&gt;
    System.FormatException: String was not recognized as a valid Boolean.
    at System.Boolean.Parse(String value)
    at System.String.System.IConvertible.ToBoolean(IFormatProvider provider)
    at System.Convert.ChangeType(Object value, Type conversionType,
    IFormatProvider provider)
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)
    --- End of inner exception stack trace ---
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)
    at System.Data.SqlClient.SqlParameter.GetCoercedValue()
    at System.Data.SqlClient.SqlParameter.Validate(Int32 index)
    at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser,
    SqlParameterCollection parameters)
    at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior
    behavior, String commandText, SqlParameterCollection parameters,
    _SqlRPC&amp; rpc)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
    DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior,
    String method)
    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
    behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at ao.a(cq A_0, DataRow A_1)
    at ao.c(cq A_0, DataRow A_1)
    at ao.f()
    at dp.v()
    at fb.p()
    at C1.C1DataExtender.C1DataViewSet.Update()
    at WindowsApplication1.Form1.Button1_Click(Object sender, EventArgs e) in
    C:\Documents and Settings\viktors\Local Settings\Data aplikac\Temporary
    Projects\WindowsApplication1\Form1.vb:line 4
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
    at System.Windows.Forms.Control.WmMouseUp(Message&amp; m, MouseButtons
    button, Int32 clicks)
    at System.Windows.Forms.Control.WndProc(Message&amp; m)
    at System.Windows.Forms.ButtonBase.WndProc(Message&amp; m)
    at System.Windows.Forms.Button.WndProc(Message&amp; m)
    at
    System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp;
    m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp;
    m)
    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32
    msg, IntPtr wparam, IntPtr lparam)
    at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp;
    msg)
    at
    System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32
    dwComponentID, Int32 reason, Int32 pvLoopData)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.Run(ApplicationContext context)
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase...OnRun()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase...DoApplicationModel()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase...Run(String[]
    commandLine)
    at WindowsApplication1.My.MyApplication.Main(String[] Args) in
    17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
    at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
    at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
    assemblySecurity, String[] args)
    at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
    at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext,
    ContextCallback callback, Object state)
    at
    System.Threading.ThreadHelper.ThreadStart()</ExceptionString><InnerException><ExceptionType>System.FormatException,
    mscorlib, Version=2.0.0.0, Culture=neutral,
    PublicKeyToken=b77a5c561934e089</ExceptionType><Message>String was not
    recognized as a valid Boolean.</Message><StackTrace> at
    System.Boolean.Parse(String value)
    at System.String.System.IConvertible.ToBoolean(IFormatProvider provider)
    at System.Convert.ChangeType(Object value, Type conversionType,
    IFormatProvider provider)
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)</StackTrace><ExceptionString>System.FormatException: String
    was not recognized as a valid Boolean.
    at System.Boolean.Parse(String value)
    at System.String.System.IConvertible.ToBoolean(IFormatProvider provider)
    at System.Convert.ChangeType(Object value, Type conversionType,
    IFormatProvider provider)
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)</ExceptionString></InnerException></Exception></TraceRecord>
    http://home.componentone.com/cs/forums/188105/ShowPost.aspx


    http://home.componentone.com/cs/forums/188105/ShowPost.aspx#188138

  • 10-31-2006 4:15 AM In reply to

    Re: Unable to update Boolean value

    Reply Contact
    Thanks for the update, Viktor. You can download fixed build 2.0.20071.41 from URL:
     
    Regards,
    Alex
    <viktors> wrote in message news:188158@test.componentone.com...
    It is very interesting. When I create simple table with Id int identity 1,1 and data bit not null default 0 it works fine.
     
    But on my table:
     
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    CREATE TABLE [dbo].[Zbozi_BarCode](
    [id_sklad] [smallint] NOT NULL,
    [id_sortiment] [int] NOT NULL,
    [externi] [bit] NOT NULL CONSTRAINT [DF_Zbozi_BarCode_externi] DEFAULT (0),
    [BarCode] [varchar](20) COLLATE Czech_CI_AS NOT NULL,
    CONSTRAINT [PK_Zbozi_BarCode] PRIMARY KEY CLUSTERED
    (
    [id_sklad] ASC,
    [id_sortiment] ASC,
    [BarCode] ASC
    ) ON [PRIMARY]
    ) ON [PRIMARY]
     
    it fails as I've described.
    It seems that killing is column BarCode as member of primary key.
    <C1_AlexI> wrote in message news:188138@test.componentone.com...
    Hi Viktor
     
    I can't reproduce it, I played with Products.Discontinued field from NorthWind database, via the both SqlClient and OleDB providers. Do you see any difference between this environment and yours?
     
    TIA,
    Alex
     
    <viktors> wrote in message news:188105@test.componentone.com...
    OS: MS Windows XP SP2 Czech
    Datasource: MS SQL2000 SP4
    C1.C1DataExtender.2 v 2.0.20063.39

    I have table on MS SQL with column of datatype bit, typed dataset with this
    table (bit column has CLR type Boolean)
    C1DataViewSet1 with one view - table with this boolean column.
    I change value of boolean column and do C1DataViewSet1.Update().
    It raises error:"Failed to convert parameter value from a String to a
    Boolean."
    If I don't use C1DataViewSet and do update using table adapter, everything
    is OK.

    ViktorS

    ....

    A first chance exception of type 'System.FormatException' occurred in
    C1.C1DataExtender.2.dll
    System.Transactions Critical: 0 : <TraceRecord
    xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord"
    Severity="Critical"><TraceIdentifier>http://msdn.microsoft....com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/Unhandled</TraceIdentifier><Description>Unhandled
    exception</Description><AppDomain>WindowsApplication1.vshost.exe</AppDomain><Exception><ExceptionType>System.FormatException,
    mscorlib, Version=2.0.0.0, Culture=neutral,
    PublicKeyToken=b77a5c561934e089</ExceptionType><Message>Failed to convert
    parameter value from a String to a Boolean.</Message><StackTrace> at
    System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)
    at System.Data.SqlClient.SqlParameter.GetCoercedValue()
    at System.Data.SqlClient.SqlParameter.Validate(Int32 index)
    at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser,
    SqlParameterCollection parameters)
    at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior
    behavior, String commandText, SqlParameterCollection parameters,
    _SqlRPC&amp; rpc)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
    DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior,
    String method)
    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
    behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at ao.a(cq A_0, DataRow A_1)
    at ao.c(cq A_0, DataRow A_1)
    at ao.f()
    at dp.v()
    at fb.p()
    at C1.C1DataExtender.C1DataViewSet.Update()
    at WindowsApplication1.Form1.Button1_Click(Object sender, EventArgs e) in
    C:\Documents and Settings\viktors\Local Settings\Data aplikac\Temporary
    Projects\WindowsApplication1\Form1.vb:line 4
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
    at System.Windows.Forms.Control.WmMouseUp(Message&amp; m, MouseButtons
    button, Int32 clicks)
    at System.Windows.Forms.Control.WndProc(Message&amp; m)
    at System.Windows.Forms.ButtonBase.WndProc(Message&amp; m)
    at System.Windows.Forms.Button.WndProc(Message&amp; m)
    at
    System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp;
    m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp;
    m)
    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32
    msg, IntPtr wparam, IntPtr lparam)
    at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp;
    msg)
    at
    System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32
    dwComponentID, Int32 reason, Int32 pvLoopData)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.Run(ApplicationContext context)
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase....OnRun()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase....DoApplicationModel()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase....Run(String[]
    commandLine)
    at WindowsApplication1.My.MyApplication.Main(String[] Args) in
    17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
    at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
    at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
    assemblySecurity, String[] args)
    at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
    at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext,
    ContextCallback callback, Object state)
    at
    System.Threading.ThreadHelper.ThreadStart()</StackTrace><ExceptionString>System.FormatException:
    Failed to convert parameter value from a String to a Boolean. ---&gt;
    System.FormatException: String was not recognized as a valid Boolean.
    at System.Boolean.Parse(String value)
    at System.String.System.IConvertible.ToBoolean(IFormatProvider provider)
    at System.Convert.ChangeType(Object value, Type conversionType,
    IFormatProvider provider)
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)
    --- End of inner exception stack trace ---
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)
    at System.Data.SqlClient.SqlParameter.GetCoercedValue()
    at System.Data.SqlClient.SqlParameter.Validate(Int32 index)
    at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser,
    SqlParameterCollection parameters)
    at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior
    behavior, String commandText, SqlParameterCollection parameters,
    _SqlRPC&amp; rpc)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
    DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior,
    String method)
    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
    behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at ao.a(cq A_0, DataRow A_1)
    at ao.c(cq A_0, DataRow A_1)
    at ao.f()
    at dp.v()
    at fb.p()
    at C1.C1DataExtender.C1DataViewSet.Update()
    at WindowsApplication1.Form1.Button1_Click(Object sender, EventArgs e) in
    C:\Documents and Settings\viktors\Local Settings\Data aplikac\Temporary
    Projects\WindowsApplication1\Form1.vb:line 4
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
    at System.Windows.Forms.Control.WmMouseUp(Message&amp; m, MouseButtons
    button, Int32 clicks)
    at System.Windows.Forms.Control.WndProc(Message&amp; m)
    at System.Windows.Forms.ButtonBase.WndProc(Message&amp; m)
    at System.Windows.Forms.Button.WndProc(Message&amp; m)
    at
    System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp;
    m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp;
    m)
    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32
    msg, IntPtr wparam, IntPtr lparam)
    at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp;
    msg)
    at
    System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32
    dwComponentID, Int32 reason, Int32 pvLoopData)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32
    reason, ApplicationContext context)
    at System.Windows.Forms.Application.Run(ApplicationContext context)
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase....OnRun()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase....DoApplicationModel()
    at
    Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase....Run(String[]
    commandLine)
    at WindowsApplication1.My.MyApplication.Main(String[] Args) in
    17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
    at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
    at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
    assemblySecurity, String[] args)
    at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
    at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext,
    ContextCallback callback, Object state)
    at
    System.Threading.ThreadHelper.ThreadStart()</ExceptionString><InnerException><ExceptionType>System.FormatException,
    mscorlib, Version=2.0.0.0, Culture=neutral,
    PublicKeyToken=b77a5c561934e089</ExceptionType><Message>String was not
    recognized as a valid Boolean.</Message><StackTrace> at
    System.Boolean.Parse(String value)
    at System.String.System.IConvertible.ToBoolean(IFormatProvider provider)
    at System.Convert.ChangeType(Object value, Type conversionType,
    IFormatProvider provider)
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)</StackTrace><ExceptionString>System.FormatException: String
    was not recognized as a valid Boolean.
    at System.Boolean.Parse(String value)
    at System.String.System.IConvertible.ToBoolean(IFormatProvider provider)
    at System.Convert.ChangeType(Object value, Type conversionType,
    IFormatProvider provider)
    at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType
    destinationType)</ExceptionString></InnerException></Exception></TraceRecord>
    http://home.componentone.com/cs/forums/188105/ShowPost.aspx


    http://home.componentone.com/cs/forums/188105/ShowPost.aspx#188138


    http://home.componentone.com/cs/forums/188138/ShowPost.aspx#188158
Page 1 of 1 (4 items)
Contact ComponentOne: 1.800.858.2739 ©1987-2008 ComponentOne LLC All Rights Reserved.