Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > DetailsView updates unused properties to null

Reply
Thread Tools

DetailsView updates unused properties to null

 
 
Nick Bennett
Guest
Posts: n/a
 
      01-20-2008
I've got a page with a DetailsView. It uses a SqlDataSource which itself
uses stored procedures for Select and Update.

I don't want the user to see some of the columns, but if I don't bind them
(or if I do bind them but set Visible=False), when the Update procedure is
called, the parameters corresponding to the columns that weren't bound to
the DetailsView are all null.

This can't be an uncommon scenario, so I guess I have missed something. Any
ideas?


 
Reply With Quote
 
 
 
 
Milosz Skalecki [MCAD]
Guest
Posts: n/a
 
      01-20-2008
Howdy,

Take a look at BoundField's InsertVisible property as well as SqlDataSource
Updating/Inserting events.

Regards
--
Milosz


"Nick Bennett" wrote:

> I've got a page with a DetailsView. It uses a SqlDataSource which itself
> uses stored procedures for Select and Update.
>
> I don't want the user to see some of the columns, but if I don't bind them
> (or if I do bind them but set Visible=False), when the Update procedure is
> called, the parameters corresponding to the columns that weren't bound to
> the DetailsView are all null.
>
> This can't be an uncommon scenario, so I guess I have missed something. Any
> ideas?
>
>
>

 
Reply With Quote
 
 
 
 
Angel
Guest
Posts: n/a
 
      01-23-2008
Using BoundField might help but keep in mind that things get really ugly when
you mix Declarative stuff and code. My suggestion to you is go completely
code replace the sqldatasource with a dataset or datatable and user the
datasource property instead.

Where it get tricky is if you have dropdowns or any other template based
field it can get a little hard to do but is doable I have a demo depicting a
dynamic situation
similar to the one you are describing. Mine involves a detailsview and
Gridview in a master/details relationship. One page hitting multiple table
and columns are defined at runtime.

If you are interested let me know and I will be glad to share this with you.
--
aaa


"Nick Bennett" wrote:

> I've got a page with a DetailsView. It uses a SqlDataSource which itself
> uses stored procedures for Select and Update.
>
> I don't want the user to see some of the columns, but if I don't bind them
> (or if I do bind them but set Visible=False), when the Update procedure is
> called, the parameters corresponding to the columns that weren't bound to
> the DetailsView are all null.
>
> This can't be an uncommon scenario, so I guess I have missed something. Any
> ideas?
>
>
>

 
Reply With Quote
 
Paul Shapiro
Guest
Posts: n/a
 
      02-11-2008
You could use a stored procedure which did not include parameters for the
columns you don't want updated.

An asp:Boundfield has a ConvertEmptyStringToNull property. Have you tried
setting that to false?

"Nick Bennett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I've got a page with a DetailsView. It uses a SqlDataSource which itself
> uses stored procedures for Select and Update.
>
> I don't want the user to see some of the columns, but if I don't bind them
> (or if I do bind them but set Visible=False), when the Update procedure is
> called, the parameters corresponding to the columns that weren't bound to
> the DetailsView are all null.
>
> This can't be an uncommon scenario, so I guess I have missed something.
> Any ideas?


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
When you declare an array of chars and store a string in it, where isthe position of the null character \0? And what happens to the unused memorylocations? Gary C Programming 5 05-07-2008 03:11 AM
problem with checking null or empty value in detailsview bob ASP .Net 3 05-05-2008 09:46 PM
DetailsView updates unused properties to null Nick Bennett ASP .Net Web Controls 3 02-11-2008 07:34 PM
"stringObj == null" vs "stringObj.equals(null)", for null check?? qazmlp1209@rediffmail.com Java 5 03-29-2006 10:37 PM
DetailsView - Changing to Insert Mode (Not By Using the Insert Button In the DetailsView Control) Feege ASP .Net Web Controls 0 12-20-2005 12:28 AM



Advertisments