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

HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Understanding Booleans?Understanding Booleans?
Previous
 
Next
New Post
8/1/2007 1:28 PM
 



Familiar with int (Integer) & characters (nvarchar), but want to get to understand booleans (bit) and more...
What I am primarily focused on is getting a boolean column within sql. Then I can dabble with using the boolean.
Already dabbled on what I thought logical stored procedure/table creation would be for boolean column, but no luck.

It'smainly the first few lines of sql data provider file, where you create table, but tags must be just off:

CREATE TABLE {databaseOwner}[{objectQualifier}ModuleName] (
[ID] [int] IDENTITY(1,1) NOT NULL,
[ModuleId] [int] NOT NULL,
[UserID] [int] NULL,
[ClientName] [nvarchar](50),
[Sum] [nvarchar](250),
[Score] [nvarchar](10),
[Product] [nvarchar](10),
[Equip] [nvarchar](10),
[Checkbox] [bit](0),   <<<< Is it [bit]?    (TRUE or FALSE)?

Everything beneath, within sql file, has been updated to match with @checkbox name.
Also data was added within info.vb & controller, so checkbox values could be stored.
Anything else that needs updated?


The next step, once the boolean field is created, will be to use analysis of true vs. false commands.
This is easy enough if it is a hardcoded field, but what about a databound gridview, where inputs dynamically get put in.
The only issue I see here, is saving appropraite row data with appropriate row.
Seems like it can be done failry easy, yet all code out there for checkboxes within databound gridview are extensive and extremely complex.
I will save that question for the reply post. 


Feedback Appreciated,

-machina12

 
New Post
8/1/2007 1:56 PM
 

database bit columns can have 3 values

null
0
1

I typically declare ALL of my bit columns as NOT NULL so that they can then only have the values of 0 or 1 which related to false and true respectivly.

If you are using the standard DNN DAL+ methods to get data from the database using the CBO object it will automatically perform the translation between bit and boolean for you.


-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services
 
New Post
8/1/2007 2:07 PM
 



Very well!
Was so close.
Now will be able to create stored procedures accordingly.


When it comes to implimenting these tools into checkboxes, and furthermore, into a checkbox within a databound grid view,
what do you recommend for learning?  tutorials?


Think that the code is powerful and can do what I am looking for without hundreds of lines of code, which is all I can find via a google search on topic keywords.
I see two main elements, correct me if I am wrong, 1.) something to the effect of an update button, where when clicked, checks state of boolean.  2.) save accordingly to that specific row.

It is both parts I am having trouble finding specific instructions for dnn, but #2 that I find the most relevant. 
Found adfwebserver tutorials to be great, but don't cover some of these unique questions.



-machina12

 
New Post
8/1/2007 2:11 PM
 

For these types of things I recommend looking at general ASP.NET tutorials, they are 99% the same, the only real difference is that you use the controllers and info classes to get the data. but everything else is the same.


-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services
 
New Post
8/1/2007 2:17 PM
 



In regards to this post, as well as my "Textbox with Actions?"  post, any tutorial sites that you feel rise above the rest?


-machina12

 
Previous
 
Next
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Understanding Booleans?Understanding Booleans?


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