DataSource Controls :: Convert Rows Into Columns?

Jan 13, 2010

I have a table like this..

---------------------------------------------------
ItemID ItemName Qty CenterID
---------------------------------------------------
1 X 10 52
1 X 6 53
1 X 4 57
2 y 6 58

I SHOULD convert the abouve table like this..

ItemID ItemName Qty CenterA centerB CenterC CenterD
---------------------------------------------------
1 X 20 10 6 4 0
2 Y 6 0 0 0 6

View 4 Replies


Similar Messages:

Forms Data Controls :: How To Convert Gridview Rows To Columns And Columns To Rows

Mar 4, 2011

I'm binding a gridview from a webservice with 30 columns and 10 rows, I need to print the same in a PORTRAIT, for that i decided to display columns as rows and

rows as columns like below:

EMP1 1 2 3 4
EMP2 1 2 3 4

View 3 Replies

Forms Data Controls :: Convert Rows To Columns For Periods?

Jul 15, 2010

I have a grid in dataset as following

UserPatientStatusID RelevantPeriod TotalCount ProviderSpecialtyServiceName
a OUT November2008 1 Not Available
a ER September2008 1986 Not Available
a ER April2009 1837 Not Available
a ER December2009 2367 Not Available
a ER August2008 1908 Not Available
b ER February2009 1598 Not Available
b ER January2009 1972 Not Available
b ER June2009 2087 Not Available
b ER December2008 2012 Not Available
b ER November2009 2148 Not Available
b ER November2008 2030 Not Available
c ER October2009 2240 Not Available
c ER September2009 2029 Not Available
c ER October2008 2079 Not Available
c ER July2010 1714 Not Available
c ER August2009 2115 Not Available
c OUT July2010 2 Not Available
c ER March2010 1755 Not Available
c ER May2010 1759 Not Available
c ER July2009 2063 Not Available
c OUT April2009 1 Not Available
c OUT December2008 1 Not Available
c ER March2009 1931 Not Available
c REC August2009 1 Not Available

I know that there can be 24 relevant periods for each user. There may or may not be all 24 present for each user.

Now all that 24 periods I have in an array in C#. I know what these periods will be. They change so I cannot hardcode it. It has to be dynamic.

I want to create 24 columns of that rows for relevant periods and display TotalCount in that and get all other data accordingly in c#.

View 6 Replies

Forms Data Controls :: Create An ASP Grid With Dynamic Columns With An Ability To Freeze Columns And Rows

Sep 20, 2010

I created a gridview that is made up of 4 gridviews and using a stored procedure to populate it. I create columns at runtime because the number of columns changes all the time.To make the grids editable I am adding template fields at runtime as I create the columns, this is to ensure that a user is able to edit the cells and some foot values update. Reason why I have four grids is to freeze rows and columns like in excel using javascript. The problem is that performance is very bad especially in IE, the grids take a long time to load. I am not sure if this is caused by the data load or the creation of text boxes. see some of the code below for my _aspx page:

[Code]....

View 1 Replies

DataSource Controls :: Removing Duplicates From Two Similar Columns Or Any Other Columns In A Database Schema

Apr 21, 2010

I have two columns first name and last name , that have duplicates, how can i remove the duplicates and only leave the distinct members intact?

View 6 Replies

DataSource Controls :: How To Select Rows From A DataTable And Create A New ViewList With The Selected Rows Only, While ...

May 31, 2010

I have one big DataTable with X rows. I want to select Y rows from it and bind them to a new ViewList. While doing it, I want to delete these rows from the DataTable (Having X - Y rows).

What is the best and fast way to do it?

I don't know if it is better to create a new DataTable to have the Y and after that bind them to a ViewList or something else?

I'm also looking for example in code how to select/delete rows from DataTable.

View 1 Replies

DataSource Controls :: Top 10 Rows As Well As Count Of All Rows From Linq To Sql Query

Jun 17, 2010

[Code]....

In above query I want to have top 10 rows as well as count of all rows.

View 3 Replies

Forms Data Controls :: Transpose Columns To Rows In C#?

