Data Controls :: Result In Pivot Table Shown To Gridview

Aug 21, 2012

I have a doubt and i am sending you the details  below, what i want to display in Gridview.

below i am describing the sql Table Structure.

Original Table Structure.

ID                Date             TimeLogged(Hrs)        UserName

1             10/8/2012               5.50                          Bubai
2             11/8/2012               2.30                          Bubai
3             10/8/2012               3.30                          Bhanu
4             11/8/2012               7.30                          Bhanu

I want result like below. User Name should be dynamic. May be lot of users. User name will come from Database table.

i want to show details in Gridview(Front End).

Date                    Bubai               Bhanu                    Total

10/8/2012              5.30                   3                         8. 30
11/8/2012              2.30                  7.30                       10

  Total                   8                    10.30                  18.30
 
I have a doubt and i am sending you the details below, what i want to display in Gridview. below i am describing the sql Table Structure.Original Table Structure.

ID Date TimeLogged(Hrs) UserName
1 10/8/2012 5.50 Bubai
2 11/8/2012 2.30 Bubai
3 10/8/2012 3.30 Bhanu
4 11/8/2012 7.30 Bhanu

I want result like below. User Name should be dynamic. May be lot of users. User name will come from Database table. i want to show details in Gridview(Front End).

Date Bubai Bhanu Total
10/8/2012 5.30 3 8. 30
11/8/2012 2.30 7.30 10

Total 8 10.30 18.30

View 1 Replies


Similar Messages:

Forms Data Controls :: Totaling Gridview In Footer From Pivot Table?

Jan 6, 2011

I am bringing back a matrix from using a pivot table and displaying the results in a gridview. Here is the code to my gridview

[Code]....

This works fine but I want to total each column but they are dynamic so I don't know how many columns there will be. So it will look something like below:

East Midlands
0
0
0
0
0
0
0
0
0
North East
0
0
0
0
0
0
0
0
0
North London
0
0
0
0
0
0
0
0
0
North West
0
0
0
0
0
0
0
0
0
ROI
0
0
0
0
0
0
0
0
0
Scotland & NI
0
0
0
0
0
0
0
0
0
South East
1
1
0
0
0
0
0
0
0
South London
0
0
0
0
0
0
0
0
0
South Wales & West
0
0
0
0
0
0
0
0
0
West Midlands
0
0
0
0
0
0
0
0
0
Total
1
1
0
0
0
0
0
0

I am struggling to get the column totals in the footer. I have the code below which just brings back zero each time and if i move the Dim total as integer = 0 to the top as a global variable I get 54 in each of the total columns?

[Code]....

View 2 Replies

Forms Data Controls :: Copy Gridview Result To Another Table With VB?

Jan 20, 2010

I have an aspx webpage with a databound DropDownList and a databound GridView control. The GridView datasource is using a WHERE clause to return its' data. I.e. The user selects a work area from the DropDownList and members of that area appear in the Gridview. The GridView has 3 columns, WrkArea, LastName and FirstName. The page also has a Button.

What I am trying to accomplish is when the user clicks the Button, the data from the GridView is copied to a separate SQL table. I am working in VB. I have been looking at other posts but have to admit, I am really confused.

View 7 Replies

Forms Data Controls :: Display An Excellike Pivot Table In.Net Web?

Apr 8, 2010

I need to display an Excel like Pivot table in ASP.Net web.I knew there is OWC Pivot table but it looks really ugly and not like Excel's.
Is there any control out there or we can create one of our own ?

View 3 Replies

Forms Data Controls :: Display The Attendance In Datewise Using Pivot Table?

Jun 3, 2010

I'am developing a attendance software of employees with visual studio 2005 and sql server 2005, in which i have to display the attendance in a gridview withname and date as follows,

NAME (Date)1 2 3 4 5 6 7 8 9 10 .... ... 31
RAM P A P P P A
P- Present
A- Absent

View 5 Replies

DataSource Controls :: How To Create The Pivot Table To Search The Table

Feb 26, 2010

I'm assuming I need to use a pivot table from what I've found so far. However, every one that I've seen has not had the date setup like I have.

I have a Gridview on my page which I need to be populated like so

Date NCMR

