SQL / Datagrid

Hello there,
i′d like to know, in general, how would the code be to fill a datagrid ("datagridview1") with all datasets from a table ("Tbl_ausgaben") which is in the DB_AusgabenDataSet ?
I think there must be sth like SQLConnection ...?
Could any1 give me an exemple code or a link which could help me? Thank you very much! Bye, Mike
[349 byte] By [MS82] at [2008-2-7]
# 1
Hi,

You can try this walkthrough: http://msdn2.microsoft.com/wwh8ka92.aspx

Best regards,

HuyN_MS at 2007-9-8 > top of Msdn Tech,Visual Studio Express Editions,Visual Basic 2005 Express Edition...
# 2
Hi,
thank you for the link!
But its not exactly what i want to do is:
I have on a form a FlexGrid e.g., now , i′d like to fill this via a sql statement where i can declare "Where = <values of different comboboxes> as a filter.
But don′t know how to code this, how to connect to the database etc.
Best regards, Mike
MS82 at 2007-9-8 > top of Msdn Tech,Visual Studio Express Editions,Visual Basic 2005 Express Edition...
# 3

Hi,

Sorry for the late reply.

If you're using FlexGrid control, this article may help http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/html/vbconhflexgridcontrol.asp.

Microsoft ActiveX Data Objects 2.0 classes mentioned in this article can be found in Microsoft.VisualBasic.Compatibility.Data.dll. You can import this DLL to use in your project.

Best regards,

HuyN_MS at 2007-9-8 > top of Msdn Tech,Visual Studio Express Editions,Visual Basic 2005 Express Edition...