Ext.Net Grid Checkbox Column Problem

[sumesh]

Hi ........

I am Facing a problem while using ext grid panel with a checkbox column inside it. Assigned DataIndex datatype as boolean and its working fine when binding Boolean Data.But the problem is when I'm using oracle as backend (There is no Boolean Datatype,hence used char)....
Anyway i want to bind the data from DB in Grid..All other fields get binded..except checkbox....

Is there any other option to set the checkbox checked , unchecked based on a char value while binding Grid with the store...?


Pls Help...............................

[Vladimir]

Please use Field converter
https://examples1.ext.net/#/GridPane...eld_Converter/

[sumesh]

Hi Viladimir ....

Thanks for your reply........

I tried as shown in the sample..but still now i cant overcome

            DataTable table1 = new DataTable("GridTable");
            DataColumnCollection columns1 = table1.Columns;

            DataColumn Column1 = columns1.Add(ID_FIELD, typeof(System.Int32));         
            columns1.Add(FORMNAME_FIELD, typeof(System.String));
            columns1.Add(ADDRIGHTS_FIELD , typeof(System.Boolean   ));



               <ext:RecordField Name="FORMNAME" />
             <ext:RecordField Name="addrights" Type ="Boolean"   >
               <Convert Handler="return value === 'Y';" />
               </ext:RecordField> 

             Returned Datatable From DB

               /----------------------------/

                N	1	New Mail Entry
                Y	2	Mail View
                Y      3	Mail Attachment Details

               /------------------------------/

      But still i cant achieve it in screen...when i see in explorer ,checkbox remains unchecked....

[Vladimir]

Well, in this case, i guess you bind data without that values
Please check your DataTable before binding. Are sure that the following line is correct?

columns1.Add(ADDRIGHTS_FIELD , typeof(System.Boolean));

I don't think that 'typeof(System.Boolean)' is required if you return 'char' from DB

[sumesh]

i have used conversion in oracle query and tried converting it to a char value

SELECT TF.formid,TF.FormName,decode(TR.addrights,1,'Y',0,'N') as addrights FROM tblformdetails TF

Even it returns a char value , as shown in my previous example , it does not affect the CheckBox Column

Even i tried without typed Dataset, it doesn't affect

  OleDbCommand command = new OleDbCommand("CRUD_Sample.GetSampleData");
                command.Connection = oracleConn;
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.Add("p_id", OleDbType.Integer).Value = UserID;
                OleDbDataAdapter da = new OleDbDataAdapter(command);
                da.Fill(ds, "TblModulesForms");

Binding Grid as follows.....

    
           Store1.DataSource =ds.Tables[0];
            Store1.DataBind();

[Vladimir]

How values are represented in DataTable before binding?
Also, how the data is serialized (you can find it in the browser source page)