Hi again,
can someone point out where I am going wrong here pls..
I have a computed column (JobID) which takes the value of AutoID autonumber column and prefixes it with the letter 'A'. When I create a new record directly in SQL Server Management, it saves the record - gives the new AutoID number and populates the JobID field - no problem.
When I am trying to insert a new record using the VS tabladapter, it errors saying 'Column JobID does not allow nulls'. I can't exactly populate this myself as I don't know what the AutoID is going to be..
I'm not sure how to get around this.
Hope someone can help,
thanks John
.NET 2.0, Visual Studio 2005, SQL Server 2005 Express
can someone point out where I am going wrong here pls..
I have a computed column (JobID) which takes the value of AutoID autonumber column and prefixes it with the letter 'A'. When I create a new record directly in SQL Server Management, it saves the record - gives the new AutoID number and populates the JobID field - no problem.
When I am trying to insert a new record using the VS tabladapter, it errors saying 'Column JobID does not allow nulls'. I can't exactly populate this myself as I don't know what the AutoID is going to be..
I'm not sure how to get around this.
Hope someone can help,
thanks John
.NET 2.0, Visual Studio 2005, SQL Server 2005 Express