SharePoint RSS provides the flexibility to expose view as RSS feed. With this feature, we can perform filtering, grouping and etc. to aggregate the list data information in the list and expose it as RSS feed.
Follow this article to achieve it.
Wednesday, July 15, 2009
Tuesday, July 14, 2009
Survey on Publishing template for anonymous
You might experience access denied behaviour when you try to use anonymous access to response survey.
How this happen is because a feature called ViewFormPagesLockDown is activated for publishing site.
So the key is to deactivate this.
stsadm -o deactivatefeature -name ViewFormPagesLockDown -url yrURL
find out more from here
How this happen is because a feature called ViewFormPagesLockDown is activated for publishing site.
So the key is to deactivate this.
stsadm -o deactivatefeature -name ViewFormPagesLockDown -url yrURL
find out more from here
Wednesday, July 8, 2009
Good Architect for DAL
I came across a very structure way to populate data from database back to object class.
After we retrieve data from database, typically we will have a datareader object. We can leverage on the method below to convert dr value to match with the data type in object class.
protected T GetDataObjectValue(IDataReader dr, string columnName)
{
int i = dr.GetOrdinal(columnName);
if (!dr.IsDBNull(i))
return (T)dr.GetValue(i);
else
return default(T);
}
Next, we can build a function to load the value into object class like below:
obj.ID = base.GetDataValue(dr, "ID");
If required, we can add the object into a object List.
After we retrieve data from database, typically we will have a datareader object. We can leverage on the method below to convert dr value to match with the data type in object class.
protected T GetDataObjectValue
{
int i = dr.GetOrdinal(columnName);
if (!dr.IsDBNull(i))
return (T)dr.GetValue(i);
else
return default(T);
}
Next, we can build a function to load the value into object class like below:
obj.ID = base.GetDataValue
If required, we can add the object into a object List.
Thursday, July 2, 2009
infopath limitation
It is very important to understand the limitation of infopath 2007. From high level, web based infopath is very powerful but it comes with several limitations.
- No native write to SQL databases. The ease of use of establing an ADO connection to SQL or Access, and being able to query and write back to a database is lost. Instead you will probably need to talk to the DB via a web service.
- No roundtripping for cascading picklists. Something I do all the time is have one picklist be a filter for another picklist. Common example, pick a state, which then filters the city field dropdown. Can't do that in a web form.
- Summary list of controls that aren't supported in web forms:
ComboBox,Multiple-Selection List Box
Master/Detail,Bulleted, Numbered and Plain List
Picture ,Ink Picture ,Vertical Label
Scrolling and Horizontal Region ,Horizontal Repeating Table
Choice Group ,Repeating Choice Group
Choice Section ,Repeating Recursive Section
ActiveX Controls
Refer to this article for more details, MSDN article.
With this limitation, this shows you how to perform debugging.
Wednesday, July 1, 2009
Email Regular expression validation
Email regular expression validation
([\w\-\.]+)@((\[([0-9]{1,3}\.){3}[0-9]{1,3}\])(([\w\-]+\.)+)([a-zA-Z]{2,4}))
([\w\-\.]+)@((\[([0-9]{1,3}\.){3}[0-9]{1,3}\])(([\w\-]+\.)+)([a-zA-Z]{2,4}))
Subscribe to:
Posts (Atom)