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 (48)

  • 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

  • Payday Loans Chicago

    The cash is given as a loan and is specifically saved into your own financial records, after which the loan reserves, in addition to a charge, are removed from your record toward the finish of the credit which more often than not is your next payday. Payday Loans Chicago

  • james cook

    Great post! I am actually getting ready to across this information, is very helpful my friend. Also great blog here with all of the valuable information you have. Keep up the good work you are doing here.
    myassignmenthelp reviews

  • Norton Ghost Clone Hard Drive

    Extremely decent blog on this site. It is extremely hard to get this sort of with helpful data. I am assuaged I happened upon this site in the event that you have any issue with Norton then you call your Norton Ghost Clone Hard Drive +18555583999.

  • Roadrunner Password Recovery

    Nice post.
    If you forgot your roadrunner email password and troubling in Roadrunner Password Recovery then contact roadrunner toll free number +1-888-338-6033.

  • QuickBooks System Requirements

    Thank you for sharing such a brilliant and beneficial article. we are imparting decision associated with circulating QuickBooks System Requirements. If anyone dealing with problem related to QuickBooks System Requirements.So you can directly call us at our QuickBooks Help +1-877-249-9444.

  • Hatta desert safari deals

    *Aw, this was a really nice post.hatta desert safari deals In idea I would like to put in writing like this additionally ? taking time and actual effort to make a very good article? but what can I say? I procrastinate alot and by no means seem to get something done.

  • Musandam Deals

    *Hello! I just would like to give a huge thumbs up for the great info you have here on this post. I will be coming back to your blog for more soon.musandam deals
    Regards:
    https://dubaidesertsafariuae.com/

  • cheap taxi nottingham

    I am often to blogging and i really appreciate your content.cheap taxi nottingham The article has really peaks my interest. I am going to bookmark your site and keep checking for new information.

  • Dale

    STIGA's reputation for high-quality ping pong products, ping pong table reviews yet in between the attributes of this table.

  • central taxi nottingham

    central taxi nottinghamSays, This is very nice post. I was very pleased to find this web-site.I wanted to thanks for your time for this wonderful read!! I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you blog post.

Leave a comment

2000 character(s) remaining. Comment limited to 2000 characters.
Post Comment
Support
Search
Calendar
Categories
Archives
Most
  • Photo Editing Services says: Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts.

    Nov 12, 2018
  • jacob says: Thanks a lot for one’s intriguing write-up. It’s actually exceptional. Searching ahead for this sort of revisions.
    images of happy valentines day

    Nov 11, 2018
  • Action games says: This article gives the light in which we can observe the reality. This is very nice one and gives indepth information. Thanks for this nice article. Action games

    Nov 10, 2018
  • how to install blinds says: wow... what a great blog, this writter who wrote this article it's realy a great blogger, this article so inspiring me to be a better person how to install blinds,

    Nov 08, 2018
  • health insurance verification says: Thanks a lot for one’s intriguing write-up. It’s actually exceptional. Searching ahead for this sort of revisions. health insurance verification

    Nov 07, 2018
  • military patches says: This is very useful post for me. This will absolutely going to help me in my project.

    Nov 05, 2018
Home   |   EffectCollection   |   DNNSmart Store   |   Free Downloads   |   Support   |   Service
Quick Contact