Simple Question

[Gacu]

Hi,

Sorry for a lame question, but i'm a newbie

I'm connecting to Firebird database using .net data provider. What's the
fastest and simplest way of puting rows from sql query into DataGrid on the
form ?

Thanx.

Gacu

 

[clintonG]

Data Reader is easiest and fastest but is forward read-only.

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET (e-mail address removed)
URL http://www.metromilwaukee.com/clintongallagher/

 

[Dmitriy Lapshin [C# / .NET MVP]]

Hi Gacu,

I'd recommend using the DataAdapter. Please refer to the following MSDN
topic for details:

"Populating a DataSet from a DataAdapter"

When the DataSet is populated, you should bind the data grid to that
DataSet.
With the WinForms datagrid, use the SetDataBinding method to do that.

 

[RBisch]

I agree by using the DataAdapter, plus I believe a DataReader (fast) is used
behind the scenes.