.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

Multiple Charts at the same time

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :Sql Server



I have the below data. I have the Location as the category field, and Ave as the data filed on a bar chart. Is it possible to generate one report for each Speaker without using a parameter? I have around 50 speakers and I don't want to generate one chart at a time.

Thank you


View Complete Post

Location Ave Speaker
Miami Beach, FL 96.67 John Smith
Sarasota, FL 92.38 John Smith
Augusta, GA 94.44 John Smith
Mobile, AL 87.5 John Smith
Chattanooga, TN 90.67 John Smith
Charleston, SC 100 John Smith
Individual Average 93.61 John Smith
Charlottesville, VA 80 Joe Doe
Individual Average 80 Joe Doe
Great Falls, MT 89.52 Sam Jones
Lincoln City, OR 86.67 Sam Jones
Individual Average 88.53 Sam Jones

More Related Resource Links

how to write a stored proc to prevent multiple users in uploading the reports at a time? plsss help



I wanted to know how to prevent more than one user from uploading the report at a time .I am new to .net ,plss help with the code that would be great.Details are below:

This is a Windos based app written in c# . When User A  clicks Upload option on  one server  from the menu  to upload the files  and at the same time when User B clicks Upload option on different server , User B should be alerted a message saying "User A's uploading is in progress,pls wait" . How to achieve this, plsss help with the code.. I am thinking this logic should be kept in a stored proc, How do I write that proc? plss help


Thanks in advance!

Multiple insert at the same time

Hi all, I have 6 pc which is connected to the sqlserver. I have a table call tbl_seat with column (id, name, schedule, status) <-- the bold and underline is the primary key So when there is 2 pc choose the same seat at the same time, there cause an xLock and it will hang all my other process... so is there anyway i can stop it?? like there only 1 sql statement at a time... i hope everyone here know what i mean with my bad english.. and thanks in advance for any answer =) btw.. my insert statement is as below ( 2 pc execute the insert statement together) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A01', 2231, 2) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A02', 2231, 2) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A03', 2231, 2) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A04', 2231, 2) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A05', 2231, 2)

Updating Multiple records at 1 time.


You got to love management, they can never make their minds up on what they want. 

I'm currently working on a asp.net project using a datagridview that acts for the most part like a spreadsheet.  What I have to do now is update all the values in the table from the selected date, hour, min, max and cost forward.  There are 7 days worth of data in the table, when the user alters either the min, max or cost I need all the values in that field from that point onward to have the new altered value.

Here's an example:

In hour 10 of the day the user want to increase the max from 5 to 19, the min stays the same and so does the cost.  Mind you any or all of these values could change.  The only once that will remain as-is is the Date and Hour field:


Date Hour

how to send emails to multiple persons at the same time from sharepoint workflow using visual studio


Hi Every one !!

   I am trying to send copy of a document for multiple directors at my client for their approval.

   The director can approve the document at the same time.

   Hence, I would like to know how to create a task to send emails for multiple people at the same time from a sharepoint workflow using visual studio 2008.

   I see there is a parallel activity. But it gives me only 2 paths ( means would be able to send only for 2 users )

   If creating a separate task to send emails for each user is an inefficient way, please let me know if there is another good way of sending emails to multiple users.


Thank you

Transfering Multiple file at a time



I have a multiple file that i want  to get from FTP Server  to My local

Once i receive all file i want to send all to the Different  FTP Server

In DTS we can get multiple file at same time in same task.But can not do that in SSIS

Is there any way by which I can get Multiple File at Single task and also we can Transfer multiple file From Local to Ftp Server.





Cannot assign multiple keys in the Time Series Algorithm


We had a small problem, which we really need to know how to solve as soon as possible, as I told you in our last session that we are running out of time, and this issue is stopping us from completing our predictions. I will try to mention our exact business case and explain it as much detailed as I can so you can help us as soon as possible.


                                Kindly check the following scenario:


                                Table name: X

                                Columns: ID [Identity column], DATE_TIME [its granularity is hour], NODE_NAME, REASON, REQUESTS


