Click here to Skip to main content
Click here to Skip to main content

Tagged as

Using the ASP.NET SQLDATASOURCE

, 24 Dec 2013 CPOL
Rate this:
Please Sign up or sign in to vote.
How to use the ASP.NET SQLDATASOURCE

Introduction

Here, we are cooking up a small scale Search App Portal using the SQLDATASOURCE easy to use wizard with ASP.NET webforms.

One may use one's own search and display strategies for larger uses that may depend on the test results for efficiency.

The Search App Screen

Configuring the Connection String

The steps to bind the gridview are as follows:

Step 1

Step 2

Step 3

Steps to set the search filter using the ASP.NET controls for SelectParameters to build a criteria are given below: 

Creating the Filter aided by the easy to use Wizard

Step 1

Step 2

The Formed Criteria

Complete Criteria List

As formed in the SQLDATASOURCE Query with Select Parameters

Testing the formed query

The Demo Output Screen without paging/sorting

Conclusion

Things were very simple and guided if one were to manage a small application using the available features. But there may be greater challenges awaiting one as things become more dynamic. There is scope for a part II for this tiny application. Including paging.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

No Biography provided

Comments and Discussions

 
GeneralMy vote of 1 PinprofessionalAntonio Ripa25-Dec-13 3:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.150327.1 | Last Updated 24 Dec 2013
Article Copyright 2013 by Member 4296147
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid