Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...Get value from SQL tableGet value from SQL table
Previous
 
Next
New Post
11/24/2011 3:19 AM
 
Dear Sir/MadamIm very beginner to SQL ; i would like to use a table to store my integer number then i can call it in the c# program side.For example i write (int a=0 in c#) but in new program i want ( int a = specific row in specific column in my new table in sql) how can i call this SQL specific cell?As you know something like TOKEN.Please give me all code i should write to reach my purpose.Many Thanks for your Help Best Regards
 
New Post
11/24/2011 6:46 AM
 
if you are using module template from DNN starterkit, it comes with a handy sample demonstrating how to access database content. Besides, I suggest checking out "DotNetNuke 5.4 Cookbook", which includes useful module development tutorials.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
11/25/2011 3:25 PM
 
Dear Sebastian

Thanks about this advice.
Another problem that i have is ,( as you know) we can add some customize field in profile for user to fill them as they want to register, my question is that, where do they store on SQL table Or some where else.
I take a look at all sql table in User and Profile but i just find basic information such as name family and email and etc ... but there is not customize fields that administration crate .
Where are them?

Many Thanks
 
New Post
11/26/2011 5:15 AM
 
user profile property values are stored (serialized) in userprofile table, key profilepropertyId is taken from table propertydefinitions

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
11/27/2011 1:30 AM
 
Dear Sebastian Leupold

Thanks for your reply .
I saw propertydefinitions table and find the field , but i want to now where the user information will be stored?
For example if one user login and register in website and then the ID that portal give him is 9 ;
where is the information such as fax number , website and etc ..... stored?
I couldn't find any table that contain this kind of information about users !

Many Thanks
 
Previous
 
Next
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...Get value from SQL tableGet value from SQL table


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out