.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

After using Proc_AddListItem it doesn't show in the GUI List View??

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#
 

I am using SSIS to pull a list from our production database to get a list of names and compare it to a list in sharepoint, then update the sharepoint list with any new names. Right now what I have working is a lookup transformation from our production database to the sharepoint database and an output file destination to put all the new names in.

so it looks something like this in my data flow....

get production data -> convert it so it matches sharepoint data types ->lookup the values in sharepoint and compare them to production ->output any names that don't match to an excel file.

This works great!

here's what I need to do...

Once I get the new names, I need to insert the new names back into the sharepoint list. I have been testing the Proc_addlistitem in Sharepoint to accomplish this and the procedure actually works great and puts the list item in the AllUserData table perfectly! The problem is that Sharepoint doesn't update the actual listitems on the client side. For example, I insert a new item and validate the data, then I go to our local sharepoint site and the listitem DOES NOT appear in the list! What! I can't figure this out.

I can't move on to the next step in my data flow without figuring out why Sharepoint is not showing my data after inserting values.

PLEASE HELP!!


View Complete Post


More Related Resource Links

list view connection filter doesn't work

  
  I have  a custom display form for documents library with two connected List View WebPart. I am trying to filter documents at the second list view with the value from the first one. Both list views contain data from the same documents library. I have configured the connection, but second list doesn’t display any item, and it doesn’t matter which field I use for filtering. Also  for another document s library’s custom  display form  it work perfect.But there second list view contain data from another documents library. Not the same as at first   case. Any ideas with my issue?

Show value from Lookup List inside a view

  
I've got a Categories list, a Product list with a Category field defined as lookup value. The Product list is used in an OrderLine List. How can i show the category value from the selected Product in the OrderLine view? I tried calculcated columns, but they don't work on lookup columns. Would this be possible by creating a custom FieldType? (without performance problems, i assume there's a reason why calculated values don't work on lookup columns) Thanks Marco

data view web part unable to show data from list in subsite

  

Hello all,

In 2007, I never had any issues with doing this. In 2010, I created a web part that looks at the Pages list and pulls a few columns and as long as I am within the site, it works fine. But I need to call information from the Pages list in a subsite and display that information on the parent site default page.

In 2007, I made this work by changing ListID to ListName and DefaultValue="Pages" and then change the WebURL to DefaultValue="/SubsiteName/" then place it anywhere and it found it. Now if I change the ListID to ListName and default value to Pages I get an error that the web part cannot be imported. if I try using the actual ListID and change the WebURL to the subsite, I get an error that the web part is looking for a list that does not exist. This worked so easily in 2007.

Any one able to tell me what's going on? Or have a solution?


data view web part unable to show data from list in subsite

  

Hello all,

In 2007, I never had any issues with doing this. In 2010, I created a web part that looks at the Pages list and pulls a few columns and as long as I am within the site, it works fine. But I need to call information from the Pages list in a subsite and display that information on the parent site default page.

In 2007, I made this work by changing ListID to ListName and DefaultValue="Pages" and then change the WebURL to DefaultValue="/SubsiteName/" then place it anywhere and it found it. Now if I change the ListID to ListName and default value to Pages I get an error that the web part cannot be imported. if I try using the actual ListID and change the WebURL to the subsite, I get an error that the web part is looking for a list that does not exist. This worked so easily in 2007.

Any one able to tell me what's going on? Or have a solution?


Group By With Collapse="TRUE" doesn't show list item.

  

I created a SharePoint Page.  I then inserted an XsltListViewWebPart web part via SharePoint Designer 2010.  I then modified the CAML to include a couple of filters.  I then added a start date and end date parameter.  Then I saved my page and went into SharePoint.  I added two date filters (start date and end date) and I connected them to the  XsltListViewWebPart web part.  Then I selected a start date and end date and the list is correctly filtered.  The list is grouped by district and location.  However, when I expand the district and then I expand the location, it says "Loading...." but then it never loads anything.  If I change it to Collapse="FALSE" everything works fine???  Any help would be greatly appreciated.

