SharePoint - Development and Programming Forum

SharePoint object model and Windows Services

Wed, 25 Nov 2009 14:02:00 Z

Hi

I'm creating a windows service that connects to a SharePoint site to retrieve and update a list. The code works fine while debugging and not running as a service, but when I want to run the code as a service the code fails to retrieve list items.

So: I have two listitems in my SharePoint list which I successfully retrieve while not running the code as a service, but the Items.Count retrieves 0 while running as a service, e.g. I involve the following into my code:

[code]
            ServiceBase[] ServicesToRun;
            ServicesToRun = new ServiceBase[]
            {
                new MyProgram()
            };
            ServiceBase.Run(ServicesToRun);
[/code]

Can it be a permission issue? While running as a service the code successfully retrieves the SharePoint site, but why wouldn't it be able to correctly interact with this specific list? I haven't set any special permissions on it.

Any ideas?

Studying system development. I always give credit to helpful posts!

User interface issues when performing multiple column filtering on an SPGridView control

Wed, 25 Nov 2009 14:03:41 Z

When viewing a SharePoint list, you can filter on multiple columns at once. I'm trying to replicate this using the SPGridView control bound to a SQLDataSource. I think I've got the multiple filtering cracked by appending the newly chosen filter to the one held in ViewState and then applying that to the datasource. However, the SPGridView UI still thinks that only the last filter has been applied because only the last filtered column has the filter icon next to it and the filtered value selected/ticked in the list of filter values for the column.

For example, say I have 3 columns; Location, Manufacturer, Model
I first filter on Location and set that to UK. All works fine. I then filter on Manufacturer = Dell. So I'm now being shown all the Dell PC's in the UK. However, the filter icon is now only showing on the Manufacturer column and when viewing the filter dropdowns for the column headings, only the manufacturer column is aware it's being filtered upon.

Any ideas?

Add Items to SPListItemCollection

Wed, 25 Nov 2009 13:02:52 Z

Hi,

i have a loop to get different items with a spquery in my collection, at the end of the loop i would like to sum these items to one big collection of all items...

code example:

SPList list = web.Lists["Sitzungen"];
                    SPQuery q = new SPQuery();
                    SPQuery sitzungen = new SPQuery();

                    sitzungen.Query = "<Where><IsNotNull><FieldRef Name='Title' /></IsNotNull></Where><OrderBy><FieldRef Name='Datum' Ascending='False'/></OrderBy>";
                    SPListItemCollection sitzcol = list.GetItems(sitzungen);

                    SPListItemCollection alleBeschlüsse = null;

                    foreach (SPListItem c in sitzcol)
                    {
                        q.Query = "<Where><Eq><FieldRef Name='ContentType'/><Value Type='Text'>Beschluss</Value></Eq></Where>";
                        q.ViewAttributes = "Scope=\"Recursive\"";
                        if (c.Folder != null)
                            q.Folder = c.Folder;
                        SPListItemCollection col = list.GetItems(q);
                       
                    }

please dont look @query text, cause they are nonsense is just for a test program...
at the end i get the items i want in the SpistItemCollection "col" now i want sum in every loop the items of these collection to get all my items...

thanks, markus

Track documents that have been read

Tue, 24 Nov 2009 15:41:39 Z

HI

I have a request to track the documents in a doc library. The documents in the library have to be read by users of the portal. Each time the user logs in, they will be provided with a list of the documents that they are required to read. As soon as a user has read / opened a document, the item is flagged as read by the that user.

I cannot find any events that fire on document read/open. I was thinking of added an ECB menu and forcing the user to selected when they have read the document. Then have a field against the document to store all the users that have read the marked the document as read,

Can anyone think of a better way of doing this.

Thanks in advance

Sharepoint UserGroup webservice: This operation is not allowed on an object that inherits permissions

Wed, 25 Nov 2009 08:19:16 Z

Hi All,
I am creating a new group and then I am trying to add a role (Read) to the Group by using SharePoint userGroup Web Service. It is throwing the following error message:

This operation is not allowed on an object that inherits permissions.

