New asp page for search

[ozarka]

I would like to create a asp.net page where user will input account number and click on "Search" button. The result should come from a mdb table.

I am using this query and i need to replace this with asp because we dont want to install small mdb apps on user machine.

SELECT all_pages.*
FROM all_pages
WHERE all_pages.id=[Enter Account ID]

I have never done asp.net but please do not refer me a new tutorial page. I would appreciate some links on this type of topic or some good answers.

Thanks

[Shashi Sadasivan]

I would like to create a asp.net page where user will input account number and click on "Search" button. The result should come from a mdb table.

I am using this query and i need to replace this with asp because we dont want to install small mdb apps on user machine.

SELECT all_pages.*
FROM all_pages
WHERE all_pages.id=[Enter Account ID]

I have never done asp.net but please do not refer me a new tutorial page. I would appreciate some links on this type of topic or some good answers.

Thanks

Hi,
Seems that you already have experience using windows application (because you want to replace the system to asp .net)
Is sql server your back end?
have you created datasets?
There are a few options you can try.
1. Custom write queries in your commandText and then execute them
2. Add queries during design time to the datadesigner
3. Add stored procedures to your database, and then add them either during design time or run time.

Things would be easier if you are using SQl server for your DB

[ozarka]

Hi there,

Thank you very very much for responding to my post.

1. Yes, I do have vb and ms-access background. Backend is mdb (msaccess db) but it will migrate to oracle.
2. Dataset (table has been created). See my sql for table and field name.
3. Do I need to have MS visual studio in order for me to create just 1 or 2 asp.net pages?
4. All I want user to input account id and click on "Search". Display the record Upon clicking the "Search". Display "no record found" if leave it blank or not found in the db.

Thanks

[Shashi Sadasivan]

Hi,
Well, If you do onot wat to use Visual studio..... you would be asking for a lot of trouble coding every page.
there is a lot of design code which visual studio does it for you.

Download the Visual web developer express package - which is a free edition.
It helps a lot to make the pages quicker.

once you have the page ready, you can send a sql command as a text, the text would depend if there is something entered in the textbox.