Comments on Chris O'Brien: SPDataSource - every SharePoint developer's friend...

@sharepoint, Sorry I'm not quite sure what yo...

2010-11-29T12:52:37.878Z

@sharepoint,

Sorry I'm not quite sure what you've done there. Hope you get sorted.

Chris.

Hello Chris, Thank you for your article. We came a...

2010-11-29T11:48:04.715Z

Hello Chris,
Thank you for your article. We came across it because we think we messed with the binding somehow.
Here is the markup (Sharepoint 2010) :

__designer:bind="{ddwrt:DataBind('u',concat('ff6',$Pos),'SelectedValue','SelectedIndexChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@Country')}"

However on the page, the dropdownlist does not show the contry name ("Germany") but a link to it (inside the drop list!), like this:

<a href="http://servername/my/personal/Lab04/_layouts/listform.aspx?PageType=4&ListId={FA572B1D-F8A4-4A7B-BC3D-E1EAE92F20DE}&ID=4&RootFolder=*">Germany</a>

Do you have any idea how it could be?
Thank you,

@silas2, That's a good question. XML + XSLT c...

2009-11-05T23:48:03.358Z

@silas2,

That's a good question. XML + XSLT can be very performant, I used this approach a lot years ago with Content Management Server :)

Often it depends on what you get from the API you're using - if it gives you XML, don't serialize it into objects, just transform it. If it gives you objects, don't deserialize them, data-bind them!

Otherwise, you'll be able to find good perf comparisons with the right internet searches - there are a few variables so I won't comment too much here.

HTH,

Chris.

What guidlines would you suggest for deciding whet...

2009-11-03T12:20:01.350Z

What guidlines would you suggest for deciding whether to use familiar (and probably well wrapped) Asp.Net databound controls, and this new stuff, executing xml/xsl/caml/html hybrid? It seems very verbose.

@Albert, At a guess, that would say to me that yo...

2009-08-06T10:45:12.258+01:00

@Albert,

At a guess, that would say to me that your markup isn't quite in the right format (I'm assuming you're using the SPDataSource sample rather than the CAML query). Can you paste in what you're using?

Thanks,

Chris.

I tried your code and got a warning saying that &q...

2009-08-05T19:33:13.501+01:00

I tried your code and got a warning saying that "OrderBy" isn't a public property of spdatasource. Is that normal?

I'm not sure if this completely solves the riddle,...

2008-11-18T05:16:00.000Z

I'm not sure if this completely solves the riddle, but SPDataSource implements IDataSource whose GetView method returns a DataSourceView which defines the ExeuteDelete, ExecuteInsert, ExecuteSelect, and ExecuteUpdate methods.

So, by ipmlementing IDataSource, SPDataSource must have at least some knowledge of the update/insert/delete operations even if they are just stubbed out.

@VV,

I was just about to respond that the r...

2008-10-09T22:57:00.000+01:00

@VV,

I was just about to respond that the reason for this is that the InsertCommand and UpdateCommand properties are inherited from System.Web.UI.DataSourceControl (but there is no implementation), but upon checking this isn't the case!

So it now seems quite strange that SPDataSource would define these properties but not implement them. Like you, I haven't seen any samples of their use. Hence, I still believe SPDataSource doesn't use them - and especially so when you consider that CAML (used by SelectCommand property) has no syntax for performing insert/update operations.

As I say, if you hear different I'd be very interested!

Cheers,

Chris.

Thanks for your response Chris!

May be you ...

2008-10-09T20:56:00.000+01:00

Thanks for your response Chris!

May be you are right, but then why does SPDatasource has properties named insertcommand/updatecommand? These are misleading. I have spent so much time trying to make this work, as I have to use lot of bulk editable gridviews in my project. Now I have to look at other options.
I have read both of your articles, they are very helpful. Keep up the Good work!

@VV,

I'm 99% certain SPDataSource doesn't s...

2008-10-09T18:30:00.000+01:00

@VV,

I'm 99% certain SPDataSource doesn't support insert/update operations I'm afraid. If you need to insert/update you'll need to code these operations using SPList.Items.Add() etc.

If you hear any different I'd love to know.

HTH,

Chris.

Hi Chris,
I have searched all over but could no...

2008-10-09T18:13:00.000+01:00

Hi Chris,
I have searched all over but could not find answer to this. This is my last attempt towards the problem.
I wish to use updatecommand/insertcommand in SPDatasource, but I do not see any example.
Appreciate if you can help. Thanks.

Renaud - oops, yes thanks for that. Article now up...

2008-07-07T22:54:00.000+01:00

Renaud - oops, yes thanks for that. Article now updated :-)

Great article Chris. I always thought that it took...

2008-07-07T14:45:00.000+01:00

Great article Chris. I always thought that it took a lot of code just to retrieve a list of items from a SharePoint list. It's a shame that SPDataSource wasn't introduced in some of the SharePoint application development books I haven read so far.

I think you speak about this link ?

http://...

2008-07-07T08:32:00.000+01:00

I think you speak about this link ?

http://blogs.msdn.com/sharepointdesigner/archive/2007/04/24/spdatasource-and-rollups-with-the-data-view.aspx