Hi everyone!!!!!

I have two Forms Form1 and Form2.
On form One I have a command button which is called View. On Form2 I have a Datagrid. What I would like to do is when click the command on form one called View Form 2 would load. Which I already have this codes. When Form 2 load up I would like to retrive the Data from my Access table Called ADP. This is where I need help connecting to Access and the codes to load the table on form 2           

[Edited by ozzy on 16-05-2003 at 07:34 PM GMT]

So you need to load the data from your access table into a datagrid?

If you are using the "DBGrid" or "DataGrid", it is designed to be bound to another data control/source (i.e., an ADODC or a Data Environment)...simply add an ADODC control to your form (and set its data properties to your Access database) then set the DBGrid's DataSource property to the ADODC. The "Datagrid" control is similar to the "DBGrid", but does not support being "unbound".

____________________________
Eggheads unite! You have nothing to lose but your yolks.

quote:

---

~Bean~ wrote:
So you need to load the data from your access table into a datagrid?

If you are using the "DBGrid" or "DataGrid", it is designed to be bound to another data control/source (i.e., an ADODC or a Data Environment)...simply add an ADODC control to your form (and set its data properties to your Access database) then set the DBGrid's DataSource property to the ADODC. The "Datagrid" control is similar to the "DBGrid", but does not support being "unbound".

---

If I understand your problem, you should not need any code. The ADODC will open the connection without any code(once you have set it's database properties), and the Datagrid will populate with data from the ADODC without any code (once you have set it's datasource property).

____________________________
Eggheads unite! You have nothing to lose but your yolks.

quote:

---

~Bean~ wrote:
If I understand your problem, you should not need any code. The ADODC will open the connection without any code(once you have set it's database properties), and the Datagrid will populate with data from the ADODC without any code (once you have set it's datasource property).

---

I am not familiar enough with VB.NET to help you further...I know some controls, such as the Date/Time Picker, have trouble displaying null values...but why your other fields like User, etc. would be showing that is beyond me...the datagrid control 6.0 I use displays null dates/times as blanks, not as "NULL".  

____________________________
Eggheads unite! You have nothing to lose but your yolks.

quote:

---

~Bean~ wrote:
I am not familiar enough with VB.NET to help you further...I know some controls, such as the Date/Time Picker, have trouble displaying null values...but why your other fields like User, etc. would be showing that is beyond me...the datagrid control 6.0 I use displays null dates/times as blanks, not as "NULL".  

---

e-mail me anytime. I will continue to check this thread as well in case I can help...in the meantime...maybe you can help me!?!

...I installed my VB.NET last night just for you! lol...and I tried to duplicate the problem you have. HAH! I can't even get the datasource of the Datagrid set...this will not set in design view (?) what code are you using to do this? "SetBindings"?

____________________________
Eggheads unite! You have nothing to lose but your yolks.