Here is my code:

                oGroup = new GSK.IW.UserGroup.UserGroup();
                oGroup.Credentials = new System.Net.NetworkCredential(gvMigrator.SharePointUserName, gvMigrator.SharePointPassword,gvMigrator.SharePointDomain);
                // Setting a timeout period of 1000 seconds for creation of the groups.
                oGroup.Timeout = Convert.ToInt32(ConfigurationManager.AppSettings["DefaultTimeoutperiod"]); 
                //Formating the Site URL
                if (strSiteURL.LastIndexOf("/").Equals(strSiteURL.Length - 1))
                {
                    oGroup.Url = strSiteURL + Convert.ToString(ConfigurationManager.AppSettings["UserGroupWebservice1"]);
                }
                else
                {
                    oGroup.Url = strSiteURL + Convert.ToString(ConfigurationManager.AppSettings["UserGroupWebservice2"]);
                } 
                oGroup.AddGroup(strGroupName, (gvMigrator.SharePointDomain + "\\" + gvMigrator.SharePointUserName), Convert.ToString(ConfigurationManager.AppSettings["OwnerType"]), (gvMigrator.SharePointDomain + "\\" + gvMigrator.SharePointUserName), ("Managers for " + strDocumentLibraryName + "Document Library"));

                //Adding the created group to the role:
                 
                oGroup.AddGroupToRole("Read", strGroupName);

Any suggestions?

