Items: 0 Total: $0
en-USzh-CNes-ES
Search
You are here:Support  >  Articles
Articles
For this article, it will teach you how to make Dropdown list, checkbox list, radiobutton list and listbox these four kinds of controls get data from database via one SQL query.
For this article, it will teach you how to make Dropdown list, checkbox list, radiobutton list and listbox these four kinds of controls get data from database via one SQL query.

For example, you have five fields Name, Sql Dropdown, Sql Checkbox list, Sql Radiobutton list, Sql Listbox in your form.
And you want to read data from Users table of database, username as Item Text, UserID as Item Value.


Configuration Steps
1. Firstly, you need to enter Management Center -> Step Wizard page and then click “Add A New Step” to add one Step. Finally, please click “Add A New Filed” button.


2.In Title, please enter ”Sql Dropdown” and choose “Drop-down List” for “Control Type” option. Finally, please enter following sql sentence in “Value” option.
[SQL]select username,userid from users

Please note, you need to enter [SQL] Token in the head of Value Textbox. In this way, programming will execute sql query behind [SQL] Token. First field of Sql query represents Text in Dropdownlist, second field represents Value in Dropdownlist.

Configuration method of checkbox list, radiobutton list and listbox controls is the same with Dropdownlist.


3. After you finished configuration, you will see following interface in the front-end.

Below, you will find download link for xml configuration file of form. You can go to Management Center -> Copy Form page and import it. In this way, you will get this form instantly.

read_data_from_sql_query_config.xml
about author

Joshua Bright

Developer

Although DNNSmart was newly founded in August 2012, we devoted to DNN development work since 2008. We specializes on the DotNetNuke (DNN) Content Management System including DNN skin design, DNN programming and website construction. Our development team is located in China, our professional and outstanding developers are passionate about web design, programming and web applications.