Jason

 

 

<Query>
     <Where>
      <And>
       <And>
        <Geq>
         <FieldRef Name="Created"/>
         <Value Type="DateTime">{StartDate}</Value>
     &n

Disable filtering on a Dynamic Data list view.

  

I have an entity set of NotificationTemplates, and each one of these has a collection of zero-many SmsTemplate entities. When editing or viewing a NotificationTemplate, I have a link to View SMS Templates. That link takes me to a List view for the SmsTemplates entity set, filtered for the NotificationTemplate I was viewing.

How can I prevent the user changing this filter to show SmsTemplates for another NotificationTemplate? That is, I want the filter, but it must be read only. The drop-down just mustn't drop down, it must just display the name of the NotificationTemplate that these SmsTemplates belong to. To view SmsTemplates for another NotificationTemplate, the user must click View SMS Templates from that other template.


This was originally asked by myself on SatckOverflow at: http://stackoverflow.com/questions/3514373/disable-filtering-on-a-dynamic-data-list-view



show data in grid view error Arithmetic operation resulted in an overflow.

  

sir

i have a table there is 17 columns in 17 column 3 are number and other are varchar . when i try to display all data of that column error occures.

one more intersting think is when i try to display 6 column then grid show there data an no more error occures. 

when i run my project this error occures in grid view

Arithmetic operation resulted in an overflow. 


Is it possible to show the displaying name instead of value in list?

  

Hi,I just created a custom field type to show all the users of the site.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using System.Web.UI.WebControls;

namespace WSS.CustomContentFields
{
  public class UserFieldControl : BaseFieldControl
  {
    protected DropDownList ddlUsers;
    protected override string DefaultTemplateName
    {
      get
      {
        return "UserFieldWebControl";
      }
    }
    public override object Value
    {
      get
      {
        EnsureChildControls();
        return this.ddlUsers.SelectedValue;
      }
      set
      {
        EnsureChildControls();
        this.ddlUsers.SelectedValue = (string)this.ItemFieldValue;
        
      }
    }
    