Jan 7, 2011

Gridview-

Id Name Initial
1 abc A
2 def B
3 ghi C

After transposing,I want it to be like this-

Id 1 2 3
Name abc def ghi
Initial A B C

how to transpose in c# with code and if it is made as a function then how can I call it?I'm new to c#.

View 1 Replies

Forms Data Controls :: Datagrid With Dynamic Columns & Rows

Dec 6, 2010

I put in my page 1 table like grid with this style:

header of columns are select from table persons(so number of them are dynamic)

header of each row are select from table goods(so number of them are dynamic)

in table , in each cell,show the price & the date ,that this person,buy this goods

for example,in may 2008 ,Jack&sara buy pencil.so in front of pencil&buttom of jack we write his price and in front of pencil&buttom of sara we write her price.

so this table has 2 column & 1 row

in may 2009,

Jack&sara buy pencil.so in front of pencil&buttom of jack we write his price and in front of pencil&buttom of sara we write her price.

and jhon buy pen & suzzan buy book so this table has 4 column & 3 row

Price Date

Price Date

Price Date

Price Date

Pencil

Pen

book

then I want in each cell,I have 1 CHECKBOX that user of my program,checked each on that want. how can I design my page?

is ther any component?or I must create <TABLE> dynamically

View 4 Replies

Forms Data Controls :: Input Control For Multiple Rows And Columns?

Jun 10, 2010

I want to put an input table on a web page using ASP.NET. The input table has 3 columns: date, quantity, and price. The number of rows is variable, depending on user input. The code behind will read the data and perform the necessary calculations. The data will not go into a database. It would be nice to have some client-side or server-side validation for the data, such as required fields and range checking.

Which control(s) in Visual Studio 2008 will perform what I want to do?

View 1 Replies

Forms Data Controls :: How To Create A Control With Rows And Columns Like Sql Table

Jul 30, 2010

Iam working on an asp.net application.Recently client come with new requirement. Need a control which is similar to table or like gridview with rows and columns.It should allow user to enter data in the cells. And when the user press tab it should go to next cell and finally if we press enter key, it should validate the data entered in the current row and if data is correct it should create a new empty next row(like entering data manually in an sqlserver table). How can i implement this functionality? Can i use gridview / javascript to implement this functionality.

View 1 Replies

Data Controls :: Rotate Columns To Rows For GridView Populated Using SqlDataSource?

May 7, 2015

I have been looking at this article: [URL] However, I have a question: Can't this be used with a sqldatasource, instead of binding the gridview behind? If so, how?

View 1 Replies

Data Controls :: Change BorderColor Rows And Columns In GridView Before Printing

Aug 11, 2012

i want to change the color of border rows and columns in the grid view in asp for printing purpose.

View 1 Replies

Data Controls :: Dynamically Insert Rows And Columns To GridView Like Excel?

Sep 20, 2015

I have 2 textboxes , one for Rows and one for Columns...

in my query, if i enter Rows as 4, Columns as 3 then i want display gridview with 4x3 like

A  B   C --- Header1 A1 B1 C12 A2 B2 C23 A3 B3 C34 A4 B4 C4

if i enter Rows as 7, Columns as 4 then i want display gridview with 7x4 like

A  B   C  D --- Header1 A1 B1 C1 D12 A2 B2 C2 D23 A3 B3 C3 D34 A4 B4 C4 D45 A5 B5 C5 D56 A6 B6 C6 D67 A7 B7 C7 D7

how to write complete code for above query

View 1 Replies

Data Controls :: Displaying Database Records As Columns Instead Of Rows In GridView

Oct 17, 2012

I have Gridview Structure Like

CustId    EmailId  CheckBox(select) .. I want to display 10 records after that i want to display next to that records

CustId    EmailId  CheckBox | CustId    EmailId  CheckBox CustId    EmailId  CheckBox |

How can I display vertically..

View 1 Replies

Forms Data Controls :: Dynamically Created Rows And Columns Of Grid View?

Jun 2, 2010

