Friday, 27 January 2012

How to pass multiple repeating table field values to the text field with semi colon(;)

Eval(eval(RepeatingGp, 'concat(substring(my:Name, 1, (current() = /my:myFields/my:FieldsGp/my:RepeatingGp) * string-length(my:Name)), substring(concat(my:Name, "; "), 1, (not(current() = /my:myFields/my:FieldsGp/my:RepeatingGp)) * string-length(concat(my:Name, "; "))), ";")'), "..")


Wednesday, 25 January 2012

How to use LasIndexOf in "URL"

string projecturl = properties.WebUrl;
string targeturl = projecturl.Remove(projecturl.LastIndexOf('/'));

Example
string sp=http://sharepoint/sites/subsite1/subsite2

here I want to remove subsite2 from the above url

string newsp=sp.Remove(sp.LastIndexOf('/'));

now we get the URL as

http://sharepoint/sites/subsite1

Tuesday, 24 January 2012

How to Bind List Items to Repeating Table


}
XPathNavigator nav = this.MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:group1/my:repeatinggroup", this.NamespaceManager);
XPathNavigator NewNode = null;
if (listitems != null)
{
foreach (SPListItem ListItem in listitems)
{

NewNode = nav.Clone();
NewNode.SelectSingleNode("/my:myFields/my:group1/my:repeatinggroup/my:rtxtkeyactivities", this.NamespaceManager).SetValue(Convert.ToString(ListItem["Key Activities"]));
NewNode.SelectSingleNode("/my:myFields/my:group1/my:repeatinggroup/my:txtComp", this.NamespaceManager).SetValue(Convert.ToString(ListItem["%Comp"]));
NewNode.SelectSingleNode("/my:myFields/my:group1/my:repeatinggroup/my:dateTargettiming", this.NamespaceManager).SetValue(Convert.ToString(ListItem["Target Timing"]));
NewNode.SelectSingleNode("/my:myFields/my:group1/my:repeatinggroup/my:dateRevised", this.NamespaceManager).SetValue(Convert.ToString(ListItem["Revised Timing"]));
NewNode.SelectSingleNode("/my:myFields/my:group1/my:repeatinggroup/my:ddStatus", this.NamespaceManager).SetValue(Convert.ToString(ListItem["Status"]));
nav.InsertAfter(NewNode);

}
if (listitems.Count > 0)

nav.DeleteSelf();//Delete parent node to remove duplicate entry