    protected override void CreateChildControls()
    {
      if (this.Field == null || this.ControlMode == SPControlMode.Display)
        return;
      base.CreateChildControls();
      this.ddlUsers = (DropDownList)TemplateContainer.FindControl("ddlUsers");
      if (ddlUsers == null)
        throw new Exception("Error: cannot load .ascs file");
      if (!Page.IsPostBack)
      {
        SPSite siteCollection = new SPSite(SPContext.GetContext(System.Web.HttpContext.Current).Site.Url);
        SPWeb site = siteCollection.OpenWeb()

VWD 2008 express does not show design view

  
Hi, hope somebody can help me. I was doing a tutorial with VWD and SQL (security Tutorial).I was having a problem making the application to use my own database instead of the default aspnet.db.Don't know what happened, but after reinstalling VWD a few times I had all sorts of problems, VWD would not uninstall etc.so  I used an uninstalling software and must have deleted some files.I know I got a message saying missing ENU\vs_setup.cab. Anyway the problem now is that after I succeded in reinstalling everything I needed, VWD,SQL and Management Studio VWD does not show the design view bur only souce view, Can you help me with htis problwm?Thank you very much.Carlo

Workflow doesn't work anymore after renaming list

  
Hi All, I have created a list with the name "helpdesk test". After testing this list i renamed the list to "helpdesk". I did the rename by the list settings.  To this list i attached some workflows, with Sharepoint designer,  that have to start when a new item is created. All worked fine but after the rename the workflows don't work anymore. When i start the workflows manually from the list all works fine. Is there a way to rename a list and let the workflows work as before? Thanks in advance. Laurens.      

Calculated date field displays differently in List View and Data View web parts

  
In SharePoint GUI I created a simple custom list with a calculated Date/Time field (Due).  The calculation is =[Created]+7.  I'm trying to display this data on a page using a DVWP.  But first, for testing purposes, I also created a second calculated Date/Time (TestCreate) field in my custom list that is simply =[Created]. In the List View from within SharePoint, the dates show as expected (for example): Created = 8/12/2010 3:45 PM Due = 8/19/2010 3:45 PM TestCreate = 8/12/2010 3:45 PM In SharePoint Designer, I added a Data View web part and the above three data elements (each configured to display mm/dd/yyyy hh:mm:ss tt).  I see the time displayed for the example list item as: Created = 8/12/2010 3:45:30 PM Due = 8/19/2010 10:45:00 AM TestCreate = 8/12/2010 10:45:00 AM I've tested a couple scenarios and the calculated fields always display five hours in the past (along with dropping the seconds).  It seems like the DVWP is returning the date in a different time zone (with no seconds).  The lcid is set right (1033).  I didn't see any time zone settings for the DVWP specifically.  I'm basically stuck.  Could someone help me figure this one out. Thanks.

list webpart, not using the sourse url, but referring back to the library view on close.

  
i have a webpart which brings a list in to my front page. -when user clicks, it shows  the item, and when he clicks on close,it takes him back to the library view. not back to the page,from where the request has initiated. we are using f5 load balancer, and our webapplications are extended. is there somesetup i am missing, so that i can make the sourse url's refer back to the originating page.        

Redirecting a view doesn't work

  
I have the following class that I have all my controllers inherit from:  using System; using System.Collections.Generic; using System.Diagnostics.CodeAnalysis; using System.Linq; using System.Security.Principal; using System.Web; using System.Web.Mvc; using System.Web.Routing; using System.Web.Security; using LMWebUI.Models; using LMWebUI.Components; namespace LMWebUI.Controllers { public class BaseController : Controller { private UserSettings _currentUser = null; private HttpContextBase _currentContext = null; public UserSettings CurrentUser { get { if (_currentUser == null) _currentUser = UserHelper.GetUser(_currentContext); return _currentUser; } } public string CurrentController { get { return Utility.LastSplit(ToString(), '.'); } } public void SaveUser() { UserHelper.SaveSettings(this.HttpContext, CurrentUser); } protected override void Execute(RequestContext requestContext) { _currentContext = requestContext.HttpContext; if (Utility.FixNull(requestContext.HttpContext.Request.QueryString["noScript"], "") == "true") { CurrentUser.ScriptingMode = UserSettings.ScriptMode.NoScript; } else { if (CurrentUser.ScriptingMode == UserSettings.ScriptMode.ScriptDetection && Utility.ReadCookie(requestContext.HttpContext.Request.Cookies, "HasScri

List view - inline editing with read only fields

  
I'm new to sharepoint and using SP2010. I would like to use the inline editing feature of list view and at the same time to lock some of the fields. Is there a simpler way to achieve this like adding some field property using SP designer?

List View Permissions and Views for Web Parts

  
My fellow developers and I are going in circles a bit with our new Sharepoint 2010.  This question probably has several different answers.   I have a list of grades and comments that our Team Leaders want to create and save on Sharepoint.  When saved, the user who was graded should be able to see their own grades.  Its a pretty simple requirement and I'm 90% of the way there.   I created a list with the required fields, and two separate views.  The first view filters the list by the user's name so they see on their grades.  The second view shows all grades in a grouped order by the person who assigned the grade.  To make this second view more readable, I added some formatting with Sharepoint Designer 2010.  It looks nice.   Here's where the speed bump occurs.  I create a web parts page for each view.  The page showing only the user grades works as expected.  The other page, however, shows the list in a view that I didn't create.  No matter what view I select from the "Edit Web Part" menu, it always shows this strange view.  If I select the list, it says its current view is "Default".  The second view I created is set as default, but its not the view I see.  If I change the current view from list menu to the second view specifically, it shows up correctly. &n

Develop consumer which receiving data from list view

  
In my page I want to display a list view. Each time a user is clicking  on an item the relevant data of the current item will be passed to a consumer web part that I will develop. What interface the list view WP inherit from? Can you give send me an example of such implementation?   Tnx Keren  
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend