davidaperry69
Member
- Joined
- Feb 15, 2007
- Messages
- 7
- Programming Experience
- Beginner
I am trying to write a very simple web application that can lookup a name in a simple access database that has about 500 records. I want to be able to type a name and then click on a lookup button and then the application can display the rest of the fields for that name. eg name, address, phone and email.
The access database only has four fields, name, address, phone number and email address. How do I do this. I recenlty took an ASP class online, and ASP has some built in forms like grid view that do everything anutomatically.
But that is for a web application, I need to write something in the regular Visual Studio.net. So that I can compile it and send it to other co-workers as an executable application.
I just downloaded Visual Studio and I setup a new form called form1 and I added a simple texbox for input of the name and a button called lookup.
Next I added a datagrid view box and connected it to my database to pull up the information for whichever name that is entered in the textbox. I am not sure if this is the best method, but I think I remember doing something simular when I took my VB class.
My Database is called DB1 and the table is called customers.
So now when I click on the button, I am not sure what code I need to write. Honestly I took a VB class almost 5 years ago. So forgot how to start writing the code for the button click event.
Any help will be appreciated. I wish I still had my old textbook.
The access database only has four fields, name, address, phone number and email address. How do I do this. I recenlty took an ASP class online, and ASP has some built in forms like grid view that do everything anutomatically.
But that is for a web application, I need to write something in the regular Visual Studio.net. So that I can compile it and send it to other co-workers as an executable application.
I just downloaded Visual Studio and I setup a new form called form1 and I added a simple texbox for input of the name and a button called lookup.
Next I added a datagrid view box and connected it to my database to pull up the information for whichever name that is entered in the textbox. I am not sure if this is the best method, but I think I remember doing something simular when I took my VB class.
My Database is called DB1 and the table is called customers.
So now when I click on the button, I am not sure what code I need to write. Honestly I took a VB class almost 5 years ago. So forgot how to start writing the code for the button click event.
Any help will be appreciated. I wish I still had my old textbook.