Help with Datagridviews

[Mike Fellows]

Hi,

Im populating a datagridview with a dataset using

datagridview.datasource = dataset.tables(0)

and this works fine in most cases, except when my dataset has multiple lines
of text in a single row

for example if i had an address stored as below:

street
address2
town
county
postcode
country

the above address would just show the intial line, my question is then how
do I get the datagridview to autosize on row height to show all the
available information

Thanks in advance

Mike Fellows

[Ken Tucker [MVP]]

Hi,

Here is a quick example. Set the datagridviews autosizerowsmode to
allcells
Dim strConn As String = _
"Server = .\SQLEXPRESS;Database = NorthWind; Integrated Security
= SSPI;"
Dim conn As New SqlConnection(strConn)
Dim da As New SqlDataAdapter("Select LastName, Notes from
Employees", conn)

da.Fill(dt)

DataGridView1.DataSource = dt
With DataGridView1.Columns("Notes")
.Width = 150
.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells
.DefaultCellStyle.WrapMode = DataGridViewTriState.True
End With

Ken
------------------------------------

"Mike Fellows" wrote:

Hi,

Im populating a datagridview with a dataset using

datagridview.datasource = dataset.tables(0)

and this works fine in most cases, except when my dataset has multiple lines
of text in a single row

for example if i had an address stored as below:

street
address2
town
county
postcode
country

the above address would just show the intial line, my question is then how
do I get the datagridview to autosize on row height to show all the
available information

Thanks in advance

Mike Fellows

[Mike Fellows]

Thanks Ken

Worked a treat

Cheers

Mike Fellows
"Ken Tucker [MVP]" <Ke**********@discussions.microsoft.com> wrote in message
news:65**********************************@microsof t.com...

Hi,

Here is a quick example. Set the datagridviews autosizerowsmode to
allcells
Dim strConn As String = _
"Server = .\SQLEXPRESS;Database = NorthWind; Integrated Security
= SSPI;"
Dim conn As New SqlConnection(strConn)
Dim da As New SqlDataAdapter("Select LastName, Notes from
Employees", conn)

da.Fill(dt)

DataGridView1.DataSource = dt
With DataGridView1.Columns("Notes")
.Width = 150
.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells
.DefaultCellStyle.WrapMode = DataGridViewTriState.True
End With

Ken
------------------------------------

"Mike Fellows" wrote:

Hi,

Im populating a datagridview with a dataset using

datagridview.datasource = dataset.tables(0)

and this works fine in most cases, except when my dataset has multiple
lines
of text in a single row

for example if i had an address stored as below:

street
address2
town
county
postcode
country

the above address would just show the intial line, my question is then
how
do I get the datagridview to autosize on row height to show all the
available information

Thanks in advance

Mike Fellows