I have not faced this error before :(. It was working fine for site collection level. Now I am trying to check for the subsites. Please help

Thanks Sridhar

Custom breadcrumb for WSS

Wed, 25 Nov 2009 12:15:40 Z

Hi,

I am working on WSS environment and trying to create a custom breadcrumb, which should suppose to display the parent site title as well as it's subsites

for example: I have a top level site (TPLevel) under than I have a subsite (Subsite) and under Subsite I have one more subsite (Sub-Subsite) so If I browse to the site 'Sub-Subsite' the breacrumb should look like as

TPLevel > Subsite > Sub-Subsite

In the same way if I browse to the Subsite the breadcrumb should look like as TPLevel > Subsite

I am looking for the feasible solution whether it can be using SPD or programmatically
Reply's always appreciated, thank you

Best Regards, G Vijai Kumar | My Sharepoint Blog

EventReceiver getting attached to every list.

Wed, 25 Nov 2009 13:12:27 Z

Hi all,
I have a Custom List and event receiver attached to it. But when i am deploying solution, that event receiver is getting attach to other list also. which is wrong.

I want to attach event receiver to that list only. so is their any configuration i am missing !

Regards
Milan.

WSP Deployment

Wed, 25 Nov 2009 09:51:37 Z

Hi,

I have a .WSP file. I need to how to deploy this in moss. I tried with stsadm but not getting it . Please let me know the steps i need to follow

Vijaykishan | http://v2attechhorizon.blogspot.com | Please mark this as answer if it helps

Import data into list using custom web service

Wed, 25 Nov 2009 11:11:41 Z

Hi Guys

I have one list named "Customer" and alreday developed web service which return the customer data from other server. Now I want to insert this data in my sharepoint "Customer" list usign this web service

We are using only WSS 3.0 no MOSS

Is there any way?

Thanks in advance.

Autocomplete extender + WebParts + UserControl

Wed, 25 Nov 2009 12:13:50 Z

Hello guys,

Im trying to use the AutoComplete extender in my userControl without use a web service. When i do this(without web service) in an aspx page it works perfectly, but when i try to use the autocomplete in the usercontrol it doesnt fire the event in the code behind file. If i use any other extender, usualy it works, but the AutoComplete dont. So my question is: Its possible to use the AutoComplete extender in the UserControl without use web services?

Tyvm.

Custom Webpart for login

Wed, 25 Nov 2009 12:00:45 Z

Hi,

I need a create a webpart for login in aspx. I don't need existing login webparts. I need to deploy this to my site. Please let me know the steps to acheive the same.

Vijaykishan | http://v2attechhorizon.blogspot.com | Please mark this as answer if it helps

Including files with VSeWSS CTP 1.1

Tue, 30 Oct 2007 06:23:24 Z

VSeWSS

Something driving me crazy with the VSeWSS , I'd like the ability to use the classresources in the manifest.xml file, but I can't get other files than the assembly in the solution folder. Mapping to an elementmanifest will get a file in the solution folder, but that's not where I want it.

Exact error:

Cannot find this file specified in the manifest file: azul.jpg

Code in manifest.xml

</ClassResources>

</Assembly>

File is in the project. Can't copy the file to the solution folder because VSeWSS will delete it on building the WSP , can't make it readonly because VSeWSS won't run because it can't delete the file..

My exact question is thus:

How to get a file (image/javascript) in the WSP with the extensions for visual studio...

Regards,

Kees

Clock for Different Zones in Sharepoint Home Page using Javascript

Wed, 25 Nov 2009 11:29:49 Z

Hi

We are displaying Clock in Home page of Sharepoint Site.We display Clock for different Zones lik Montreal,Geneva etc., which are subjected to DST Changes
The time are displayed using a javascript which has hardcoded values like UTC+1,UTC-5 etc.,If DST occurs then we are forced to change the Javascript in the Master Page to display correct time.
Can anybody tell me how to track DST changes automatically in Javascript and apply to Sharepoint Master page.
We have tried many web parts but we dont want to use it as it occupies more space on the page
Any Ideas..please help

Below is our Javacript:

function calcTime(city, offset) {

// create Date object for current location

d = new Date();

// convert to msec

// add local time zone offset

// get UTC time in msec

utc = d.getTime() + (d.getTimezoneOffset() * 60000);

// create new Date object for different city

// using supplied offset

nd = new Date(utc + (3600000*offset));

//return nd;

var day = nd.getDate()

var month = nd.getMonth()

var month1=month +1;

var year = nd.getFullYear()

//document.write("<b>" + day + "/" + month + "/" + year + "</b>")

// return time as a string

return year+"-"+month1+"-"+day
}

function time(city, offset) {

// create Date object for current location

d = new Date();

// convert to msec

// add local time zone offset

// get UTC time in msec

utc = d.getTime() + (d.getTimezoneOffset() * 60000);

// create new Date object for different city

// using supplied offset

nd = new Date(utc + (3600000*offset));

//return nd;

var hours = nd.getHours()
var minutes = nd.getMinutes()

if (minutes < 10)
minutes = "0" + minutes

//document.write("<b>" + hours + ":" + minutes + " " + "</b>")
return hours +":" + minutes ;

}

<table class="WorldTime_Zone" width="100%"
                         style="font-size:8pt;font-family:arial;" align="left">
                        <tr class="BoldTime">
                                <td style="height: 18px;" nowrap>
                                    <b>Universal</b> (<font style="font-size:7pt">UTC</font>)
                                </td>
                                <td style="height: 18px;" nowrap>
                                    <b>Montreal</b> (<font style="font-size:7pt">UTC-5</font>)
                                </td>
                                <td style="height: 18px;" nowrap>
                                    <b>Geneva</b> (<font style="font-size:7pt">UTC+1</font>)
                                </td>
                                <td style="height: 18px;" nowrap>
                                    <b>Miami</b> (<font style="font-size:7pt">UTC-5</font>)
                                </td>
                                <td style="height: 18px;" nowrap>
                                    <b>Singapore</b> (<font style="font-size:7pt">UTC+8</font>)
                                </td>
                                <td style="height: 18px;" nowrap>
                                    <b>Beijing</b> (<font style="font-size:7pt">UTC+8</font>)
                                </td>
                        </tr>

                        <tr>
                                <td>
                                        <script type="text/javascript">
                                        document.write
                                        (calcTime('UTC', '+0'));</script>
                                </td>

                                 <td>
                                    <script type="text/javascript">
                                    document.write
                                    (calcTime('UTC', '-5'));</script>

                                  </td>
                                  <td>
                                    <script type="text/javascript">
                                    document.write
                                    (calcTime('UTC', '+1'));</script>
                                    </td>

                                    <td>
                                    <script type="text/javascript">
                                    document.write
                                    (calcTime('UTC', '-5'));</script>
                                    </td>

                                    <td>
                                    <script type="text/javascript">
                                    document.write
                                    (calcTime('UTC', '+8'));</script>
                                    </td>

</tr>

                    <tr>
                                    <td>
                                    <script type="text/javascript">
                                    document.write
                                    (time('UTC', '0'));</script>
                                    </td>

                                    <td>
                                    <script type="text/javascript">
                                    document.write
                                    (time('UTC', '-5'));</script>
                                    </td>

                                    <td>
                                    <script type="text/javascript">
                                    document.write
                                    (time('UTC', '+1'));</script>
                                    </td>

                                    <td>
                                    <script type="text/javascript">
                                    document.write
                                    (time('UTC', '+8'));</script>
                                    </td>

</tr>
</table>

Thanks,
Anu

Store uploaded files on a shared drive as opposed to directly in the database?

Wed, 25 Nov 2009 11:21:26 Z

Hi Guys,

Generally uploaded files in sharepoint are stored in content database but can we store it on shared drive and use and serch it in sharepoint ?

Thanks

Widget submission framework

Wed, 25 Nov 2009 11:10:04 Z

Hi Experts,

I have to develop a framework in which a user can submit his custom created Widgets (it is similar to submission of gadgets in Google gadgets and flakes in pageflakes.com and so on). For this, I guess I have to create my own objects and APIs so that user can user those while creating a widget.

Can you pls pour-in some thoughts/reference regarding the same.

Thanks in Advance,
SM!

web part properties, is it possible to select multiple lists.

Mon, 23 Nov 2009 11:40:18 Z

I am building a web part which I need to be able to select 1 to many lists to role up the information.

I have successfully got the back end working and the data is rolling up (The lists at this point are hard coded). I am wondering what the best way in the web part property section to get the user to select the lists to include in the role up. I only need the list Guid and no extra filtering is provided at the mean time.

I did consider just a text field with caml but this seems to me complicated for the average user. Is it possible to have a multiple choice field or a popup which will show all the lists for them to select from (is it even possible to limit the lists shown to a specific type?

Any examples would be great as this is the first web part I have created.

Sharepoint CAML query problem for SPQuer.GetItems()

Wed, 25 Nov 2009 09:15:12 Z

Hi

We have discussions webpart customized to us and I want to get the number of discussoins from a particular user. My problem is when I pass the First Name and Last Name of the user (which is the displayname on the ffront end )in my query then I would able to get the correct count but if I pass the username then I am not able to the correct count from that user. Is there a way that I can say that get by username. Please have a look at my SPQuery code:

SPQuery query = new SPQuery();
SPList splist = spWeb.Lists["Forum"];

query.Query = "

"<Where><Or><Eq><FieldRef Name='Author'/>" +
                                    "<Value Type='User'>" + spUsrDisplayName + "</Value>" +
                                    "</Eq><Eq><FieldRef Name='Editor'/>" +
                                    "<Value Type='User'>" + spUsrDisplayName + "</Value>" +
                                    "</Eq></Or></Where>";

query.ViewFields = "";
SPListItemCollection spListColl = splist.GetItems(query);
int discussionsCount = spListColl.Count;

Can any one give me any idea please.

Thanks,

Regards,
Aruna

http GET and security validations, web.lists.add

Wed, 25 Nov 2009 08:00:57 Z

Hi all,

I am developig custom action to listitems EditControlBlock, which is supposed to create list to the current web. UrlAction code is on my _layouts/xxx/yyy.aspx page load, and is rougly following:

protected
 override
 void
 OnLoad(EventArgs e)<br/>

{<br/>

try


{

    SPContext.Current.Web.AllowUnsafeUpdates = true
;

    //SPContext.Current.Web.ValidateFormDigest();


    SPContext.Current.Web.Lists.Add(Guid.NewGuid().ToString(), Guid.NewGuid().ToString(), Guid.NewGuid().ToString(), "9C3ED004-7495-44f1-9DD4-C96BCDA31F82"
, 10100, "1000"
, SPListTemplate.QuickLaunchOptions.On);

}

finally


{

    SPContext.Current.Web.AllowUnsafeUpdates = false
;

}<br/>

}

Page is inherited from LayoutsPageBase.

Even thou i allow unsafeupdates i still get the error message:

The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again. at Microsoft.SharePoint.Library.SPRequestInternalClass.MoveUrl(String bstrUrl, String bstrWebRelOldUrl, String bstrWebRelNewUrl, Int32 grf)
at Microsoft.SharePoint.Library.SPRequest.MoveUrl(String bstrUrl, String bstrWebRelOldUrl, String bstrWebRelNewUrl, Int32 grf)

However, if i run my code on postback, everything goes fine. So how should i do this without postback and what are the best practises on this.

br,

-hk

error with sharepoint when using VS 2008

Wed, 25 Nov 2009 09:15:04 Z

Hello!

I'm using visual studio 2008, i'm using code for sharepoint, when i try it to compile it show me this errorr:

the type or namespace name 'Sharepoint' does not exist in the namespace 'Microsoft'

i'm using

using

Microsoft.Sharepoint; but i don't found the dll in my pc

someone knows waht it is happening?

thank

Programatically change permission to a list for a user ?

Wed, 25 Nov 2009 07:18:17 Z

How do I Programatically change permission to a list for a user ?

Error seen after adding customized web part to web part zone.

Tue, 24 Nov 2009 12:27:49 Z

I have created a simple data capture web part consisting of three text boxes. This has been done using Visual Studio 2008. I have created a corresponding list in my SharePoint site with three identically named columns.

I can build and deploy my web part successfully using Visual Studio 2008. However, when I try to import the web part into my site for testing purposes, I see an error: "Error rendering control - Control Name. An unhandled exception has occurred. Object reference not set to an instance of an object."

I have tried everything I can to try and resolve this. Can anyone help?

Specific web.config -> Configuration object?

Mon, 23 Nov 2009 17:55:01 Z

Inside a web application feature I try to get a Configuration object of the web.config file.

I tried this:

config = WebConfigurationManager.OpenWebConfiguration("/", webApp.Name);
config = WebConfigurationManager.OpenWebConfiguration("/15678", webApp.Name);

=> Exception:
Failed to resolve the site ID for 'MyWebApplicationName'.

('MyWebApplicationName' == webApp.Name).

Why does SharePoint want to resolve the site ID for 'MyWebApplicationName'?

My folder structure looks like this:

C:\inetpub\wwwroot\wss\VirtualDirectories
C:\inetpub\wwwroot\wss\VirtualDirectories\80
C:\inetpub\wwwroot\wss\VirtualDirectories\15678

and the wanted web.config is located in C:\inetpub\wwwroot\wss\VirtualDirectories\15678\web.config.

I've had a look at the msdn docs (http://msdn.microsoft.com/en-us/library/ms151456.aspx) and a comment in this post http://www.andrewconnell.com/blog/articles/CreatingCustomSharePointTimerJobs.aspx but without any success.

How can I access key/value pairs in a specific web.config?

Problem getting permission for the user from the TASK list.

Wed, 25 Nov 2009 09:28:25 Z

Hi All,

I have a document library (namely, Business Services), its attached to OOTB Approval workflow and workflow is attached to the TASK list.
Apparently, I wrote a an event handler (ItemUpdating ) because "contributor" can approve his own document. So, we have modified the behavior of OOTB Approval workflow. Its seems "by design". Please see this link about OOTB Approval workflow issue.

We have 2 users:
1) vm1/contributor (with contribute permission on "Business Services " document library)
2) vm1/approver (with approve permission on "Business Services " document library)