1/1/10-1/31/10 #

2/1/10-2/28/10 #

I want to do this for 10 months... bottom record being the current month (or last month). I would also like the Date to format to January 2010 I used the above date format because that is how it is in the table. Basically, I need to know how to create the pivot table to search the table for 1/*/10, 2/*/10, etc

View 3 Replies

SQL Server :: How To Merge Pivot Result With Other Columns

Feb 11, 2011

I got the following table:

Lane Bin1 Bin2 Bin3
1 B11 B21 B31
2 B21 B22 B23
3 B31 B32 B33

How can i change the layout to

Bin1(Lane1) Bin1(Lane2) Bin1(Lane3) Bin2(Lane1) Bin2(Lane2) Bin2(Lane3) Bin3(Lane1) Bin3(Lane2) Bin3(Lane3)
B11 B21 B31 B21 B22 B23 B31 B32 B33

I tried using pivot, but cant get it.

View 11 Replies

DataSource Controls ::collection Which Contains The Rows Shown Below In "Expected Result List"?

Mar 2, 2010

I have following two collections,1. CategoryList, 2. ItemList. I need to get the collection which contains the rows shown in below in "Expected Result List".could you please provide me the LINQ query on collections to get this resulted List?

[code]...

View 2 Replies

Forms Data Controls :: GridView And ObjectDataSource - Column Is Not Shown In The GridView's List ?

Feb 9, 2011

I'm facing a wierd problem with GridView and ObjectDataSource. I bind GridView to my business objects via ObjectDataSource. Everything was working fine until I decided to add a new field in my buisness object and wanted to add a column to GridView to show it. Somehow that column is NOT shown in the GridView's list of available columns. I have tried refreshing schema, rebinding, etc. I'm using GridView inside a user control which is used as a web part. Does that make a difference ?

View 3 Replies

Forms Data Controls :: GridView PopUpEdit Form - Show Fields Not Shown In GridView's Columns

May 4, 2010

Currently I have something like this, but when I click "update" the record doesn't get updated (but no error is returned).

[Code]....

View 5 Replies

Forms Data Controls :: How To Change Data Format In Result Coming From SQL Table

Oct 18, 2010

On one of my webpage i am displaying datalist in which i am using this label:

<asp:Label ID="nameLabel12a" runat="server" Text='<%# Eval("CreatedOn") %>' />

This label is displaying created on date along with time (10/18/2010 2:45:07 PM), but i would like to display it something like this:

7sec ago
20min ago
30min ago
23 hours ago

10/3/2010 (if the time is more than 24 hours then it should display the date)

View 17 Replies

Can't See The Result After Update A Row In A Table In A Gridview

Mar 30, 2010

i created a gridview and ive bended the data using a ObjectDataSource,
for some reasons i created the CRUD methods to do the work instead of using the CRUD method generated by the LINQDataSource; everything is just working fine but the update method,when i update a row in my gridview everything become as if there isnt any update!but when i check the database i can see that the rows is been updated!i can't find a solution (yet) to this issue.i'am using the updatepanel to have the autopostback without refreshing the page.

View 2 Replies

Forms Data Controls :: Gridview Sorting When Header Of Grid Is Not Shown?

Feb 3, 2010

guide how I can sort grid data when header is not shown. Actually In my page I have set visibility of header to false and have placed headings in table above the grid (it was done because requirment was to fix header and make grid with scrollable).how I can give sorting functionality with headings in table above the grid

View 2 Replies

Data Controls :: Hide Shown Items In GridView Based On Stored Procedure?

Mar 11, 2013

I have 2 page admin.aspx page  and search.aspx

in admin .aspx page I have textbox=txtsearch and image button=imgs

in txtsearch we can type Mobile Or phoneNumber and when we click on Imgs we go to search.aspx page

below are code
 
protected void imgs_Click(object sender, ImageClickEventArgs e)
{
Response.Redirect("admin/search.aspx?Mobile=" + Server.UrlEncode(Txtsearch.Text));
}

in search.aspx page I have gridview that bind from database and show data according to Mobile or PhoneNumber that I typed in txtsearch in admin.aspx below are code

 <ContentTemplate>
