473,327 Members | 2,065 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

display 2 different datagrid using 2 database??

hi

im new in the .net environnement
i have a work to do in school

im able to display a datagrid using a database in access and im also able to display a datagrid using a database in foxpro 8.0

but i want to display in my browser the both datagrid in the same page, one using access db and the other with foxpro db.

how can i integrated the both in the same program?

.... i use the wordpad to put the instructions of my program and i save that in my localhost folder with the extension of .aspx

thank you very much!

--
pleymo - member
http://www.visual-basic-data-mining.net/forum
Nov 18 '05 #1
2 2820
1. Create two connection objects
2. Create two command objects ;using those conn objects
3. Create two data adapters using those command objects
4. Open both connections
5. Attach both data adapters to different tables in the same dataset
6. Bind each table to a different data grid

Optionally, you can link the Access database to the FoxPro, or perhaps visa versa, but you will have a perf hit for doing this.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside the box!
*************************************************
"ne**@visual-basic-data-mining.net" <si******@gmail.com> wrote in message news:%2****************@TK2MSFTNGP15.phx.gbl...
hi

im new in the .net environnement
i have a work to do in school

im able to display a datagrid using a database in access and im also able to display a datagrid using a database in foxpro 8.0

but i want to display in my browser the both datagrid in the same page, one using access db and the other with foxpro db.

how can i integrated the both in the same program?

... i use the wordpad to put the instructions of my program and i save that in my localhost folder with the extension of .aspx

thank you very much!

--
pleymo - member
http://www.visual-basic-data-mining.net/forum
Nov 18 '05 #2

"Cowboy (Gregory A. Beamer)" <No************@comcast.netNoSpamM> schrieb im Newsbeitrag news:%2***************@tk2msftngp13.phx.gbl...
1. Create two connection objects
2. Create two command objects ;using those conn objects
3. Create two data adapters using those command objects
4. Open both connections
5. Attach both data adapters to different tables in the same dataset
6. Bind each table to a different data grid

Optionally, you can link the Access database to the FoxPro, or perhaps visa versa, but you will have a perf hit for doing this.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside the box!
*************************************************
"ne**@visual-basic-data-mining.net" <si******@gmail.com> wrote in message news:%2****************@TK2MSFTNGP15.phx.gbl...
hi

im new in the .net environnement
i have a work to do in school

im able to display a datagrid using a database in access and im also able to display a datagrid using a database in foxpro 8.0

but i want to display in my browser the both datagrid in the same page, one using access db and the other with foxpro db.

how can i integrated the both in the same program?

... i use the wordpad to put the instructions of my program and i save that in my localhost folder with the extension of .aspx

thank you very much!

--
pleymo - member
http://www.visual-basic-data-mining.net/forum
Nov 18 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Chumley the Walrus | last post by:
IN my code behind .vb page for a delete records script (this also does a deletion confirmation with a javascript popup, this gets called on my front .aspx page with the datagrid), I'm not sure if...
2
by: anand | last post by:
Hello group, I using a datagrid to display output of a query, now the problem is that it displays all column of query in columns of grid, ( e. g.)is it possible that i fetch Employee name ,age...
3
by: Kai Zhang | last post by:
I am trying to display some database records in datagrid using dataset. the records need to be displayed are couple of thousands, but the records in database that the SQL query needs to exam are...
4
by: neena | last post by:
how to display values from database tables without using datagrid control in C# .net.I want to search the values from database & the search results to be shown as rows in the web form,without the use...
3
by: Eric Layman | last post by:
Hi, I've saved data into the db by doing a replace() on single quote. Right now on data display on a datagrid, it shows double single quote. How do I make changes during run time of datagrid...
2
by: pozze | last post by:
Hi, I need to display images and other record information retrieved from an SQL 2005 database in a datagrid on a web page. I'm coding in VB .net I have recently changed over from VB ASP and i'm...
2
by: Iain Wilson | last post by:
Hi Can anyone please advise if this is possible and if so how I would go about it (a pointer to an example would be greatly appreciated). Using C# - Web Application I have a DropDownList with...
2
by: simonyong | last post by:
hello, anyone.. im newbie to asp.net my problem is : My task is related to view all data from a table called "employee " i had create a datagrid where called data from database and...
2
by: kurtzky | last post by:
i created a form that should function as follows: i will enter a number in a textbox..then it should query from the database all the records which has that number..these records will have a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.