DataGrid boolcolumn problem...

From: sj via DotNetMonster.com (forum_at_DotNetMonster.com)
Date: 03/24/05 

Date: Thu, 24 Mar 2005 01:36:16 GMT

Hi
I'm trying to solve this problem for several weeks. I've found similar
problems but that didn't work in my side.

My problem is,
When binding data to the datagrid, datagridboolcolumn is all checked.
And I think the reason is, datatype.
I'm using Oracle, and there are no type of bool of bit... So i made Char(1)
type data for it.
I set datacolum of datatable's data type to bool, but after fill the data
set, data type turn to string.
Dose it couse this problem? or any idea?

Your advice will be appreciated.

Here are my code...

                        this.dataGrid1 = new System.Windows.Forms.DataGrid();
                        this.dataSet1 = new System.Data.DataSet();
                        this.dataTable1 = new System.Data.DataTable();
                        this.dataGridTableStyle1 = new System.Windows.Forms.DataGridTableStyle();
                        this.dataGridBoolColumn1 = new System.Windows.Forms.DataGridBoolColumn();

                        this.dataColumn1 = new System.Data.DataColumn();
                        

                        //
                        // dataSet1
                        //
                        this.dataSet1.DataSetName = "NewDataSet";
                        this.dataSet1.Locale = new System.Globalization.CultureInfo("en-US");
                        this.dataSet1.Tables.AddRange(new System.Data.DataTable[] {
                                                                                                                                                  this.dataTable1});
                        //
                        // dataTable1
                        //
                        this.dataTable1.Columns.AddRange(new System.Data.DataColumn[] {
                                                                                                                                                          this.dataColumn1});
                        this.dataTable1.TableName = "idx_daily";
                        //
                        // dataGridTableStyle1
                        //
                        this.dataGridTableStyle1.DataGrid = this.dataGrid1;
                
                        //
                        // dataGridBoolColumn1
                        //
                        this.dataGridBoolColumn1.AllowNull = false;
                        this.dataGridBoolColumn1.FalseValue = false;
                        this.dataGridBoolColumn1.HeaderText = "??";
                        this.dataGridBoolColumn1.MappingName = "CheckBox";
                        this.dataGridBoolColumn1.NullText = "";
                        this.dataGridBoolColumn1.NullValue = false;
                        this.dataGridBoolColumn1.TrueValue = true;
                        this.dataGridBoolColumn1.Width = 30; //
                        // dataColumn1
                        //
                        this.dataColumn1.AllowDBNull = false;
                        this.dataColumn1.ColumnName = "CheckBox";
                        this.dataColumn1.DataType = typeof(bool);
                        this.dataColumn1.DefaultValue = false;

                private void button1_Click(object sender, System.EventArgs e)
                {

                        String SelectQuery = "Select '0' as CheckBox from idx_daily a where 1=
1";

                        String tname = "idx_daily";

                    // DB?? ?? ??
                        clsDBConn dbconn = new clsDBConn();

                        dataSet1 = dbconn.GetDataSet(tname,SelectQuery);

// dataSet1.Tables[0].Columns["checkbox"].DefaultValue = false;

                        Console.WriteLine(dataTable1.Columns[0].DataType);
                        Console.WriteLine(dataSet1.Tables[0].Columns[0].DataType);

                        dataTable1 = this.dataSet1.Tables[0];

                

                        Console.WriteLine(dataTable1.Columns[0].DataType);
                        Console.WriteLine(dataSet1.Tables[0].Columns[0].DataType);

                        
                        dataGrid1.DataSource = dataSet1;

                        dataGridTableStyle1.MappingName = tname; 

-- 
Message posted via http://www.dotnetmonster.com