By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,053 Members | 1,615 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,053 IT Pros & Developers. It's quick & easy.

FillSchema Doesn't bring SQL Server Default Values

P: n/a
Hi All

Here is my problem

I'm using a SQLDataAdapter and DataSet

I use the method FillSchema(myDataset, SchemaType.Source)
The problem is that when i Check the default Values of the Dataset
i can see that the DefaultValue of the columns is system.dbnull!!!!
But in SQL Server i have put as default values in a bigint field the '0' and
the field is also required

The Dataset is bound to a Datagrid and it's totaly disconected from the
server (Custom Control)
So because i handle the event of new row i must perform the AddRow at my
own.
I have capture the event and handle it for many reasons. And i can't change
it.
this is the code
Dim nr As DataRow = myDataset.Tables(0).NewRow
dsData.Tables(0).Rows.Add(nr)

Then i have the crash!. And the reason is that no Default Values exists from
the FillSchema call

Where is my default value??????????????????
How can i get them from the SQL????

Thank you in advance.

Kind Regards
Dimitris
Jul 22 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I know that i can get the default values of columns on syscolumns and other
system tables.

IN .NET In DataSet to be exact. Fill Schema should bring the default.
Now I'm just making 2 steps and disconect from the server.
1. FillScehama(MyDataset, SchemaType.Source)
2. Fill(MyDataset.Tables(0))

And the only proposion is to get a DataReader for example loon in it so i
can get the default values?
I have thowht that. But I don't like it.

Isn't any implimentetion in .NET to do it without running a new select
statement??
Does finally the FillScehama has a bug?

Thank you for your reply.
Kind Regards
Dimitris
"Lishi Liu [MSFT]" <li****@online.microsoft.com> wrote in message
news:ny**************@TK2MSFTNGXA01.phx.gbl...

If you work on SQL server, you get it by
execute sp_MShelpcolumns
for example:
execute sp_MShelpcolumns 'dbo.Authors', null, 'id', 1

The out put one row are for each column of the table dbo.Authors.
There is a output column "Text", that contain the the default value for
each column of the table(on each row).
Another output column "col_defname", contains the default object binded
for
each column of the table.

Or you can open a table in table designner, see the defaul value or
binding
property.

VSData team, Lishi Liu

--------------------
Reply-To: "Programmer" <se*******@hotmail.com>
From: "Programmer" <se*******@hotmail.com>
Subject: FillSchema Doesn't bring SQL Server Default Values
Date: Thu, 30 Jun 2005 15:04:14 +0300
Keywords: FillSchema , SQL Default Values in FillSchema,FillSchema Doesn't

bring SQL Server Default Values
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
X-RFC2646: Format=Flowed; Original
Message-ID: <eB**************@tk2msftngp13.phx.gbl>
Newsgroups:

microsoft.public.dotnet.framework.sdk,microsoft.pu blic.dotnet.general,micros
oft.public.dotnet.languages.vb,microsoft.public.do tnet.languages.vb.data
NNTP-Posting-Host: 212.114.125.86
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msft ngp13.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.dotnet.general:45167

microsoft.public.dotnet.languages.vb:95051
microsoft.public.dotnet.languages.vb.data:2185
microsoft.public.dotnet.framework.sdk:1779
X-Tomcat-NG: microsoft.public.dotnet.languages.vb.data

Hi All

Here is my problem

I'm using a SQLDataAdapter and DataSet

I use the method FillSchema(myDataset, SchemaType.Source)
The problem is that when i Check the default Values of the Dataset
i can see that the DefaultValue of the columns is system.dbnull!!!!
But in SQL Server i have put as default values in a bigint field the '0'

and
the field is also required

The Dataset is bound to a Datagrid and it's totaly disconected from the
server (Custom Control)
So because i handle the event of new row i must perform the AddRow at my
own.
I have capture the event and handle it for many reasons. And i can't

change
it.
this is the code
Dim nr As DataRow = myDataset.Tables(0).NewRow
dsData.Tables(0).Rows.Add(nr)

Then i have the crash!. And the reason is that no Default Values exists

from
the FillSchema call

Where is my default value??????????????????
How can i get them from the SQL????

Thank you in advance.

Kind Regards
Dimitris

Jul 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.