Need row editing on page_load for all the cells and need to validate each cell entry. Means cell1 one entery isvalid it fills thrid cell and insert or update to a table in the database. How do i handle on tab clicking to update in databse.

View 1 Replies

Forms Data Controls :: Combine Gridview Columns Under One Column And In Separate Rows

Nov 29, 2010

I have a couple of things that are not working with my Gridview:

1) I've managed to display 3 columns in one column (see code above) but the data is separated by commas, how can I display each data item in separate rows.

2) How can I make the data unique, as I have added the distinct command which I configured in my SQL data source

3) I need the rows to not display nulls, but at the moment it isn't displaying the row if one of the columns is null?

[Code]....

View 3 Replies

Forms Data Controls :: To Display The Gridview Rows/columns In Breadcrumb Style?

Dec 27, 2010

I want to display the gridview content in breadcrumb style.

View 5 Replies

Data Controls :: Dynamically Create GridView With X Rows And Y Columns On Button Click

Oct 21, 2015

[URL]

by using above thread its working great..

i want below rows and columns pattern

Rows 3, Columns 4 in my query..

     1   2   3   4 -- Header

A    1   2   3  4

B    1   2   3  4

C     1   2   3  4

View 1 Replies

Forms Data Controls :: Dyamically Created Rows And Columns, Delete Button Not Firing?

Jun 1, 2010

Created button in the rowdatabound event grid show the button fine, but on clicking it dont fire the delete button event :(. How to resolve it. Rows and columns of grid are created dynamically.

Button btnDelete =
new
Button();
btnDelete.Text = "X";
btnDelete.EnableViewState = true;
btnDelete.Command +=
new
CommandEventHandler(btnDelete_Command);//Add this to every cell.
e.Row.Cells[4].Controls.Add(btnDelete);
void btnDelete_Command(object sender,
CommandEventArgs e)
Response.Write(e.CommandArgument);
}

View 12 Replies

Show Several Columns In Datasource As Autogenerate Columns In Gridview?

Jan 27, 2011

I have a datasource, which includes many columns, idealy, I need use a gridview to show:

1) first 3 columns: template fields, these fields depends on values in some columns of datasource. I use template fields, hard coded. works fine.

2) the other columns. This is I do not know how to do it. In the data source, there are about 10-20 columns data, each time, the # of columns of the data varies. idealy, I need show each of them as a seperated column in gridview. The entire data source may have 30 columns, but some of them are used in 1), and I only want show these 10-20 columns in gridview. Some columns in data source, I may not use them at all. is there a way to do this? or have to seperate them as a detail view style UI?

View 1 Replies

Forms Data Controls :: Expand And Collapse Rows (With + ) In Gridview For Same Data In A Columns

Feb 3, 2011

How can I Expand and Collapse the rows in gridview for a column having same row data.

View 2 Replies

Forms Data Controls :: Printing Rows And Columns Of Data?

Feb 19, 2010

How do you loop through a dataset in vb.net so it can be printed to a file in rows and columns ?It's the looping through the dataset I can't get.

View 1 Replies

Forms Data Controls ::working On Setting Up A Gridview That Dynamically Creates New "columns" After A Set Amount Of Rows?

Mar 10, 2011

I'm working on setting up a Gridview that dynamically creates new "columns" after a set amount of rows. To do this, I bind a datasource to the Gridview and then add new cells and shift the other items into those cells. I seem to be having an error with the link buttons that I move around. All of the items get put in there correct location, but for some reason, when I click a link button that has been added to a new cell, the sender's text is the LinkButton in the original cell's text. Does anyone know why this would be happening? Is the gridview not meant to be manipulated after it has been data bound? This is the code that I use to update the gridview.

[Code]....

View 2 Replies

Data Controls :: Bind Pipe Separated String As Columns And Comma Separated Strings As Rows In Repeater Control

Feb 1, 2013

I am redirecting string like this a1|b1, a2|b2,a3|b3.... to another page.

On next page I have repeater control

And I want to show data in repeater control like this

  a1  b1

  a2  b2

  a3  b3.

How can I show value like it in repeater control?

View 1 Replies







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