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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

One user in group waiting results forever using BDC data filter

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

I gave a group of users to be able to search a plan name through a BDC filter on SharePoint 2007. All the users have no problems to access BDC data sources, but only one user in the group got waiting on the searching results forever. But this user has no problems to use any other SharePoint features.
I will appreciate it your any ideas.


View Complete Post

More Related Resource Links

[SQL] can we filter data after group by?


with SaleSheet(SaleDate,SaleAmount,VipId) as
select '2010/02/01' as SaleDate ,10 as SaleAmount,'Allen' as VipId
union all
select '2010/02/01' as SaleDate ,20 as SaleAmount,'Allen' as VipId
union all
select '2010/02/01' as SaleDate ,20 as SaleAmount,'Joy' as VipId
union all
select '2010/02/02' as SaleDate ,10 as SaleAmount,'Allen' as VipId
union all
select '2010/02/03' as SaleDate ,20 as SaleAmount,'Allen' as VipId      -- Allen reach the thresold  on 2010/02/03
union all
select '2010/02/04' as SaleDate ,10 as SaleAmount,'Joy' as VipId
union all
select '2010/02/05' as SaleDate ,10 as SaleAmount,'Amy' as VipId
union all
select '2010/02/05' as SaleDate ,10 as SaleAmount,'Joy' as VipId
union all
select '2010/02/05' as SaleDate ,50 as SaleAmount,'Amy' as VipId        -- Amy reach the thresold  on 2010/02/05
union all
select '2010/02/06' as SaleDate ,10 as SaleAmount,'Joy' as VipId
union all
select '2010/02/06' as SaleDate ,10 as SaleAmount,'Amy' as VipId
union all
select '2010/02/06' as SaleDate ,10 as SaleAmount,'Joy' as VipId

-- I run Query on 2010/02/06 and want to know which member reach the thresold ( SaleAmount > 50 ) be

How to pass current user to bdc list to filter data.

Hi all,

I have a bdc list which I want to load on the basis of the currently logged in user. I've tried to use the Current User Filter Web Part provided OOB but it doesn't seem to solve the problem cu'z I can't bind the current user value of the webpart to any column of the bdc list.

The problem is, I want to load the records based on the current user by passing the user name to Stored Procedure. Does any one know how to do that ???? Please F1.



SharePoint BDC data search waiting forever


I have a SharePoint BDC filter access issue with only one user in a group of users.
I gave a group of users to be able to search a plan name through a BDC field. All the users have no problems, but only one user in the group got waiting on the searching results forever.

So, could you please give me any ideas what may cause this problem happened?

Thanks for your help,

Linq - add data to database then email user the details


Hi all

I'm not sure how to structure the code for this but what I want to do is be able to add data to a database, and once this has completed successfully, then email the user to say the details have been added successfully to the database.

I need to:

1. Check that the relevant data has been added into the database then

2. Email the details of the relevant data when completed. 


Thanks in advance for your help,




logged in user data


I'm using the defualt membership provider, i created a table and used the gridview on the logged in user page to show his information such as address e-mail phone zip code etc,, how can i do this without writing a code?

I am new to asp.net  i need simple help please?

Storing User Data



I'm trying to get the current logged in UserId Value, using this code

Protected Sub UserProfileDataSource_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles UserProfileDataSource.Selecting      ' Get a reference to the currently logged on user      Dim currentUser As MembershipUser = Membership.GetUser()      ' Determine the currently logged on user's UserId value      Dim currentUserId As Guid = CType(currentUser.ProviderUserKey, Guid)      ' Assign the currently logged on user's UserId to the @UserId parameter      e.Command.Parameters("@UserId").Value = currentUserId End Sub

But, I getting an error (NullReferenceException), I did set a url authorization on the page that i try to get the logged in user information, witch is info.aspx, and I made the login.aspx control to be redirected to the info.aspx after the login process, But the info.aspx  only shows me (access in denied), how can i make this page knows that i am already logged in?

Persist data in a dynamically populated ListBox in a user control


Hi All,

I am trying to persist data in a dynamically populated ListBox in a user control. Here are the details

