How to dislay data in table in CF20 (DataGrid or ListView) with Column Width

[easymoney]

As far as I can see the DataGridView is not available in CF20, but DataGrid is. I need to display several records in a table. I have no problem loading the records into a DataGrid control, but cannot find a way to fix the column width in the DataGrid columns.

How do I change the width of the columns to preset values or the largest value in the column? Should I do it as a DataTable first, or some other method.

Thanks.

[IamMacro]

lstMat.View = View.Details
lstMat.Columns.Add("ID", 80, HorizontalAlignment.Left)

80 = width.
This what you been looking for ?

[easymoney]

Ok. I could use a listview. Here is some code I tried using with a ListView:

    Public Sub FillListView(ByRef MyListView As ListView, _
                                                         ByRef myData As SqlCeDataReader)
        Dim lvwColumn As ColumnHeader
        Dim itmListItem As ListViewItem

        Dim strTest As String
        Dim intLength As Integer

        Dim shtCntr As Short

        Do While myData.Read
            itmListItem = New ListViewItem()

            'strTest = IIf(myData.IsDBNull(0), "", myData.GetString(0))
            If myData.IsDBNull(0) Then
                strTest = ""
            Else

            End If

            itmListItem.Text = strTest

            For shtCntr = 0 To myData.FieldCount() - 1

                If myData.IsDBNull(shtCntr) Then
                    itmListItem.SubItems.Add("")
                Else
                    If shtCntr = 0 Then

                    Else
                        itmListItem.SubItems.Add(myData.GetString(shtCntr))
                    End If

                End If
            Next shtCntr

            MyListView.Items.Add(itmListItem)
        Loop

It fills the list view with the 3 columns I have already added prior to loading the Sql datal, but the Column 0 (primary key in table) either generates an InvalidCast error or leaves the first column blank.

Any idea why?

[IamMacro]

Im doing something like this for it to work
.

 Private Sub FORM1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 
        
        lstMat.View = View.Details
        lstMat.Columns.Add("ID", 80, HorizontalAlignment.Left)
        lstMat.Columns.Add("name", 80, HorizontalAlignment.Left)


end sub

 another sub 

connection("select * from materials where supplierID = " & DirectCast(cmbLeverancier.SelectedItem,supplier).supplierID)
            
tmpReader = sqlCmd.ExecuteReader
            While tmpReader.Read
                Dim description As String = tmpReader("articleID")
                Dim item As ListViewItem = New ListViewItem(description)
                Dim strtext As String
                strtext = tmpReader("ArtikelID")
                item.SubItems.Add(strtext)
                strtext = tmpReader("description")
                item.SubItems.Add(strtext)
                lstMat.Items.Add(item)
            End While

its a bit sloppy i guess but it does work.

[easymoney]

I will look into this again this evening. Time for some rest.

[Strider]

. .

[Strider]

what line is it throwing the exception.
also if any of the fields contains a null value it will throw an exception when you try to assign it.
so you will need to create a function to check if the reader value is null see below

Private Sub CheckIfNullString(ByVal p_reader As SqlCeReader, ByVal p_colname As String) As String
Dim l_value as String = ""
If Not p_reader(p_colname) IsDBNull then
    l_value = p_reader.getString(p_colName)
End If
return l_value
End Sub

or else use

If Not tmpReader("ArtikelID") IsDBNull Then
    strtext = tmpReader("description")
End If

[Strider]

As far as I can see the DataGridView is not available in CF20, but DataGrid is. I need to display several records in a table. I have no problem loading the records into a DataGrid control, but cannot find a way to fix the column width in the DataGrid columns.

How do I change the width of the columns to preset values or the largest value in the column? Should I do it as a DataTable first, or some other method.

Thanks.

for a datagrid you need to use the datagridtablestyles to set width and titles

sample here: http://www.codeproject.com/csharp/cu...select=1075940

[easymoney]

for a datagrid you need to use the datagridtablestyles to set width and titles

sample here: http://www.codeproject.com/csharp/cu...select=1075940

Yea, good example. I have some code that works well for that task, just didn't include it to simply things. The column format fine, just having trouble getting the primary key loaded into cell into the first colum.

The code above works with bug, its just sloppy handling Integer or Null values. I just need to clean up the routine above and make it al little more efficent. Right idea, just bad handling.

I will see if I can clean it a bit and then add the column handler back in once it fixed.