This is my event handler:

The event handler is hooked to the "TASK" list and I am able to get the "vm1/contributor" as well.
But I need to get the permission of the user (vm1/contributor ) who is from "Business services" lists.

Can somebody advice me on this?

Thank you.
--Aroh

 public override void ItemUpdating(SPItemEventProperties properties)
        {
            base.ItemUpdating(properties);

            this.DisableEventFiring();

            using (SPWeb currentTeamSite = properties.OpenWeb())
            {
                 
                // Delcare variables  
                string currentUser = string.Empty;
                
                // Get the current item
                SPListItem currentItem = properties.ListItem;

                Console.WriteLine("Parent list {0}", currentItem.ParentList); // ITS TASK LIST

                // Get the value display name of the current logged in user and Created by Field of the current item
                currentUser = currentItem["Author"].ToString(); // USER FROM "BUSINESS SERVICES"

                // Get the user id as integer 
                int userid = Convert.ToInt32(currentUser.Substring(0, currentUser.IndexOf(";#")));

                // Convert SharePoint user which matches the ID 
                SPUser user = currentTeamSite.AllUsers.GetByID(userid);

                // Now, we have to user's permissions (Document Library, not on the Task)
                
????????????



                                        }


            this.EnableEventFiring();
        }

how to copy folders with items in it from one list to another list in another site collection Programmatically

