SQL Database table field default value and dataset's datatable

Hot Topic

Create control collection dynamically in Vb2005
File I/O to read a specific lineok wait, I've been playing around with the code, but stupid me, I didnt catch this before,
UserControl.text Property not visible in Properties window
Tabbed Layout
Loop without Do Error - End If
DirectCast Vs CType
How to halt a program???
How Do I Use Speech Recognition In My Visual Basic 2005 Program?
Two fairly simple questions but i dont know how to phrase them. Basic VB language.
Sum Function on Select

Visual Basic

Method POST to send Data from windows form to ASP web page and get response
Access of Shared member.........
run-time errors
How to set a control's visible property.
Questions
Quick find and replace very, very slow
Remote SQL Server Connection
read text
Undo
Problem with label control and controls in general...

SQL Database table field default value and dataset's datatable

I have designed a table in SQL Server 2000 which has a field with a default value expression of 'getdate()', how can I carry that default value expression when i fill the schema of a dataset So everytime I add a datarow inside the datatable in that dataset, i get the current date and time.

thanks.


Answer this question

SQL Database table field default value and dataset's datatable

  • Paulo Faustino

    Hi,


    Just set your dataColumn's DefaultValue property to the current date. eg:

    ' After filling your datatable with an adapter
    Dim dc as DataColumn = datatable.Columns["ColumnName"]
    dc.DefaultValue = Now





    cheers,

    Paul June A. Domag

  • Kenneth Keeley

    yes that's what i have to do. but still it made me state the default value, and it did not get it automatically from the tables schema.

    meaning i have to still define default values in vb.net even though i have defined it in my table design... sigh.

    thanks for the reply.

  • SQL Database table field default value and dataset's datatable
Answer this question