<asp:GridView ID="GridView1" runat="server" CssClass="DGridViewSV"
AutoGenerateColumns = "false" Font-Names = "Tahoma"
Font-Size = "9pt"

[Code].....

Now I want when I enter Mobile in txtsearxh and click button when it go to search.aspx page it in grid view it show Mobile number in HLcalss from database and it doesn't show PhoneNumber and Code in Hyperlink1 and lblCode

and if I type phoneNumber in txtsearch in gridview it showes PhoneNumber and Code and it doesn't Show Mobile number

View 1 Replies

SQL Server :: Retrieving Users From Mapping / Pivot Table?

Sep 9, 2010

I have three tables.

CustomProfile
UserID (pk)
DisplayName
CompanyID
Teams
TeamRecordID (Pk)
TeamID
CompanyID
EmployeesInTeams
UserID
TeamID

I want to assign employees to teams via a gridview control with a templated checkbox.

I have a dropdownlist control to select the TeamID.

I am having problems with the select statement.

The gridview needs to select employees that are not assigned to any teams as well as assigned to other teams. An employee can be assigned to many teams.

What I have been trying is:

cp.UserID, cp.DisplayName, et.TeamIntID, cp.CompanyID

View 32 Replies

Forms Data Controls :: Displaying Correct Result Inside DropDownList From LINQ Query Result

Jul 1, 2010

I have this ListView that has a Drop Down List.Everything works fine (I think/hope) except that the drop down list are not showing its result correctly.This is the code.

Front-End
[Code]....

The code behind consist of the page_load and the ItemDataBound
[Code]....

View 3 Replies

C# - How To Create A Pivot Table With Dynamic Column Using Linq Tree Expression

Feb 8, 2011

i'm writing an asp.net C# web application; i have an in-memory datatable named 'table1' having three columns 'country', 'productId' and 'productQuantity'; i want to pivot that table in order to obtain a new table (suppose 'table2') having the first column 'country' as a fixed column and a dynamic number and names of columns 'product_1', 'product_2', ..., 'product_n' according to the total number of products existing in 'table1'; the first column 'country' must contain the country name; the dynamic generated columns 'product_1', 'product_2', ..., 'product_n' must contain the productQuantity that has been selled for each specific product in the specified country

i'm using Linq query expressions to write the code; the problem is that i cannot hard-code the names neither the values of the products; i cannot predict how much products exist in the datatable;

for now, i'm testing the results using the following expression :

[Code].....

i'm giving an example on how 'table1' looks like and how 'table2' must look like :

view example image of the two tables table1 and table2

View 2 Replies

Forms Data Controls :: Show In GridView Everything Except Of Those Data Entries Mark As "not To Be Shown"?

Jan 9, 2010

I trying to solve this: I have a gridview where are real estates (houses, flats ...) and I need to "freeze" (not to show it) some of them just for a while ... I have an administration website, where is another gridview with edit/ delete ...It doesn't have to be checkboxes ... but I have an idea to put new column to the main page and makes it invisible ... every ordinary row will have empty entry in this column, but the one a need to freeze will have phrase "freeze" in it after the checkbox will be checked ... that I can do ... but I need help with SELECTCOMMAND of the main page gridview ... HOW TO PUT INTO a SELECTCOMMAND THAT I WANT TO SHOW WHAT I NEED TO SHOW EXCEPT OF THOSE WITH PHRASE FREEZE IN THE HIDDEN COLUMN ?this is my select command:

[Code]....

View 3 Replies

ADO.NET :: How To Query A Data Table To Get A Customized Result

Aug 18, 2010

I am having a datatable in which the data is as follows

No Name Text
1 a abc
1 a xyz
1 a asd
2 b aaa
2 b bbb

I want to querry this data table to get the result as

No Name res1 res2 res3
1 a abc xyz asd
2 b aaa bbb

View 1 Replies

Forms Data Controls :: Binding Web Service Result Into Gridview/Data Source Is An Invalid Type

Apr 15, 2010

I having problem binding web service result into a gridview. I using Word Dictionary Web Service for my project. Below is part of my code.

Web References I using is :

[URL]