Mon, 23 Nov 2009 10:20:52 Z

hi all

i wish anyone could help me in this problem

i have a custom list that contains folders as items in the list .Each folder also consists of multiple items in it.

i want to copy the folders with the items in it to another custom list in another site collection using c# code
thanks a lot

Can't get user from workflowProperties.Item.ParentList.ParentWeb.Users

Wed, 25 Nov 2009 08:37:57 Z

Hi guys,

I need to retrieve a user LogonName from Contact Selector Control . I have a user ID from lookup value:

DepChief = DepChiefValue.LookupId;

Now I need to get more info about this user using his ID , but this code return error:



workflowProperties.Item.ParentList.ParentWeb.Users.GetByID(DepChief).LoginName

While debagging I see that there's no user with this ID at



workflowProperties.Item.ParentList.ParentWeb.Users

But still there're others users in this list. So I get error not for every users, but some of them.
I've checked Users and Groups at Site properties - all users are there. Made full import - nothing changed.

Any ideas?

Sharepoint webservices break role inheritance for a newly created group

Wed, 25 Nov 2009 08:57:57 Z

Hi All,
Is there a way to break role inheritance for the objects of subsite using web services provided by wss?

Thanks Sridhar

connect custom list with web service?

Tue, 24 Nov 2009 23:36:18 Z

