C1 Community

<egridsoft> wrote in message news:188615@test.componentone.com...

I find a bug:

 

        Dim rnd As New Random
        Dim Table1 As New Data.DataTable
        Dim view As New C1.C1DataExtender.C1DataView
        Dim Dataset1 As New Data.DataSet
        Me.c1DataViewSet1.Views.Add(view)
        Table1.Columns.Add("Col0", GetType(Integer))
        Table1.Columns.Add("Col1", GetType(Integer))
        For i As Integer = 2 To 9
            Table1.Columns.Add("Col" & i, GetType(String))
        Next
        Table1.PrimaryKey = New Data.DataColumn() {Table1.Columns("Col0"), Table1.Columns("Col1")}
        For i As Integer = 0 To 100
            Dim Row As Data.DataRow
            Row = Table1.NewRow
            Row("Col0") = i
            Row("Col1") = i * 2
            For n As Integer = 2 To 9
                Row("Col" & n) = Math.Floor(rnd.NextDouble * 10)
            Next
            Table1.Rows.Add(Row)
        Next
        Dataset1.Tables.Add(Table1)
        Table1.TableName = "Table1"
        Me.c1DataViewSet1.DataSet = Dataset1

        Me.c1DataViewSet1.Views(0).Definition = "select * from Table1"
        Me.c1DataViewSet1.Views(0).RowFilter = "Col2 = '5'"          'A error will be raised here 

 

 

But if i modify the code as this,No error will be raised:

 

 

        Dim rnd As New Random
        Dim Table1 As New Data.DataTable
        Dim view As New C1.C1DataExtender.C1DataView
        Dim Dataset1 As New Data.DataSet
        Me.c1DataViewSet1.Views.Add(view)
        Table1.Columns.Add("Col0", GetType(Integer))
        Table1.Columns.Add("Col1", GetType(Integer))
        For i As Integer = 2 To 9
            Table1.Columns.Add("Col" & i, GetType(String))
        Next
        Table1.PrimaryKey = New Data.DataColumn() {Table1.Columns("Col0"), Table1.Columns("Col1")}
        For i As Integer = 0 To 100
            Dim Row As Data.DataRow
            Row = Table1.NewRow
            Row("Col0") = i
            Row("Col1") = i * 2
            For n As Integer = 2 To 9
                Row("Col" & n) = Math.Floor(rnd.NextDouble * 10)
            Next
            Table1.Rows.Add(Row)
        Next
        Dataset1.Tables.Add(Table1)
        Table1.TableName = "Table1"
        Me.c1DataViewSet1.DataSet = Dataset1

        Me.c1DataViewSet1.Views(0).RowFilter = "Col2 = '5'"

        Me.c1DataViewSet1.Views(0).Definition = "select * from Table1"

 

So,I can not change then RowFilter property.

---

http://home.componentone.com/cs/forums/188615/ShowPost.aspx