can you upload multiple documents (to a doc library) and set content type and meta data at same time

can you do this?  it doesn't seem like the dialogs support this functionality.  As an alternative i tried doing it in a grid type view after the fact but i couldn't get the grid view to show the content type, even worse, the grid view would let me add meta data to content types that didn't even have that column as long as it was in the view!!

WSDuelHttpBinding and multiple time messing between service and client in one session


i am very new in wcf.suppose my wcf service is hosted in real ip server.Clients will request to service through internet.

client will request to service.The service will authenticate the client.After receiving the request the service will do some processing(like database update,delete,insert) and send a lot amount of data to client.client will do some database action and send an acknowledgment to service.service will keep its in database as a record.I need to do it in a session  and in a transaction.How can i do this.

i choose WSDuelHttpBinding.i read about callback operation.but according to the above scenario i also need to callback to the service again to send acknowledgment . Please help me.it's urgent .




Error when adding one instance of activity multiple time into Sequence activity



Hi all, 

I encounter this error when I tried to add same Writeline instance into two different Sequence activities as shown in the code below:


      ActivityBuilder ab = XamlServices.Load(ActivityXamlServices.CreateBuilderReader(new XamlXmlReader(new StringReader(_designer.Text)))) as ActivityBuilder;
      //inspecting ab ...
      Console.WriteLine("There are {0} arguments in the activity builder.", ab.Properties.Count);
      //ProcessActivity(ab.Implementation, "");
      //test code to add two same instances of activities in a sequence and execute them 
      if(ab.Implementation is Sequence)
        Sequence seq = ab.Implementation as Sequence;

Can I write multiple queries in Execute SQL Task Editor at a time


Can I write multiple queries in Execute SQL Task Editor at a time???


Can I write these two queries???

ALTER Table [Islamabad_campus]. [dbo]. [BS_Students] ADD Location   VARCHAR ( 10);

UPDATE [Islamabad_campus]. [dbo]. [BS_Students]

SET Location = 'Islamabad' ;


InfoPath 2007 display date for multiple time zones



We have an InfoPath 2007 form integrated with SharePoint 2007 and uses Web Service as Data Sources. The end users are located in multiple time zones in US and Australia. The server is located in US Eastern time zone. We would like the form to display user's local date and time.

The return of web service shows correct local date and time, except the time zone keeps at -04:00. For example during the one hour after midnight Eastern Time, the web services return:

Eastern: 2011-04-13T00:04:03.793537-04:00

Central: 2011-04-12T23:04:15.5734594-04:00

Mountain: 2011-04-12T22:04:24.3693642-04:00

Eastern Australia: 2011-04-13T15:04:18.8366836-04:00

When I preview the form it shows correct date, but after uploading it to SharePoint and view in web browser, the date is off by one day (either ahead or behind).

My looked at this post http://social.msdn.microsoft.com/forums/en-US/sharepointdevelopment/thread/677c03e4-8d71-43b3-aff9-1b6662a2528a but I don't get how it display different dates in different timezones by using UTC.

How can I make sure the form ignores the server time or the time zone indicated in the web service return, and just display the date as it is?



Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Round off time to the nearest minute

How would you round this up to the nearest minute? There isn't a built in function to do this so you have to use a little bit of maths to get there. There are 60 seconds in a minute. We already have 38 seconds on the clock. So we need to add on 60 - 38 = 22 more seconds.

Binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Here is the code for binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Upload Multiple File using JQuery in asp.net

In this article I have explained how to upload multiple files using file upload control. I have used jQuery plugin for uploading multiple files.

I have also explained how to check for file type, file maximum size limit using jQuery & also using server side validation code.

Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

GridView Multiple Filter AJAX Control

This AJAX control enables the user to filter data within any column inside a GridView. The user can add multiple filters and can delete existing ones too.
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