Is it possible to connect from list to web service. I need to read data from webservice when list loads on to the page and data also need to happend on the web service and update with web service.

If user adds new item I need to call web service method to add and for delete item i need to call web service method to delete and samething for update.

How can we do this?

Jamsbond

Validation form

Tue, 24 Nov 2009 09:27:12 Z

Hello !

I would likt to know how to make a systeme to validate my form "NewForm.aspx".

By example :

- the "hour" field must be between 0 and 24
- select only one field : "hour" or "day" not the both
- "dateend" must be greater than "datebegin"

Thanks in advance !! :-)

Get all items from document library folder or subfolder

Wed, 25 Nov 2009 07:24:27 Z

Hi ppl,

I am wrote below code for sending an email, when item is added/updated through timer job.

Code is working fine, only problem is: my document library has many folders and subfolders. when i added/update the item in folder that item data is not coming in email. Pls tell me how can i fetch all items from folder / subfolder.

public override void Execute(Guid targetInstanceId)
        {
            // your code goes here
            base.Execute(targetInstanceId);

            string webUrl = SPContext.Current.Web.Url;
            using (SPSite site = new SPSite(webUrl))
            using (SPWeb web = site.OpenWeb())
            {


                SPList list = web.Lists["MHN"];
                SPGroup objgroup = web.SiteGroups["AlertEmail"];
                SPUserCollection userCollection = objgroup.Users;

                string strQuery1 = "<Where><Eq><FieldRef Name='Modified'/><Value Type='DateTime'><Today /></Value></Eq></Where>";

                string subject = string.Format("Item has been added/updated in MHN Document Library", list.Title);
                string body = null;
                string strmsg = "These items have been Added or Modified today";
                string strmodifiedby = "";
                string strDTN = "";

                SPQuery objquery = new SPQuery();
                objquery.Query = strQuery1;
                int itemID = 0;

                StringBuilder sb = new System.Text.StringBuilder();

                sb.Append("<html><head></head><body>");
                sb.Append("<br>Dear Sir/Maa'm,<br/>");
                sb.Append("<li></li>");
                sb.Append("<p><strong>" + strmsg + "</strong></p>");
                sb.Append("<table cellpadding=\"0\" cellspacing=\"0\" border=\"2\" border-color=\"white\">");

                sb.Append("<tr>");
                sb.Append("<td>Document Link</td>");
                sb.Append("<td>Title</td>");
                sb.Append("<td>DTN</td>");
                sb.Append("</tr>");

       #region abs

                SPListItemCollection objListColl = list.GetItems(objquery);

                if (objListColl.Count != 0) //send mail
                {
                    foreach (SPListItem item in objListColl)
                    {
                        itemID = item.ID;

                        //string subject = string.Format("Item '{0}' added/updated to '{1}'", item.Name, list.Title);
                        //string body = null;
                        string itemUrl = string.Format("{0}/{1}?ID={2}", web.Url, list.Forms[PAGETYPE.PAGE_DISPLAYFORM].Url, itemID);

                        if (item["Title"] == null)
                        {
                            strTitle = item.Name;
                        }
                        else
                        {
                            strTitle = item["Title"].ToString();
                        }

                        string[] strmodified;
                        if (item["Modified By"] == null)
                        {
                            strmodifiedby = DateTime.Now.ToString();
                            strmodified = strmodifiedby.Split('#');
                        }
                        else
                        {
                            strmodifiedby = item["Modified By"].ToString();
                            strmodified = strmodifiedby.Split('#');
                        }

                        if (item["DTN"] == null)
                        {
                            strDTN = "NA";
                        }
                        else
                        {
                            strDTN = item["DTN"].ToString();
                        }



                #endregion
                        //sb.Append("<tr>");

                        sb.Append("<tr>");
                        sb.Append("<td><a href='" + itemUrl + "'>" + item.Name + "</a></td>");
                        sb.Append("<td>" + strTitle + "</td>");
                        sb.Append("<td>" + strDTN + "</td>");
                        sb.Append("</tr>");

                    }
                        sb.Append("</table>");
                        sb.Append("</body></html>");

                        body = sb.ToString();


                    foreach (SPUser user in userCollection)
                    {
                        if (string.IsNullOrEmpty(user.Email)) continue;
                        SPUtility.SendEmail(web, true, false, user.Email, subject, body);
                    }
                }
                else
                {
                    Console.WriteLine("Email does not exist");
                    Console.ReadLine();
                }
            }
        }

