Unable to use the column's defaultvalue when inserting a row

Discussion in 'ASP .Net Web Controls' started by jmvc, Sep 3, 2005.

  1. jmvc

    jmvc Guest

    Hi,

    I'm trying to insert a row in a table, using a dataset. But when I try to
    update the dataset with the dataadapter, it triggers a exception telling that
    there's a column with a null value, instead of that columns was defined with
    a default value in SQL Server.

    I'm using Visual Basic of Visual Studio 2003, connected to a SQL Server
    database and developping (or trying to develop) a web application.

    Can somebody help me ???

    Regards,

    Jorge VC
     
    jmvc, Sep 3, 2005
    #1
    1. Advertising

  2. Could you post the code you are using to do this? I think I will be able to
    help more when I see the code.
    --
    Nathan Sokalski

    http://www.nathansokalski.com/

    "jmvc" <> wrote in message
    news:...
    > Hi,
    >
    > I'm trying to insert a row in a table, using a dataset. But when I try to
    > update the dataset with the dataadapter, it triggers a exception telling
    > that
    > there's a column with a null value, instead of that columns was defined
    > with
    > a default value in SQL Server.
    >
    > I'm using Visual Basic of Visual Studio 2003, connected to a SQL Server
    > database and developping (or trying to develop) a web application.
    >
    > Can somebody help me ???
    >
    > Regards,
    >
    > Jorge VC
     
    Nathan Sokalski, Sep 3, 2005
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. dan
    Replies:
    0
    Views:
    542
  2. SJL
    Replies:
    2
    Views:
    2,357
  3. =?Utf-8?B?QVNQIERldmVsb3Blcg==?=

    System.ComponentModel.DefaultValue doesn't work with user control

    =?Utf-8?B?QVNQIERldmVsb3Blcg==?=, Sep 13, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    1,683
    =?Utf-8?B?QVNQIERldmVsb3Blcg==?=
    Sep 13, 2006
  4. Replies:
    0
    Views:
    480
  5. Syd_Man
    Replies:
    0
    Views:
    345
    Syd_Man
    Dec 5, 2006
Loading...

Share This Page