datagrid help

[vbdotnetboy]

can someone please help me... I will be completely honest here... I have no freaking cute how to really use the datagrid and none of my books have been any help... is there any way to retreive data using inner joins and then place the information into the datagrid and format the header text and the columns themselves so that if it's null to just clear it and to have it readonly... here's me code along with a screen shot of what i still come up with... i'm pulling what hair that i have left out here.... please i'm on my knee help!!!

the code is just for testing until i figure this out.

Private Sub InitialDataGrid()
        Dim ds As New DataSet
 
        Dim sql As New StringBuilder
        With sql
            .Append("SELECT library_tbl.library_name, library_tbl.address1, ")
            .Append("library_tbl.address2, location_tbl.city, location_tbl.state, ")
            .Append("location_tbl.ZIPCODE, library_tbl.phone, library_tbl.fax ")
            .Append("FROM location_tbl INNER JOIN library_tbl ON ")
            .Append("location_tbl.ZIPCODE = library_tbl.LOCATION_ID")
        End With
        Dim daLibs As New OleDb.OleDbDataAdapter(sql.ToString, cn)
 
        daLibs.Fill(ds)
        Me.DataGrid1.DataSource = ds
        Dim dgtsInfo As New DataGridTableStyle
        With dgtsInfo
            .MappingName = "library_tbl"
 
            Dim dgtbcCity As New DataGridTextBoxColumn
            With dgtbcCity
                .HeaderText = "City"
                .MappingName = "loction_tbl.city"
                .NullText = ""
                .ReadOnly = True
            End With
 
            .GridColumnStyles.Add(dgtbcCity)
        End With
 
        Me.DataGrid1.TableStyles.Add(dgtsInfo)
 
    End Sub

screen shot of what i actually get

[kleinma]

you should consider using a listview.... they are just so much nicer than the datagrid, especially since I see you are using it as a readonly data display...

i know sometimes people don't want someone suggesting them in the other direction and would rather fix the issue at hand...

I personally don't know how you can mask data in the datagrid, because I never use it, but I imagine there has to be a way, if there isn't you could always put that in your SQL Statement, with a select case or something along those lines

but have you used the listview in any of your other apps?

[vbdotnetboy]

i was affraid you were going to suggest the listview... yes i've used it before... the only reason i didn't want to use it here was because of the time it takes to load the data into the view... unless you know of a quicker way to load the data i will still have to loop through the records to load them... oh well... you would think that they would have made the datagrid so that you could have manipulated the data a little easier... but then again that's M$ for you. thanx kleinma

[kleinma]

I have an app that I moved from VB6 to VB.NET

this app loads records (with about 12 fields) into a listview...

the code to load the listview in VB6 took upwards of 20 seconds to load the list, the same code written in .net loads in about 5

I think its a combination of the listview and database access code both improved in .net

but anyways i think i got it for you

Dim dgtbcCity As New DataGridTextBoxColumn
            With dgtbcCity
                [b].NullText = "NO DATA"[/b]
                .HeaderText = "City"
                .MappingName = "loction_tbl.city"
                .NullText = ""
                .ReadOnly = True
            End With

[vbdotnetboy]

I have an app that I moved from VB6 to VB.NET

this app loads records (with about 12 fields) into a listview...

the code to load the listview in VB6 took upwards of 20 seconds to load the list, the same code written in .net loads in about 5

I think its a combination of the listview and database access code both improved in .net

but anyways i think i got it for you

Dim dgtbcCity As New DataGridTextBoxColumn
            With dgtbcCity
                [b].NullText = "NO DATA"[/b]
                .HeaderText = "City"
                .MappingName = "loction_tbl.city"
                .NullText = ""
                .ReadOnly = True
            End With

sorry kleinma i guess i didn't explain it very well.. yea i know how to set if it's null data with the NullText... my problem is when it loads with the inner joins i can use, or should i say i don't know how to use, the mapping correctly to get the information to show up correctly... i also don't want to have the little + signs indicating the relationship between the tables... i woud like it to look like that of any datatable that is pulled up in something like access MySQL or SQL server... if i do an inner join and i want to see library name in the library table and the city it where the library is located, and the city is in a different table i want to use the inner join to get the information from both tables and display it in one line in the view.... i hope this makes a little better sense. sorry for the confusion.

[kleinma]

not sure if i can help you there then... try the listview.. and see if it really is that slow... maybe it wont be so bad

[vbdotnetboy]

yea that's the route i'm going to go. thanx again.