473,659 Members | 2,839 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How Do I? - Access Database via Visual Studio 2005

Hello,

I have the following scenario and I was hoping that someone would help
me determine the best way to approach this situation in Visual Studio
2005:

1) I have questions in a database which I would like to display on a
form.
2) Along with the questions, I would like to display a series of
radio controls for the user to supply their input.
3) At the end of these series of questions and radio boxes, I would
like to display a command button. When the user clicks on this
command button, the database will be queried and the answers to the
questions will be displayed.

For example, the form would say:

------------------------------------------------------------------------------------------------------------------------
What is your favorite type of dog?
<radio1Beagle <radio2 Great Dane <radio3 Greyhound
<radio4 Other

What is your favorite type of cat?
<radio1Siames e <radio2 Persian <radio3 Hairless
<radio4 Other
------------------------------------------------------------------------------------------------------------------------

When the user highlights their choice via the radio button, and then
clicks on the SUBMIT Command Button, the form will display the
database results. For example:

------------------------------------------------------------------------------------------------------------------------
What is your favorite type of dog? You said: "Great Dane". Most
people The most popular choice was: "Beagle", chosen by 54% of
respondents.

What is your favorite type of cat? You said: "Hairless". Most
people The most popular choice was: "Siamese", chosen by 59% of
respondents.
------------------------------------------------------------------------------------------------------------------------

I see various types of controls, SQL Readers, Data Grids, etc. but
I'm wondering what would be the best way to do this in Visual Studio
2005? Does anyone have any "snippets" of code that does this that
they could post?

Thanks
Sam

Apr 17 '07 #1
1 1278
I'd try here for some samples:
http://www.asp101.com/samples/

<sa***********@ yahoo.cawrote in message
news:11******** **************@ n59g2000hsh.goo glegroups.com.. .
Hello,

I have the following scenario and I was hoping that someone would help
me determine the best way to approach this situation in Visual Studio
2005:

1) I have questions in a database which I would like to display on a
form.
2) Along with the questions, I would like to display a series of
radio controls for the user to supply their input.
3) At the end of these series of questions and radio boxes, I would
like to display a command button. When the user clicks on this
command button, the database will be queried and the answers to the
questions will be displayed.

For example, the form would say:

--------------------------------------------------------------------------
----------------------------------------------
What is your favorite type of dog?
<radio1Beagle <radio2 Great Dane <radio3 Greyhound
<radio4 Other

What is your favorite type of cat?
<radio1Siames e <radio2 Persian <radio3 Hairless
<radio4 Other
--------------------------------------------------------------------------
----------------------------------------------
>
When the user highlights their choice via the radio button, and then
clicks on the SUBMIT Command Button, the form will display the
database results. For example:

--------------------------------------------------------------------------
----------------------------------------------
What is your favorite type of dog? You said: "Great Dane". Most
people The most popular choice was: "Beagle", chosen by 54% of
respondents.

What is your favorite type of cat? You said: "Hairless". Most
people The most popular choice was: "Siamese", chosen by 59% of
respondents.
--------------------------------------------------------------------------
----------------------------------------------
>
I see various types of controls, SQL Readers, Data Grids, etc. but
I'm wondering what would be the best way to do this in Visual Studio
2005? Does anyone have any "snippets" of code that does this that
they could post?

Thanks
Sam

Apr 17 '07 #2

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

Similar topics

11
6816
by: olle | last post by:
Hi everyone. I am an Access developer having worked with Access-dev. projects for many years on Sql server databases and Access. For the internet I have been using traditional asp. But now I have tried asp.net and this tool seemes great to me. Haven't tried Vb for Visual Studio net, but hope to do that in the very future. Hope that this version of vb goes well together with asp.net although I don't know how.
33
5936
by: Uwe Range | last post by:
Hi to all! A customer of mine told me some days ago that her IT-people told her ACCESS would not be such a good idea for continuing with our project, because Access will not be continued in the future. I haven't heard of this. Does anybody know more about it? The IT-People usually prefer Oracle. If they really want to go in this direction, could our Access-application (if continued) be used as a front end with an Oracle back end? Does...
9
4966
by: Neil | last post by:
We have an Access 2000 MDB with a SQL 7 back end. We are upgrading SQL Server to SQL 2005, and are considering upgrading to Access 2003. Someone mentioned that they had heard about some incompatibilities between Access 2003 and SQL Server 2005. Anyone hear of anything? And, if so, would staying with Access 2000 be better? Thanks! Neil
18
9129
by: surfrat_ | last post by:
Hi, I am having the following problems in getting Microsoft Visual Studio 2005 Professional to link to an Access .mdb database. Please help me to sort this out. Problem 1: The Microsoft page "How to: Connect to Data in an Access Database"
5
2937
by: Ted | last post by:
I am working on two versions of an application, one of which will be a windows forms application (which will need to be redistributable) and the other will be a web application. I have MS Visual Studio 2005 (along with the developer's edition of MS SQL Server), but not MS Access. I also have MySQL, PostgreSQL, Sun's application server, Tomcat and Apache web server. I am working on Windows XP Pro, and have installed the .NET 3 SDK and...
5
2853
by: Mo | last post by:
Hello all, I'm trying to set up an access 2000 .adp project connecting to a SQL server 2005 database. I can set up the connection ok, but once I have completed the setup process, I get the following error messages if I try to create any new database objects: If I try to create a new object (a view or table etc), Access tells me that I:
9
1967
by: =?Utf-8?B?RnJpdHo=?= | last post by:
Hi all, I am having the following problems in getting Microsoft Visual Studio 2005 Professional to link to an Access .mdb database. Please help me to sort this out. Problem 1: ======= The Microsoft page "How to: Connect to Data in an Access Database
2
6214
by: raylopez99 | last post by:
I am trying to program a database from inside C++.NET via Visual Studio 2005 using the ADO.NET set of classes, but this I believe is a SQL Server 2005 Express permissions question under Windows XP Professional OS. In another thread, http://tinyurl.com/373lzx, I was able to open a database successfully using VS2005 (thanks to a suggestion by Erland Sommarskog). But subsequent to this I played around with the local policy permissons...
7
2016
by: Agos | last post by:
I developed my first web site using Visual studio 2005. It works very well with Visual Studio. But after I published the web site in a file system folder in my PC using the instructions I found in Visual studio help Walkthrough: Publishing a Web Site, I can navigate the web forms except the ones with connections (using Gridview, details view) to the database (SQL Server 2005). What didn't I do?
4
3148
by: Cindy H | last post by:
Hi I am currently using Visual Studio.Net 2003 running on Windows Server 2000 operating system. I have used Visual Studio.net 2003 connecting to Access 2002 databases in the pass with great success. Now, I have a need to go to Access 2007 which produces database.accdb file instead of database.mdb. I've used ole db Jet 4.0 to connect to Access 2002 in Visual Studio.Net 2003, now I guess you need to use Microsoft Ace 12.0 to make a...
0
8332
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8851
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
7356
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6179
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5649
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4175
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4335
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2750
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1737
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.