Intersoft Community - WebGrid Enterprise - The checkbox can not show it checked when using Oracle DataBase

The checkbox can not show it checked when using Oracle DataBase

yudi — Mon, 24 Oct 2011 05:49:35 GMT

Please kindly check the “BindtoCustomObject.aspx” sample file. The sample demonstrates how to bind WebGrid with a CustomObject collection. CustomObject used in this sample is GenericObject.Customer. Please refer to GenericObject\Customer.cs and GenericObject\CustomerDataAccess.cs for detailed code.

Thank you and have a nice day.

The checkbox can not show it checked when using Oracle DataBase

gavin — Fri, 21 Oct 2011 03:16:15 GMT

Hello Yudi ,

I am also confused about what you said . In WebGridSamples project , there are many files and I do not know which one is I want . Can you tell me more about that ? If you can send me a sample , I will appreciate that .

The checkbox can not show it checked when using Oracle DataBase

yudi — Thu, 20 Oct 2011 21:31:45 GMT

Apologize for the delay in sending this.

I think this scenario can be implemented using custom object. Please kindly check the sample that available in WebGridSamples project.

The checkbox can not show it checked when using Oracle DataBase

gavin — Tue, 18 Oct 2011 00:08:00 GMT

Hello Yudi ,

Thank you for your reply . You tell me the mistake , but how should I solve this problem and make the grid show the checked checkbox ?

Thanks a lot !

The checkbox can not show it checked when using Oracle DataBase

yudi — Mon, 17 Oct 2011 22:29:40 GMT

Oracle Native Data Type or PL/SQL Data Type	ODP.NET Type	.NET Framework Data Types
`...`	`...`	`...`
`NUMBER`	`OracleDecimal` structure	`System.Decimal`
`...`	`...`	`...`

The “NUMBER” data type that refers to both Oracle native data types and PL/SQL data types corresponds to the “System.Decimal” in the .NET Framework data types. That should explains why does the grid doesn’t show the checked checkbox based on the given data.

For more detail information, please check the “ODP.NET Types Overview” article at http://download.oracle.com/docs/html/B28089_01/featTypes.htm#i1006604.

Hope this helps.

The checkbox can not show it checked when using Oracle DataBase

gavin — Mon, 17 Oct 2011 02:37:55 GMT

Hello ,

I meet a problem when I use Oracle Database . In my WebGrid , there is a column of checkbox and it display whether these checkboxs checked according to the data of Oracle Database . But now these checkboxs can not show them checked .

The following code is about the column of checkbox .

<ISWebGrid:WebGridColumn Name="IsShow" Caption="IsShow" AllowSorting="No" Width="50px"
             DataMember="IsShow" IsAutoWidth="false" ColumnType="CheckBox"   
              EditType="Checkbox"  DataType="System.Boolean">
</ISWebGrid:WebGridColumn>

The datatype of this column in the Oracle DataBase is Number(1) .

Anyone can help me ? Thanks a lot !