Sql string to gridview

[John]

Hi

I have an sql string. What mechanism can I use to execute it and assign the
result to a gridview?

Thanks

Regards

[rowe_newsgroups]

On Jan 8, 6:08 am, "John" <[e-mail]:

Hi

I have an sql string. What mechanism can I use to execute it and assign the
result to a gridview?

Thanks

Regards

Against what type of datasource? Also, the objects you'll need most
likely reside in the System.Data namespace, so you might start
browsing through them in object browser and try to find the
appropriate classes.

Thanks,

Seth Rowe [MVP]

[John]

The actual database is access.

"rowe_newsgroups" <ro********@yahoo.comwrote in message
news:6d**********************************@p69g2000 hsa.googlegroups.com...

On Jan 8, 6:08 am, "John" <[e-mail]:

>Hi

I have an sql string. What mechanism can I use to execute it and assign
the
result to a gridview?

Thanks

Regards

Against what type of datasource? Also, the objects you'll need most
likely reside in the System.Data namespace, so you might start
browsing through them in object browser and try to find the
appropriate classes.

Thanks,

Seth Rowe [MVP]

[John]

Can I use Linq for example?

"rowe_newsgroups" <ro********@yahoo.comwrote in message
news:6d**********************************@p69g2000 hsa.googlegroups.com...

On Jan 8, 6:08 am, "John" <[e-mail]:

>Hi

I have an sql string. What mechanism can I use to execute it and assign
the
result to a gridview?

Thanks

Regards

Against what type of datasource? Also, the objects you'll need most
likely reside in the System.Data namespace, so you might start
browsing through them in object browser and try to find the
appropriate classes.

Thanks,

Seth Rowe [MVP]

[rowe_newsgroups]

Can I use Linq for example?

I wouldn't, I would use the OleDb components and access it like a
normal database.

Thanks,

Seth Rowe [MVP]

[Miha Markic]

Actually currently there is no way (out of the box) to query the access
database using LINQ.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"rowe_newsgroups" <ro********@yahoo.comwrote in message
news:6e**********************************@y5g2000h sf.googlegroups.com...

>Can I use Linq for example?

I wouldn't, I would use the OleDb components and access it like a
normal database.

Thanks,

Seth Rowe [MVP]

[John]

What oledb code can I use to accomplish this?

Thanks

Regards

"rowe_newsgroups" <ro********@yahoo.comwrote in message
news:6e**********************************@y5g2000h sf.googlegroups.com...

>Can I use Linq for example?

I wouldn't, I would use the OleDb components and access it like a
normal database.

Thanks,

Seth Rowe [MVP]

[Herfried K. Wagner [MVP]]

"John" <Jo**@nospam.infovis.co.ukschrieb:

>I wouldn't, I would use the OleDb components and access it like a
normal database.

What oledb code can I use to accomplish this?

How to use Microsoft Visual Basic .NET to connect to a Microsoft Access
database and to retrieve data
<URL:http://support.microsoft.com/?scid=kb;EN-US;821765>

Once you have the dataset containing the data, you can create a
'BindingSource' object, assign the 'DataSet' object to its 'DataSource'
property and then assign the binding source to the datagridview control's
'DataSource' property, for example.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>