Protected void Button1_Click(object sender,
EventArgs e) {
DictService ds = new DictService();
ds.DefineAsync(TextBox1.Text);
ds.DefineCompleted += new DefineCompletedEventHandler(ds_DefineCompleted); }
void ds_DefineCompleted(object sender, DefineCompletedEventArgs e){
GridView1.DataSource = e.Result;
GridView1.DataBind();}

The Error i get is : Data source is an invalid type. It must be either an IListSource, IEnumerable, or IDataSource.

View 4 Replies

Forms Data Controls :: Show Result In Gridview At The Bottom Of The Page

Jan 27, 2010

I have a database that has names and months of birth. I would like to have a Choose Month: with a drop down menu to select the month of your choice, then have the results show in a gridview at the bottom of the page. I thought this would be fairly simple but my grid doesn't show anything.

<%@ Page language="C#" masterpagefile="MainContent.master" title="HomeSign OutVehicle CalendarProj" %>
<asp:Content id="Content1" runat="server" contentplaceholderid="Content">
<div id="Rightside">
<form><asp:Label runat="server" Text="Choose Month:" id="Label1"></asp:Label> <asp:DropDownList runat="server" id="Month">
<asp:listitem>Choose Month</asp:listitem>
<asp:listitem>January</asp:listitem>
<asp:listitem>February</asp:listitem>
<asp:listitem>March</asp:listitem>
<asp:listitem>April</asp:listitem>
<asp:listitem>May</asp:listitem>
<asp:listitem>June</asp:listitem>
<asp:listitem>July</asp:listitem>
<asp:listitem>August</asp:listitem>
<asp:listitem>September</asp:listitem>
<asp:listitem>October</asp:listitem>
<asp:listitem>November</asp:listitem>
<asp:listitem>December</asp:listitem>
</asp:DropDownList><br /><hr />
<asp:GridView runat="server" id="GridView1" AutoGenerateColumns="False" DataSourceID="AccessDataSource1">
<Columns>
<asp:boundfield DataField="FullName" HeaderText="FullName" SortExpression="FullName">
</asp:boundfield>
<asp:boundfield DataField="Month" HeaderText="Month" SortExpression="Month">
</asp:boundfield>
</Columns>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="browser.mdb" SelectCommand="SELECT [FullName], [Month] FROM [EmployeeDates] WHERE ([Month] = ?)">
<SelectParameters>
<asp:controlparameter ControlID="Month" Name="Month" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
</form>
</div>
</asp:Content>

View 1 Replies

Forms Data Controls :: Compute The Result From The Quiz Inside The Gridview?

Feb 1, 2011

i have a column named POINT.. it is the point in every question... therefore i want to get the total of this column..

View 3 Replies

DataSource Controls :: Combine Two Result Sets From One Table?

Jan 6, 2010

I have a table that contains a date column along with others. I need to extract two sets of data from this table for two different time periods. Call them Current and Previous, so that I can compare them line for line. There are exactly the same number of days in both time periods.

The problem is that I need to return the data like this:

CurrentDate, Count(CurrentItems), Sum(Amt), Count(PreviousItems), Sum(PrevAmt)

JOIN puts the data into the result vertically, so that doesn't work. So far, I have not found a method that will arrange the data correctly.

View 1 Replies

Should A Datalist Or Gridview Be Used For Multiple Rows With The Data As Shown

Nov 15, 2010

Sql select statement returns: customer_name, month, and count. There is one row per month as follows:

name-1, 01, count1

name-1, 02, count2

name-1, 03, count3

name-2, 01, count4

etc

I want to be able to display as follows:

Customer----Jan-------Feb-------Mar

Name-1______count1____count2____count3

Name-2______count4

etc.

There will be some customer that don't have a month record. The display can show all 12 months.

My questions are: 1) Is datalist or gridview the best? 2) Where can I find examples of how to do this? 3) Also, an example of "no data" for a month. I'm a beginner, have been trying to research, but can't seem to get headed in the right direction.

View 2 Replies

DataSource Controls :: Searching TextBox Data In Sql Database And Binding The Result In Gridview

Oct 28, 2010

I have few textboxes and I want to search the text (partial search is also required) in the database and then show the result in a telerik grid. The grid has to be hidden initially and when I click the search button it should show up and display the results.

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved