Items: 0 Total: $0
en-USzh-CN
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 (26)

  • 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

Leave a comment

2000 character(s) remaining. Comment limited to 2000 characters.
Post Comment
Support
Search
Calendar
Categories
Archives
Most
  • Questions to Ask a Guy says: I really impressed after read this because of some quality work and informative thoughts . I just wanna say thanks for the writer and wish you all the best for coming!. Questions to Ask a Guy

    Jan 14, 2018
  • Questions to Ask a Guy says: I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often. Questions to Ask a Guy

    Jan 14, 2018
  • Questions to Ask a Guy says: Good website! I truly love how it is easy on my eyes it is. I am wondering how I might be notified whenever a new post has been made. I have subscribed to your RSS which may do the trick? Have a great day! Questions to Ask a Guy

    Jan 14, 2018
  • Benefits of Cucumber says: Great content material and great layout. Your website deserves all of the positive feedback it’s been getting.

    Jan 13, 2018
  • Benefits of Cucumber says: I admire what you have done here. I like the part where you say you are doing this to give back but I would assume by all the comments that this is working for you as well. Benefits of Cucumber

    Jan 13, 2018
  • Benefits of Cucumber says: I admire what you have done here. I like the part where you say you are doing this to give back but I would assume by all the comments that this is working for you as well. Benefits of Cucumber

    Jan 13, 2018
Home   |   EffectCollection   |   DNNSmart Store   |   Free Downloads   |   Support   |   Service
Quick Contact