Comments (38)

  • Amity Taylor

    Some of that ought to be taken care of with your scripting dialect before being gone to SQL.Buy Assignment Online Fundamentally, you can instruct it to utilize a "constantly genuine" explanation when "Any" is chosen, so that the inquiry will keep on giving you the right results, without giving you an excess of inconvenience.

    • Rockyr

      SQL Data person who reads substance consent to you to understand writing data in a fast forward-only approach. pay for written essays You get hold of data by understanding every one row from the data watercourse. Call the put up the shutters.

      • Emily Brown

        This informative post will teach us How to Read Data from SQL Query. Thanks for sharing here Configuration Steps of how to create Dropdown list, radiobutton list, checkbox list, and listbox and how to get controls data from database to create this box via one SQL query which are very useful post for IT learners who are in search of economics dissertation services from dissertation experts at Dissertation Help UK where I am providing profession guidance to get dream job and academic services to UK students. Looking forward to read more such articles. Keep Sharing!

    • Chandra

      Very well written on SQL queries. I am learning oracle database and this helps me a lot. I am actually trying to find the snapdeal product sales by running queries. And this helps me a lot.

  • JohnEdward

    Sql Data Reader objects allow you to read data in a fast forward-only manner. You obtain data by reading each row from the data stream. write my dissertation for me. Call the Close method of the Sql Data Reader to ensure there are not any resource leaks.

    • Chandra

      I am learning oracle database and this helps me a lot. I am actually trying to find the snapdeal product sales by running queries. And this helps me a lot.

  • Daniel Jorden

    Thoughtful how SQL installation can help you generate enhanced queries, and can make it easier for you to research paper help online recognize how to attach a query that is not persistent the results that you desire.

  • Ken Emede

    I havent any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. Ken Emede

  • EssayAvenue

    I by and large used to utilize a SQLDataReader in a while circle (While SQLDataReader.Read). As of late I've begun utilizing CSLA.NET and thought that it was exceptionally valuable; populate your gridview with youngster protests in a parent rundown, and give every kid question its own particular DataFetch technique.

  • Dissertation Help UK

    This enlightening post will show us How to Read Data from SQL Query. A debt of gratitude is in order for sharing here Configuration Steps of how to make Dropdown list, radiobutton list, checkbox list, and listbox and how to get controls information from database to make this case by means of one SQL inquiry which are exceptionally valuable post for IT students who are looking for financial aspects exposition administrations from thesis specialists at where I am giving calling direction to land dream position and scholastic administrations to UK understudies. Anticipating read all the more such articles. Continue Sharing!

  • Do my Assignment for me

    Sql Data Reader objects enable you to peruse information in a quick forward-just way. You get information by perusing each column from the information stream. Call the Close strategy for the Sql Data Reader to guarantee there are no asset spills.

  • Can Someone Do my Coursework

    SQL Data individual who peruses substance agree to you to comprehend composing information in a quick forward-just approach. You get hold of information by seeing each one column from the information waterway. Ring the put the shades.

  • Assignment writing service in UK

    Thanks for such a nice piece of information. I am glad to read this. Please review my page
    Assignment Help UK

  • Lily

    In any case, for a decent number of lamentable borrowers, the circumstance unfurls in an alternate and far less lovely way. Check Cashing

  • unitedcheckcashing.com

    It may be very onerous to mention once exactly ought to be pressured to cash your test.

  • Garage door Lubbock

    Great post, you have pointed out some excellent points, I as well believe this is a very superb website.

  • avenir amoureux gratuit

    Great post, you have pointed out some excellent points, I as well believe this is a very superb website. avenir amoureux gratuit

  • Pomegranates

    Great knowledge, do anyone mind merely reference back to it Pomegranates

  • Robinjack

    I gotta most loved this site it appears to be exceptionally useful . 68films.com

  • Robinjack

    I read that Post and got it fine and enlightening. If you don't mind share more like that... internet marketing services

  • Robinjack

    i read a ton of stuff and i found that the method for composing to clearifing that precisely need to say was great so i am awed and ilike to come back again in future.. construction clean up roofing homosassa

  • Robinjack

    Pleasant post. I was checking continually this online journal and I am awed! Greatly accommodating data uniquely the last part I nurture such information a considerable measure. I was looking for this specific data for quite a while. Much obliged to you and good fortunes. satta matka lucky number

  • Robinjack

    The site is looking piece conspicuous and it gets the guests eyes. Configuration is really basic and a decent easy to understand interface. kalyan chart

  • Robinjack

    You know your tasks emerge of the crowd. There is something exceptional about them. It appears to me every one of them are truly splendid! satta

  • ASD

    I high appreciate this post. It’s hard to find the good from the bad sometimes, but I think you’ve nailed it! would you mind updating your blog with more information? europafoodxb

  • ASD

    This is my first time i visit here. I discovered such a large number of fascinating stuff in your web journal particularly its examination. From the huge amounts of remarks on your articles, I figure I am not by any means the only one having all the happiness here! keep doing awesome Keyword: Supplements

  • ASD

    This is my first time i visit here. I discovered such a large number of fascinating stuff in your web journal particularly its examination. From the huge amounts of remarks on your articles, I figure I am not by any means the only one having all the happiness here! keep doing awesome Keyword: Supplements

  • Ameer Hamza

    Thanks for this see our website what is the best vacuum for pet hair easily.

  • daniel jusin

    Thanks for this [url="http://bestechub.com/best-all-in-one-printer/"]see more printers[/url]

  • ronald mill

    Thanks for this get more info

  • ronald mill

    Thanks for this see more printers

  • maxwell john

    Thanks for this pick best cameras

  • A.hamza

    clash of kingdoms - clashofkingsmod

  • A.hamza

    national puppy day activities

  • Dr Sara

    I got good info from your blog Sinus Infections and remedies

  • Gearbest Black Friday

    Thanks for sharing the post.. parents are worlds best person in each lives of individual..they need or must succeed to sustain needs of the family. Gearbest Black Friday

  • cheap desert safari

    very nice post, i certainly love this website, keep on it cheap desert safari

Leave a comment

2000 character(s) remaining. Comment limited to 2000 characters.
Post Comment
Support
Search
Calendar
Categories
Archives
Most
  • cheap desert safari says: very nice post, i certainly love this website, keep on it cheap desert safari

    13 hours ago
  • Happy Mothers Day 2018 says: A good blog always comes-up with new and exciting information and while reading I have feel that this blog is really have all those quality that qualify a blog to be a one.

    Apr 24, 2018
  • Ramadan Calendar 201 says: I curious more interest in some of them hope you will give more information on this topics in your next articles. Ramadan Calendar 2018

    Apr 24, 2018
  • baby crib says: Your blog provided us with valuable information to work with. Each & every tips of your post are awesome. Thanks a lot for sharing. Keep blogging,

    Apr 22, 2018
  • email template says: Thanks for providing recent updates regarding the concern, I look forward to read more.

    Apr 22, 2018
  • Rosenhain says: Enter your Activation username and password. parentpaylogin.com saved in any kind of component of the system.

    Apr 20, 2018
Home   |   EffectCollection   |   DNNSmart Store   |   Free Downloads   |   Support   |   Service
Quick Contact