Re: Default values in dataTable
- From: "Vladimir Oľura" <vladimir.ozura@xxxxxx>
- Date: Tue, 4 Oct 2005 22:24:30 +0200
Thanks alot!!!!
I don't know why I didn't try that.
"Darren Shaffer" <darrenshaffer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:#2hRU7QyFHA.2228@xxxxxxxxxxxxxxxxxxxxxxx
> if ( dtr.IsDBNull(2) )
> retVal = string.empty
> else
> retVal = dtr.GetString(2)
>
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
>
>
> "Vladimir O¾ura" <vladimir.ozura@xxxxxx> wrote in message
> news:dhud06$aov$1@xxxxxxxxxxxxxxxx
> >I am building a Pocket PC application in C# and I tryed to get the
Default
> > values of columns in a given table with the following SqlCeCommand:
> >
> > SqlCeCommand columns = new SqlCeCommand(@"SELECT COLUMN_NAME, TYPE_NAME,
> > COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS,
> > INFORMATION_SCHEMA.PROVIDER_TYPES WHERE
> >
INFORMATION_SCHEMA.COLUMNS.DATA_TYPE=INFORMATION_SCHEMA.PROVIDER_TYPES.DATA_
> > TYPE AND TYPE_NAME NOT IN
> > ('ntext','nchar','image','binary','varbinary','uniqueidentifier') AND
> > COLUMN_NAME NOT IN ('s_Generation') AND TABLE_NAME = ?", this.sqlce);
> >
> > When I Execute the command and try to read the COLUMN_DEFAULT "String"
> > with
> > the following command:
> >
> > dtr.GetString(2);
> >
> > I get an SqlNullValueException. I know that the default value in the
> > database is set to NULL, but can't you read a NULL value and then set
the
> > defautl value in a dataTable to NULL?
> >
> > Is there another way to get that COLUMN_DEFAULT without getting the
> > exception?
> >
> > THANKS!!!
> >
> >
>
>
.
- References:
- Default values in dataTable
- From: Vladimir Oľura
- Re: Default values in dataTable
- From: Darren Shaffer
- Default values in dataTable
- Prev by Date: Re: Sql Mobile Left Outer Join
- Next by Date: Insert, Udate, Select data with embedded C++
- Previous by thread: Re: Default values in dataTable
- Next by thread: Insert, Udate, Select data with embedded C++
- Index(es):
Relevant Pages
|
