I used the designer in VS.NET 2003 to create a dataset. Within that
dataset, there is an element "Tags", with a primary key and
relationship:
<xs:element name="Tags">
<xs:complexType>
<xs:sequence>
<xs:element name="TagName" type="xs:string" minOccurs="0" />
<xs:element name="TagDesc" type="xs:string" minOccurs="0" />
<xs:element name="System" type="xs:boolean" minOccurs="0" />
<xs:element name="FieldType" type="xs:string" minOccurs="0" />
<xs:element name="FieldLength" type="xs:integer" minOccurs="0"
/>
<xs:element name="Decimal" type="xs:integer" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:key name="pkTags" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Tags" />
<xs:field xpath="mstns:TagName" />
</xs:key>
<xs:keyref name="TagsLabelsTags" refer="pkTags"
msdata:DeleteRule="Cascade">
<xs:selector xpath=".//mstns:LabelsTags" />
<xs:field xpath="mstns:TagName" />
</xs:keyref>
Nothing special, right?
When I attempt to build the project I get a series of compile errors
in the code behind:
'Convert' is not a member of 'Boolean'.
Public Sub SetTagDescNull()
Me(Me.tableTags.TagDescColumn) = System.Convert.DBNull <--- Here
End Sub
There is one error for each of the non-key fields, all in the
Set_Field_Null() subroutines.
I'm lost. Any ideas? 2 2595
Hi Brian,
I would really avoid using System and Decimal as column names.
--
Miha Markic - RightHand .NET consulting & development
miha at rthand com www.rthand.com
"Brian" <br***********@yahoo.com> wrote in message
news:1b**************************@posting.google.c om... I used the designer in VS.NET 2003 to create a dataset. Within that dataset, there is an element "Tags", with a primary key and relationship:
<xs:element name="Tags"> <xs:complexType> <xs:sequence> <xs:element name="TagName" type="xs:string" minOccurs="0" /> <xs:element name="TagDesc" type="xs:string" minOccurs="0" /> <xs:element name="System" type="xs:boolean" minOccurs="0" /> <xs:element name="FieldType" type="xs:string" minOccurs="0" /> <xs:element name="FieldLength" type="xs:integer" minOccurs="0" /> <xs:element name="Decimal" type="xs:integer" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element>
<xs:key name="pkTags" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Tags" /> <xs:field xpath="mstns:TagName" /> </xs:key>
<xs:keyref name="TagsLabelsTags" refer="pkTags" msdata:DeleteRule="Cascade"> <xs:selector xpath=".//mstns:LabelsTags" /> <xs:field xpath="mstns:TagName" /> </xs:keyref>
Nothing special, right?
When I attempt to build the project I get a series of compile errors in the code behind:
'Convert' is not a member of 'Boolean'.
Public Sub SetTagDescNull() Me(Me.tableTags.TagDescColumn) = System.Convert.DBNull <--- Here End Sub
There is one error for each of the non-key fields, all in the Set_Field_Null() subroutines.
I'm lost. Any ideas?
Hi Miha,
I hadn't even thought about that. After I changed those column names it worked.
Thanks for the help.
"Miha Markic" <miha at rthand com> wrote in message news:<ut**************@tk2msftngp13.phx.gbl>... Hi Brian,
I would really avoid using System and Decimal as column names.
-- Miha Markic - RightHand .NET consulting & development miha at rthand com www.rthand.com
"Brian" <br***********@yahoo.com> wrote in message news:1b**************************@posting.google.c om... I used the designer in VS.NET 2003 to create a dataset. Within that dataset, there is an element "Tags", with a primary key and relationship:
<xs:element name="Tags"> <xs:complexType> <xs:sequence> <xs:element name="TagName" type="xs:string" minOccurs="0" /> <xs:element name="TagDesc" type="xs:string" minOccurs="0" /> <xs:element name="System" type="xs:boolean" minOccurs="0" /> <xs:element name="FieldType" type="xs:string" minOccurs="0" /> <xs:element name="FieldLength" type="xs:integer" minOccurs="0" /> <xs:element name="Decimal" type="xs:integer" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element>
<xs:key name="pkTags" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Tags" /> <xs:field xpath="mstns:TagName" /> </xs:key>
<xs:keyref name="TagsLabelsTags" refer="pkTags" msdata:DeleteRule="Cascade"> <xs:selector xpath=".//mstns:LabelsTags" /> <xs:field xpath="mstns:TagName" /> </xs:keyref>
Nothing special, right?
When I attempt to build the project I get a series of compile errors in the code behind:
'Convert' is not a member of 'Boolean'.
Public Sub SetTagDescNull() Me(Me.tableTags.TagDescColumn) = System.Convert.DBNull <--- Here End Sub
There is one error for each of the non-key fields, all in the Set_Field_Null() subroutines.
I'm lost. Any ideas? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Tim Cartwright |
last post by:
I have a page that has the login control on it, nothing else. This page inherits from a master page, neither page has any code in it. This page works perfectly when running on the WebDev debug web...
|
by: Vu Doan Hung |
last post by:
I want to change this Class to VB.NET Class, can you help me ?
using System;
using System.Windows.Forms;
using System.Drawing;
using System.Data;
|
by: QuocSi |
last post by:
Hi all,
I have a bitsfield
Structure MyBits
a as boolean
b as boolean
c as boolean
d as boolean
end structure
|
by: Me |
last post by:
Hi all
I am getting a really bizzare error on when I convert a string into a
datetime:
The code is :
DateTime dt1 = Convert.ToDateTime("10 Sep 2005");
Console.WriteLine(dt1.Year);
|
by: Learner |
last post by:
Hello,
Here is the code snippet I got strucked at.
I am unable to convert the below line of code to its equavalent vb.net
code. could some one please help me with this?
static public...
|
by: simonZ |
last post by:
Why this don't work:
Boolean test;
String testValue;
testValue="0";
test=System.Convert.ToBoolean(testValue);
How can I convert string to boolean?
|
by: IZZI |
last post by:
I have this Pascal code. Can anyone convert it to C code for me, plz? Im a newbie in programming. Thanks a lot.
const
maxsize=100;
type
DICTIONARY=record
last:integer
data:...
|
by: tshad |
last post by:
I have a value in my sql table set to tinyint (can't set to bit).
I am trying to move it into a boolean field in my program and have tried:
isTrue = (int)dbReader
and
isTrue =...
|
by: Debadatta Mishra |
last post by:
Introduction
In this article I will provide you an approach to manipulate an image file. This article gives you an insight into some tricks in java so that you can conceal sensitive information...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |