Programmer
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]" <lishil@online.microsoft.com> wrote in message
news:nycUBxdfFHA.2828@TK2MSFTNGXA01.phx.gbl...[color=blue]
>
>
>
> 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
>
> --------------------[color=green]
>>Reply-To: "Programmer" <seeyou_gr@hotmail.com>
>>From: "Programmer" <seeyou_gr@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[/color]
> bring SQL Server Default Values[color=green]
>>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#WEwWfFHA.3788@tk2msftngp13.phx.gbl>
>>Newsgroups:[/color]
> microsoft.public.dotnet.framework.sdk,microsoft.pu blic.dotnet.general,micros
> oft.public.dotnet.languages.vb,microsoft.public.do tnet.languages.vb.data[color=green]
>>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[/color]
> microsoft.public.dotnet.languages.vb:95051
> microsoft.public.dotnet.languages.vb.data:2185
> microsoft.public.dotnet.framework.sdk:1779[color=green]
>>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'[/color]
> and[color=green]
>>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[/color]
> change[color=green]
>>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[/color]
> from[color=green]
>>the FillSchema call
>>
>>Where is my default value??????????????????
>>How can i get them from the SQL????
>>
>>Thank you in advance.
>>
>>Kind Regards
>>Dimitris
>>
>>
>>[/color]
>[/color]
| 
