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