DataGrid SUCKS!

[Tom Holmes Jr.]

Does anyone else have an issue with the datagrid?

My complaints are:
1) it is much harder to change the column style, row style, or cell style
without going through a lot of hoops.

2) bind datagrid tables have to involve a dataset, datatable adapter, and a
binding source ...

3) I have little or no control over how the columns are displayed or
formatted when it is bound .... typical ...

I have seen examples all over Google about how to deal with it ... they are
all less than stellar and the links back to MS are horrible.

In the past 20 years dealing with grids have been good and bad ... I've
often used third party ones that just got the simple work done
that I needed to do. Has MS not learned anything in the past 20 years or
so?????????????

Sooooo ... I'd just like to use the DataGrid in a completely NON-BOUND way
.... that way I can create my own connection,
organize my data the way I want, format it the way I want ... then I can
just iterate through the resultset and load the data into the grid.

Does anyone have any examples of this, or know where I can find some????
And yes I will keep looking via Google ....

Thanks!
Tom

p.s. Maybe someone knows of a better grid than the one provided from VB.NET
pro edition?

[John Timney \(MVP\)]

Personally, I think gridview saves you loads of time - but you can do it all
manually

http://forums.asp.net/p/1020163/1379019.aspx

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog
"Tom Holmes Jr." <to*@tomholmes.netwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...

Does anyone else have an issue with the datagrid?

My complaints are:
1) it is much harder to change the column style, row style, or cell style
without going through a lot of hoops.

2) bind datagrid tables have to involve a dataset, datatable adapter, and
a binding source ...

3) I have little or no control over how the columns are displayed or
formatted when it is bound .... typical ...

I have seen examples all over Google about how to deal with it ... they
are all less than stellar and the links back to MS are horrible.

In the past 20 years dealing with grids have been good and bad ... I've
often used third party ones that just got the simple work done
that I needed to do. Has MS not learned anything in the past 20 years
or so?????????????

Sooooo ... I'd just like to use the DataGrid in a completely NON-BOUND way
... that way I can create my own connection,
organize my data the way I want, format it the way I want ... then I can
just iterate through the resultset and load the data into the grid.

Does anyone have any examples of this, or know where I can find some????
And yes I will keep looking via Google ....

Thanks!
Tom

p.s. Maybe someone knows of a better grid than the one provided from
VB.NET pro edition?

[Cor Ligthert[MVP]]

Tom,

Why don't you then not using the DataGridView, as I have the idea you are
talking about windows forms applications. Giving some more information
mostly will help.

Just telling that something is not good in your eyes interest almost nobody
here. We are not waiting to see you (using another connection of course) or
others promote their articles here with an introducion that something is not
good. That we have seen to often.

However if you have complaints, this website is for complaints about
Microsoft products.

http://connect.microsoft.com/

Cor

[Patrice]

Which version ? If 2.0 try the DataGridView instead. See
http://msdn2.microsoft.com/en-us/lib...28(VS.80).aspx for details...
If not sufficient you'll have to rely on third party controls....

--
Patrice

ADAIK The DataDrid is still therre for legacy...
"Tom Holmes Jr." <to*@tomholmes.neta écrit dans le message de news:
%2****************@TK2MSFTNGP04.phx.gbl...

Does anyone else have an issue with the datagrid?

My complaints are:
1) it is much harder to change the column style, row style, or cell style
without going through a lot of hoops.

2) bind datagrid tables have to involve a dataset, datatable adapter, and
a binding source ...

3) I have little or no control over how the columns are displayed or
formatted when it is bound .... typical ...

I have seen examples all over Google about how to deal with it ... they
are all less than stellar and the links back to MS are horrible.

In the past 20 years dealing with grids have been good and bad ... I've
often used third party ones that just got the simple work done
that I needed to do. Has MS not learned anything in the past 20 years
or so?????????????

Sooooo ... I'd just like to use the DataGrid in a completely NON-BOUND way
... that way I can create my own connection,
organize my data the way I want, format it the way I want ... then I can
just iterate through the resultset and load the data into the grid.

Does anyone have any examples of this, or know where I can find some????
And yes I will keep looking via Google ....

Thanks!
Tom

p.s. Maybe someone knows of a better grid than the one provided from
VB.NET pro edition?

[Tom Holmes Jr.]

Thanks for the help John, the link was somewhat helpful. At least it gave
me an idea on how I wanted to go.
As has been said ... some of these Wizard/Design tools just put a lot of
crap in the application.
Then when you go to change something, everything breaks .... that's why I
like writing ALL my code and not relying on Wizards/Designers.
That's something I learned a long time ago in the MS World.

Anyway, the link listed below is kinda outdated. When I cut and pasted
that code into my app ... have the classes I couldn't find.
I bet it if it was a Windows/Desktop application, then the classes would
have existed, but since I was working on a PPC WM 5.0 application, then you
can't do OLEDB database connections. Again, I couldn't find those classes
to add.

In any event, I have a new question about the datagrid and manual creation.
With a single table in single "SELECT" sql statement, it works fine. My
next SQL query for my next grid uses a "UNION"

SELECT field1, field2, field3 FROM TableA
UNION
SELECT field1, field2, field3 FROM TableB

The query itself works fine, but when I look for DataSet.Tables(0) ... it
doesn't exist ...
I don't want to have to add both sets of data into one table ... but maybe I
can create a view in the SQL Compact Edition SDF file ...

Any help would be much appreciated! Thanks!

Tom
"John Timney (MVP)" <xy******@timney.eclipse.co.ukwrote in message
news:7Z*********************@eclipse.net.uk...

Personally, I think gridview saves you loads of time - but you can do it
all manually

http://forums.asp.net/p/1020163/1379019.aspx

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog
"Tom Holmes Jr." <to*@tomholmes.netwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...

>Does anyone else have an issue with the datagrid?

My complaints are:
1) it is much harder to change the column style, row style, or cell style
without going through a lot of hoops.

2) bind datagrid tables have to involve a dataset, datatable adapter, and
a binding source ...

3) I have little or no control over how the columns are displayed or
formatted when it is bound .... typical ...

I have seen examples all over Google about how to deal with it ... they
are all less than stellar and the links back to MS are horrible.

In the past 20 years dealing with grids have been good and bad ... I've
often used third party ones that just got the simple work done
that I needed to do. Has MS not learned anything in the past 20 years
or so?????????????

Sooooo ... I'd just like to use the DataGrid in a completely NON-BOUND
way ... that way I can create my own connection,
organize my data the way I want, format it the way I want ... then I can
just iterate through the resultset and load the data into the grid.

Does anyone have any examples of this, or know where I can find some????
And yes I will keep looking via Google ....

Thanks!
Tom

p.s. Maybe someone knows of a better grid than the one provided from
VB.NET pro edition?