DataGrid Advice

I have created an app that uses an Access Database ( or is trying to ).

The problem is, is that I do not know the Access Database name ( mdb file
name ) until the program is running.

Im starting to realize that creating something like a datagrid where
everything can be clicked thru and properties has to be done manually and
all thru code.

My book gives examples on how to do everything with the VB objects, and im
finding it tuff to slowely get the "By Code" working. - And this is
only my first form. I am dreading doing this thru every form.

Thanks

Miro

Miro wrote:
> I have created an app that uses an Access Database ( or is trying to ).
>
> The problem is, is that I do not know the Access Database name ( mdb file
> name ) until the program is running.
>
> Im starting to realize that creating something like a datagrid where
> everything can be clicked thru and properties has to be done manually and
> all thru code.
<snip>

If the databases you must open have the same structure, I suppose you
can use one at design time just to create the UI -- including grid
cols and the like -- and assign the run-time Dataset associated with
the real db to the BindingSource's DataSource that VB automagically
created for you (and that drives the Grid). Never tried, though.

HTH.

Regards,

Branco.

Miro,

It is in this sample
http://www.vb-tips.com/dbpages.aspx...57-7bc3068aca2c

Cor

"Miro" <mironagy@golden.net> schreef in bericht
news:OwlHQFzTHHA.4956@TK2MSFTNGP04.phx.gbl...
>I have created an app that uses an Access Database ( or is trying to ).
>
> The problem is, is that I do not know the Access Database name ( mdb file
> name ) until the program is running.
>
> Im starting to realize that creating something like a datagrid where
> everything can be clicked thru and properties has to be done manually and
> all thru code.
>
> My book gives examples on how to do everything with the VB objects, and im
> finding it tuff to slowely get the "By Code" working. - And this is
> only my first form. I am dreading doing this thru every form.
>
> Thanks
>
> Miro
>

just keep on using Access; it is faster and easier; .NET doesn't run
on _ANY_ desktops so don't bother

yeah it is all MANUAL

welcome to visual fred; I ****ing hate it STILL

I woke up this morning after dreaming this solution in my head. I will try
it.

Thanks

Miro

"Branco Medeiros" <branco.medeiros@gmail.com> wrote in message
news:1171346400.184306.319310@j27g2000cwj.googlegroups.com...
> Miro wrote:
>> I have created an app that uses an Access Database ( or is trying to ).
>>
>> The problem is, is that I do not know the Access Database name ( mdb file
>> name ) until the program is running.
>>
>> Im starting to realize that creating something like a datagrid where
>> everything can be clicked thru and properties has to be done manually and
>> all thru code.
> <snip>
>
> If the databases you must open have the same structure, I suppose you
> can use one at design time just to create the UI -- including grid
> cols and the like -- and assign the run-time Dataset associated with
> the real db to the BindingSource's DataSource that VB automagically
> created for you (and that drives the Grid). Never tried, though.
>
> HTH.
>
> Regards,
>
> Branco.
>

Thank you Cor,

I will try your meathod here and also Branco's and see which one works out
best for me in the end.

Miro

"Cor Ligthert [MVP]" <notmyfirstname@planet.nl> wrote in message
news:emDWrizTHHA.1200@TK2MSFTNGP04.phx.gbl...
> Miro,
>
> It is in this sample
> http://www.vb-tips.com/dbpages.aspx...57-7bc3068aca2c
>
> Cor
>
> "Miro" <mironagy@golden.net> schreef in bericht
> news:OwlHQFzTHHA.4956@TK2MSFTNGP04.phx.gbl...
>>I have created an app that uses an Access Database ( or is trying to ).
>>
>> The problem is, is that I do not know the Access Database name ( mdb file
>> name ) until the program is running.
>>
>> Im starting to realize that creating something like a datagrid where
>> everything can be clicked thru and properties has to be done manually and
>> all thru code.
>>
>> My book gives examples on how to do everything with the VB objects, and
>> im finding it tuff to slowely get the "By Code" working. - And this is
>> only my first form. I am dreading doing this thru every form.
>>
>> Thanks
>>
>> Miro
>>
>
>

I found the answer to what I was looking for.
Search this newsgroup for a title

Re: 2005 Express OleDbConnection - Solved

Very simple really.
Thanks for your help.

Miro

"Miro" <mironagy@golden.net> wrote in message
news:%23Yw3742THHA.4832@TK2MSFTNGP04.phx.gbl...
>I woke up this morning after dreaming this solution in my head. I will try
>it.
>
> Thanks
>
> Miro
>
> "Branco Medeiros" <branco.medeiros@gmail.com> wrote in message
> news:1171346400.184306.319310@j27g2000cwj.googlegroups.com...
>> Miro wrote:
>>> I have created an app that uses an Access Database ( or is trying to ).
>>>
>>> The problem is, is that I do not know the Access Database name ( mdb
>>> file
>>> name ) until the program is running.
>>>
>>> Im starting to realize that creating something like a datagrid where
>>> everything can be clicked thru and properties has to be done manually
>>> and
>>> all thru code.
>> <snip>
>>
>> If the databases you must open have the same structure, I suppose you
>> can use one at design time just to create the UI -- including grid
>> cols and the like -- and assign the run-time Dataset associated with
>> the real db to the BindingSource's DataSource that VB automagically
>> created for you (and that drives the Grid). Never tried, though.
>>
>> HTH.
>>
>> Regards,
>>
>> Branco.
>>
>
>