Q
Problem solve Get help with specific problems with your technologies, process and projects.

Need an ASP.NET page with a text box and submit button to pull records

Daniel Cazzulino
By
Published: 10 Jun 2004
I'm fairly new to the VS world and am looking to create to a simple search in an Access 2000 database, using ADO.NET. The database has a simple employee information table. Fields are SS#, Lastname, Firstname, etc. What I would like to do is create an ASP.NET page with a text box and submit button that a user can put their SS# into, hit submit and it returns a single record that corresponds to the SS# inputted by the user. SS# happens to be the primary key in the database. I can return all records fine using an OleDbDataAdapter and a DataSet. Just need a little help with the SQL statement to return only the records that match the SS#. Thanks!
Platform: WinXP Pro
If you're using the OleDbDataAdapter, most probably you have drag&dropped it in a form. Right-click it and select Configure Data Adapter. In the dialog for the SQL statement, enter something like the following: 
SELECT * FROM Employees WHERE SSN=@SSN
The code to fill the dataset should be:
oleDbDataAdapter1.SelectCommand.Parameters.Add("@SSN", this.txtSSN.Text); oleDbDataAdapter1.Fill(dataSet1);

This way you're passing the SSN parameter to the query before filling the dataset.

Dig Deeper on Win Development Resources

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Meet all of our Microsoft .Net Development experts

View all Microsoft .Net Development questions and answers

Start the conversation

Send me notifications when other members comment.

Register

Please create a username to comment.

-ADS BY GOOGLE

SearchCloudComputing

SearchSoftwareQuality

TheServerSide.com

SearchCloudApplications

Close