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

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

summing value in dataset2 based on location group in dataset1

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
I have two datasets where I pull date from for this report...dataset1 has sales by month and location and trans dataset has trans spend by locaiton and supplier.  I want to include sales in a location groups but only sales for that location in the group....right now it seems to sum up all the sales even though I put the sales figure inside the location group... how do I do that...do I use a iif function?? do I need to do something with parameters?

View Complete Post

More Related Resource Links

Location-Based Metadata #sp2010plaintalk

This is the first post in a series of SharePoint 2010 plaintalk (#sp2010plaintalk) aimed at SharePoint professionals who are exploring features of the platform, typically to do feasibility assessments for applying platform features in projects. With every new version of the platform I tend to spend a lot of time digging through the marketing and technical content of the new features to understand what a new feature *really* does. We'll start out with a small one on Location-Based Metadata (sounds...(read more)

Data Bindings are Disappearing and reappearing based on location of other bindings on page

Using Dreamweaver CS3 to design a classic ASP page connected to MSSQL db.  When recordset is tested with a default value, all db fields are returned successfully, but when web page is viewed, random data values won't display.  If bindings are moved around on the page, this can cause other bindings to disappear with no recognizable pattern making troubleshooting the issue next to impossible.  I have never seen this before and wondering why this might be happening.  If anyone can help me, i would sincerely appreciate it!

Find location based on longitude and latitude



can you explain a bit more about  using google map api in asp.net3.5 using c#.

and please tell me one thing how to give latitude and longitude and identify the location (from givinglongitude and latitude).

Setting .net windows control location based on Screen width

I am developing an windows application in 20 inch moniter. I am positioning the controls in WPF like this

scrollViewer1.Height = Screen.PrimaryScreen.Bounds.Height / 5;

If I run this application in 15 inch monitor whether it will change the position of the control or it will give the look and feel what i expected.

Please clarify?

If it will chnage the positioning,please suggest how to poistion the control to support all screens widths.

Get the user details based on the group


I am getting the details from groups but some groups have data but did not return any data is there any problem with this code. some groups have returned data .

CN=Tets App_Reviewer,OU=Tets Appl Groups,OU=District Wide Groups,DC=tets,DC=com;

Tets App_Reviewer is  the group name

public List<ADUserDetail> GetUserFromGroup(String groupName)
            List<ADUserDetail> userlist = new List<ADUserDetail>();


                _directoryEntry = null;

                DirectorySearcher directorySearch = new DirectorySearcher(SearchRoot);

                directorySearch.Filter = "(&(objectClass=group)(SAMAccountName=" + groupName + "))";

                SearchResult results = directorySearch.FindOne();

Display columns in matrix based on a group even if data don't exist in resultset


I am trying to create columns in a matrix for data that currently does not exist.  I created a matrix that groups on office name (ROWS) and Month of Appointment Date (Columns).

For example, the matrix currently looks like this.....

  January February March April

Show users based on ad-security group or OU


Will it somehow be possible to show members of a AD group ?

We have some superusers, and they all have the ad-group: super_users.

Can i show all members somehow ?

Maybe by a search flag, so it is just a link to a search result ?

Jakob Olsen

How to Programmatically Upload the files based on the current location in the document library?


how can programmatically to upload a file to document library based on the current location for example when i was inside the subfolders and click on the custom button in ribbon it should upload file to current location entered to document library not hardcoding the subfolders name 

Thanks in advance

Show/Hide fields on InfoPath based on context User Group Membership

I am reading a book on SharePoint 2010 Development by Wrox and although it is a good book, the InfoPath section is limited. I am Googling to see if I can find anywhere where i can perhaps have this type of functionality to hide and show a specific field based on their Group Membership?
Victor Palma

Adjust document permission based on custom property-field (owner person or group)


I would like to setup a workflow so everytime a user adds a new document to a document library the workflow adjusts the documents permissions.

I've added a new field to the document library settings which I called "Owner". This field searches persons or groups in the active directory. The person of group that I fill in here has to get contribute-permissions for this document. This process needs to be automatic so I think I have to build a workflow.

Who has got experience with this? Who can help me? Can I do this with the Sharepoint Designer?

The system we use is a sharepoint server WSS3.0

Location-Based Services Using CellID in Android

An earlier article about Android showed you how to interface with GPS receivers to obtain the geographical position of a device. However, not all today's mobile devices have built-in GPS receivers. Moreover, GPS does not work indoors. This seriously limits the usefulness of applications built around GPS technologies. One good way to expand the utility of your LBS services is to use your device's cell ID. This article will show you how to obtain the cell ID of an Android device and then use the Google Maps API to translate this cell ID value into latitude and longitude.

Problem to group radio button across gridview rows

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

5 GridView Themes Based on Google's Personalized Homepage (igoogle)

One of the silly features I have found that I like about igoogle is how the pages color palette changes depending upon the time of day. So as the day progresses from morning to afternoon to evening the colors on the page change as well. Like I said, I know this is a silly feature, but I like it. And I have asked around a little bit and seems like other people like it to. To get a better idea of how the colors change, here are the background images from a few of the HTML elements.

Group Calendars in SharePoint 2010

One of the many requests I had in SharePoint 2007 was the ability to place SharePoint Calendars on top of each other like you can in Outlook 2007 saving you having to look at each and work out when the best time is for a meeting.

dynamically adding sql server columns based on number of files in fileuploader


I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files. 

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.


I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!


Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")


Unique content within master page based on conditions met


 Hi all-

I would like to present users with unique content based on certain conditions being met as they land on the home page (default.aspx).  The condition logic will be in the VB code behind Page Load event. The content will go in a content placeholder as specificed from the master page. 

However, the content change wouldn't be something small (ie making a panel or label visible or not) but rather it will be different HTML,  Divs and databound gridview content.  The HTML content will be stored in the database.

Can someone point me in the right direction for best practices on how to accomplish this?


ListViewControl - how to group items by their value, for eg. date range



I have a table containing courses, columns are 

Name - "Yoga Classes"

DateStart - "2/23/2010"

DateEnd - "2/24/2010"

I am using ListView Control to bind it, is there a way to display them and group them by Month? 

for eg.


Piano Class (10th Jan 2010 - 11th Jan 2010)
Guitar Class (10th Jan 2010 - 11th Jan 2010)


Yoga Class (15th Feb 2010 - 16th Feb 2010)

Thanks for help.

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