FormViews - ASP.NET 2.0

[Just Me]

OK, im really struggling with something which sould really be simple I
think.

Ive created an SQL Datasource on a web form and dragged a formview, editted
the Insert Template to make it look nice in a table etc. The table itself
has lots of fields ( About 20 ) and I have set up an Insert statement in the
SQLDatasource, and tested in that that I can insert a record.

So far so good.
Now where I am missing knowledge is how to make the data held in the
formview get updated.

So, my Insert statrement looks something like.

Insert Into Users( NickName) Values(@Nickname) // Obviously there are
more fields

Nows I can execute this in the datasource config an successfully create the
records. However, Im at a bit of a loss as to how to do this fromt he form.

The Isnert Template has bound fields to all the table records.

In the Insert Click handler, I do

Me.formview1.insert(false)

This tried to do the Insert, but I get an exception to tell me that the
value of the nickname field is Null.. What Do I need to do to set up the
connection between the Insert Template and the parameters in the Insert
query

Many Thanks

[Cowboy \(Gregory A. Beamer\)]

The way I normally do it.

1. Test the fields in the form
2. If there are any nulls, cast them, in the DataSet, to their proper SQL
Type

value = SqlString.Null

as an example.

As long as the field can legally accept null values, this should solve your
issue. A bit heavier than drag and drop, but explicit code is bettter. :-)

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*********************************************
Think outside the box!
*********************************************
"Just Me" <news.microsoft.comwrote in message
news:%2***************@TK2MSFTNGP06.phx.gbl...

OK, im really struggling with something which sould really be simple I
think.

Ive created an SQL Datasource on a web form and dragged a formview,
editted the Insert Template to make it look nice in a table etc. The
table itself has lots of fields ( About 20 ) and I have set up an Insert
statement in the SQLDatasource, and tested in that that I can insert a
record.

So far so good.
Now where I am missing knowledge is how to make the data held in the
formview get updated.

So, my Insert statrement looks something like.

Insert Into Users( NickName) Values(@Nickname) // Obviously there are
more fields

Nows I can execute this in the datasource config an successfully create
the records. However, Im at a bit of a loss as to how to do this fromt he
form.

The Isnert Template has bound fields to all the table records.

In the Insert Click handler, I do

Me.formview1.insert(false)

This tried to do the Insert, but I get an exception to tell me that the
value of the nickname field is Null.. What Do I need to do to set up the
connection between the Insert Template and the parameters in the Insert
query

Many Thanks

[Evan M.]

On Apr 11, 2:51 pm, "Just Me" <news.microsoft.comwrote:

OK, im really struggling with something which sould really be simple I
think.

Ive created an SQL Datasource on a web form and dragged a formview, editted
the Insert Template to make it look nice in a table etc. The table itself
has lots of fields ( About 20 ) and I have set up an Insert statement in the
SQLDatasource, and tested in that that I can insert a record.

So far so good.

Now where I am missing knowledge is how to make the data held in the
formview get updated.

So, my Insert statrement looks something like.

Insert Into Users( NickName) Values(@Nickname) // Obviously there are
more fields

Nows I can execute this in the datasource config an successfully create the
records. However, Im at a bit of a loss as to how to do this fromt he form.

The Isnert Template has bound fields to all the table records.

In the Insert Click handler, I do

Me.formview1.insert(false)

This tried to do the Insert, but I get an exception to tell me that the
value of the nickname field is Null.. What Do I need to do to set up the
connection between the Insert Template and the parameters in the Insert
query

Many Thanks

Can we get some sample code of what you're doing? My first guess would
be that the names of your parameters in your insert statement aren't
matching up with the names of your parameters and your Bind calls in
your InsertItemTemplate