Hemendra

Export a Custom List as CSV

Wed, 25 Nov 2009 06:40:41 Z

Hi all,

Is it possible to export a custom list to as CSV(Comma Separated Value) File pro grammatically in share point?

123456

Form Authentication Module Problem

Tue, 24 Nov 2009 06:35:46 Z

Hi All,

        I created one Form Based Authentication module(FBA) using ASPNET Membership provider in VS.NET 2005.It has sent the auto generated password in email once the member registered .I created two web application in production server where i deployed my FBA.Both site are internet site.one of the web site ,member created and email sent to them correctly.But i encountered the problem is that another site in the same server where the member created and not email sent to the member.Both site have different database for FBA users.Sites both referred same FBA module and i kept formatted email as xslt under the /_layouts folder which invoked by the FBA module.

        I used SPUtility for send email to the members.It logged error such as Remote name could not be resolved : 'sitename' at system.Net.HttpRequest.GetResponse() at system.xml.xmldowloadmanager.getNOnFileStream(uri,uri,,) at system.xml.xmlurlresolver.getentity(,,) at system.xml.xsl.xslt.xsltloader.createReader() at system.xml.xsl.xslt.xsltloader.load() at system.xml.xsl.xslt.compiler.compile() at system.xml.xsl.xslcompiledtransform.compilexslttoqil() at system.xml.xsl.xslcompiledTansform.LoadInternal()

      I stuck here ,anybody know how to trace this problem.why did it not send email in particular site?.

     Thanks,
     Kousalya.

SPGridView HyperLinkField won't shown hyperlink?

Tue, 24 Nov 2009 20:13:44 Z

Could you plesae help me? I have been trying different combinations for several days.

I am programming a Visual Basic web part in Visual Studio 2008.

I can't get the account_no to show a link, no matter what I do. It always shows vanilla output text.

Here is the code:
Dim cS As New GetCustomersWebPart.ConnectionStrings
            Dim vConnStr As String = cS.Siebel
            Dim con As OracleConnection = New OracleConnection(vConnStr)
            con.Open()

            Dim vSQL As String = _
            "SELECT account_no, " & _
                    "name cust_name, " & _
                    "state||' '||zipcode st_zip, " & _
                    "region, " & _
                    "cust_stat_cd " & _
              "FROM siebel.mw_sales_heir " & _
             "WHERE emp='" & UCase(vUserName) & "' " & _
             "ORDER BY 1 "
            'lblOutput.Text = vSQL

            Dim cmd As New OracleCommand(vSQL, con)
            Dim da As New OracleDataAdapter(cmd)
            Dim cb As New OracleCommandBuilder(da)
            Dim ds As New DataSet("Cust")
            da.Fill(ds, "Cust")

            Dim vGv1 As New SPGridView()
            vGv1.ID = "gvSiebel"
            vGv1.DataSource = ds.Tables(0)
            vGv1.DataBind()
            vGv1.AutoGenerateColumns = False

            Dim hlfAccount As New HyperLinkField()
            Dim vStr(0) As String
            vStr(0) = "account_no"

            hlfAccount.DataTextField = "account_no"
            hlfAccount.DataTextFormatString = "{0}"
            hlfAccount.DataNavigateUrlFields = vStr
            hlfAccount.DataNavigateUrlFormatString = "~\AccountReports?accountno={0}"
            hlfAccount.HeaderText = "Account No"
            'hlfAccount.HeaderStyle.HorizontalAlign = Web.UI.WebControls.HorizontalAlign.Left
            hlfAccount.Target = "_blank"
            vGv1.Columns.Add(hlfAccount)

            Dim bfCust_Name As New SPBoundField()
            bfCust_Name.DataField = "cust_name"
            bfCust_Name.HeaderText = "Account Name"
            bfCust_Name.HeaderStyle.HorizontalAlign = Web.UI.WebControls.HorizontalAlign.Left
            vGv1.Columns.Add(bfCust_Name)

'others SPBoundField() items are added below

How to integrate silverlight 3 webpart in sharepoint site.

Tue, 24 Nov 2009 06:34:24 Z

I tried with this link - http://msdn.microsoft.com/en-us/magazine/dd148643.aspx#id0100027
I am facing problem in placing the .xap file in the sharepoint server and i guess its web.config is to be modified. The problem here is the Clientbin folder of the web application folder has the .xap file. Now i copied the same Clientbin folder(contains only .xap and .wmv files) to sharepoint server. But i get an empty webpart on site without the media player. Kindly let me know what i am missing out.

how to develop web parts for weather, news, etc?

Tue, 24 Nov 2009 22:30:09 Z

hi there,

i know it's a big topic, just want some helpful links or blogs to get some ideas how to develop the web parts used as gadgets on a page to get info of weather, news or even stock or sports events. thanks in advance.

allan

webpart

Wed, 25 Nov 2009 05:46:44 Z

i am displaying some details from database1 in a gridview.
when i select first field(a hyperlink) i need to display some results(grid) in another webpart which are taken from another database2.

Can anyone explain in detail how to find solution for this

Is it possible to save a template to my desktop?

Tue, 24 Nov 2009 22:29:13 Z

I created a site in a sandbox situation. Is it possible for me to save it as an .stp file to my desktop so I can re upload it into a new template gallery on a different site?

Problem displaying a webpart in MOSS 2007

Fri, 20 Nov 2009 13:03:58 Z

Hi,

I have written a webpart which internally calls WCF service and displays data.
When I copy this code into .net windowss form and run, it works fine.
When I deploy this webpart to MOSS 2007 (same box) and add this webpart to a page, I do not see the webpart in MOSS page.

When I debugged the webpart in visual studio 2008 when the MOSS page was loading, I saw that it was failing to create an instance of the wcf service.
But it does not show the error [says - Cannot obtain value of local or argument 'ex' as it is not available at this instruction pointer, possibly because it has been optimized away].
Event viewer show the error - Error: Failure in loading assembly: <name>.

The WCF service which I am calling inside webpart has anonymous access enabled.

I have added an entry in the web.config of MOSS under <SafeControl> and also <system.serviceModel> <bindings> and <client><endpoints> (copied from the configuration.svcinfo of the wcf service ref)

Appreciate any help on this.
Thanks.

WebPart Feature scoped to Web does not get populated to special group

Tue, 24 Nov 2009 17:48:24 Z

Hi,

We want to deploy a webpart with scope="Web", so that it will be available only for a subsite where this feature is activated and we also want to have this webpart to appear under a special category instead of miscellaneous group.

I have created the required feature.xml, elements.xml, .webpart file. This work fine when the feature scope is set "Site", but when I change the scope to "Web" and then after activating the feature,

1. I do not see the webpart in WebPart gallary.
2. Also when I try to add a webpart using add web part button, I do not see those webparts, I have to explicitly populate those again
3. After explicitly populating those webpart, it comes under the miscellaneous group not in my special group

This means when the webpart feature scope is set to "Web", none of the properties set in elements.xml and .webpart file are working. Does it mean I cannot create a group for my webpart when then feature scope is set to "Web"

There is an another thread (http://social.msdn.microsoft.com/Forums/en/sharepointdevelopment/thread/87b224e6-8053-4db1-9314-f8f7b6371197) which has discussed a similar issue, but I don't think it been answered there.

Thanks in advance,
Sanban

Is lookup field content type supported in VSeWSS 1.3 ?

Tue, 10 Nov 2009 12:40:58 Z

In the VSeWSS 1.2, I cannot create lookup field by using content type. I have two list has been created by using content type: Contact and Address, in the Address list has a column look up a field in the Contact list. I cannot do that. Please let me know: Is VSeWSS 1.3 supported that thing?

Thank all very much.

Nguyen

Why breakpoint not caught?

Mon, 23 Nov 2009 02:42:59 Z

I have a question. I have been creating this event receiver and then trying to attach to iis process for debugging purpose as we used to on standard web applications. But strange thing is, sometimes it works and sometimes it doesn;t. Does anyone know why?

My way to do it is clean, build, deploy. And then attach to w3wp. Then on Sharepoint, i hit the edit form (as i am working on item updating). Sometimes the breakpoint get caught but sometimes it just doesnt wanna do it.