DataGrid view question

[Hueby]

Hey all, just wanted to say thanks for everyone's help on here...

So, I have a DataGrid that is being populated by a DataSet, and when it runs, what pops up in the left-upper corner of the dataGrid area is a grey box, with a arrow and + sign. When you click the + sign it opens another tab with "Hours" which I specified in my code posted below....

Once you hit Hours it brings up the DataSet with all my fields, etc... why is it not just bring that up in the first place???

Dim DsHours1 As New DataSet
        Dim cmdTime As New SqlCommand
 
Dim strTimeByDate As String = "SELECT * FROM Hours"
 
conbilling.Open()
 
        cmdTime.Connection = conbilling
        cmdTime.CommandText = strTimeByDate
 
        Dim daHours As New SqlDataAdapter(cmdTime)
        daHours.Fill(DsHours1, "Hours")
       grdHoursData.DataSource = DsHours1
 
        conbilling.Close()

[Qualm]

Hmmmmmmm try adding a line as follows:

grdHoursData.DataSource = DsHours1
grdHoursData.Refresh()

[Ritesh_jain1982]

Hi,

I think this will work....just try it..........


grdHoursData.DataSource = DsHours1

grdHoursData.Datamember = "Hours"

Regards,
Ritesh

[mar_zim]

Dim daHours As New SqlDataAdapter(cmdTime)
        daHours.Fill(DsHours1, "Hours")
       [b]grdHoursData.DataSource = DsHours1.Tables("Hours")[/b]
 
        conbilling.Close()

[mendhak]

Someone once told me that this was probably the most frequently asked question on the forums.

[mar_zim]

Originally posted by mendhak
Someone once told me that this was probably the most frequently asked question on the forums.

yup i also ask this one before..