locked
AccessDataSource1.InsertCommand RRS feed

  • Question

  •  

    Hi,

    - ASP C#.NET 2.0

     

    Working with

    AccessDataSource1.InsertCommand = "INSERT INTO.....

     

    I have a column that reqires an empty string (column set to = Allow Zero Length in Access db)

     

    I've tried this, and many other variables... but no go 

    AccessDataSource1.InsertParameters.Add(@"Company", TypeCode.String, string.Empty);

     

    Ron

    Saturday, June 9, 2007 1:07 AM

All replies

  • I'm very new to this, but have you tried using a null value?
    Monday, June 11, 2007 3:17 PM
  • Hi Dennis,

     

    Yes, I did try that...

     

    Ron

    Tuesday, June 12, 2007 7:45 PM

  • So what is the result after performing the INSERT? Or, are you encountering an error?
    Tuesday, June 12, 2007 9:11 PM
  •  

    No error message, the database just does not show the INSERT data. As a workaround, I've set the value to inserto to " " and not "".

     

    Ron

     

    Wednesday, June 13, 2007 11:17 PM