I have a user control which contains a a listBox and button. On Page_Load of user control I am populating the ListBox control with some values. On Click of button, I am trying to fetch the values which I have selected in ListBox. Though this seems very simple and straight forward I am unable to fetch values.

My Page_Load Function

void Page_Load(object sender, EventArgs e)










My Click Function

Protected Void Button1_Click(object sender, EventArgs e)


       string strValue = listBox.SelectedValue



I have placed brake point at Page_Load and on click function, I am seeing that the moment the breakpoin

Toolbox: User-Friendly UIs, Online Data Entry Controls, and More


Microsoft® Office is one of the most well-known and most-used consumer products. For many people, their only experience with a computer is when using Office, be it checking e-mail, creating presentations, or writing a document.

Scott Mitchell

MSDN Magazine February 2006

Insert data based on gridview user value on row.. how to



I have three column comes from database table(Table1) and one column is for entering data for the user let us consider it look like this 

ItemNo ItemName Qty  uservalue

001       A               50       20

002       A               20       5

003       B               50  

004       C               60      10

005       D               40 

006       E               90      15 


If its 300 row from database to gridview it will show 50 record with page navigation..

What i need is i need to insert data in to database table which gridview row has user value..

The output of the another table(Table2) will look like this after insert

ItemNo ItemName   uservalue

001       A                    20

002       A                      5  

How to process data AFTER page is completely loaded for the user?


I have some logging that has to be done, which are some database update or inserts.

However this logging is of no importance to the user, so I only want to process the data/logs after the page is completed for the user.
As of now, if I process the data while the page is loading, I go from 1.4 to 2.0 speed (server side time processing of code), which is quite a bit comparing it is of no use to the user.

So I want this code only executed after that the page is complete.

I've been checking out Ajax, async pages etc, but the problem is it still gets executed before the page is rendered to the client, which means the client will have to wait longer then it is not being processed.

I've been checking out Threadpool.queueBackgroundWorker, however if I get it correct, this will still be executed before the page is shown to the user, as it has to complete before the prerender.

Then I thought about creating a new thread, and do the processing there, which would not have my page waiting to complete the data/logging.
However when I have 100 or 200 users loading pages at the same time, then that would mean I would be creating 200 threads on those loads, which I doubt will be good for performance. So if I want to solve this, I would have to create my own threadpool and only assign for example a max of 40 threads to it which can pr

Pulling data from MyProfile page to People & group's list

Hi, Is it possible to pull the data from Profile page, like the email, contact number etc to be displayed in the People & Groups page. Please refer the screenshot for better understanding..

Link to the image: http://img694.imageshack.us/i/pplgrps.png/

Send an Email with User fields data entered in the form


Hi All,

          I have a form which have some user input fields(like textboxes,dropdownlists,textarea etc) fields and a submit button.

on click i need to send email with body contents as all the details entered by user in the form

Can anyone suggest how i should approach to this in sharepoint..

any code examples would be appreciated.


Modify User in Collect Data from User Workflow


I've created a workflow with a Collect Data from User action that emails a Group when the task is created. Once the task is claimed by an individual, the Assigned To column in the task list is updated to display that person's name but once the task is completed the email variable for the action is not updated and the group is emailed instead of the person listed as Assigned To.

So the question is this: Is there a way to update the user varialbe in the workflow task once the task is completed, or would I need to build my own workflow and use the Send Email action?

create current user filter in sharepoint designer or wss3

hi, how can i create a current user filter in sharepoint designer?

Sharepoint list group by column data ,display in webcontrol like panel or label


I  have a sharepoint list[Managers] with groupby sector column. like below




Each Sector group by column data i want to display in label or panel control.

How to do that ? how to write the logic?



Regards, Mansoor

User group invalid for new document



Defined a user group and a site column of type people/group directing to this group.

Also defined a content type and added the site column to this content type.

When I create a new word document of this content type, word opens displaying my site column ok. But when I enter it, I see that all active directory (AD) entries are displayed. I want it to display only those users I added to the user group I created. Moreover, users can select any user from AD, which makes defining a user group and a site column meaningless.

This problem is only in creating new documents with Word. If I edit properties of an already existing document in my site, everything is ok: I can select only the users in the group.


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