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
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#.
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]....
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
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]....
I want to display the gridview content in breadcrumb style.
View 5 RepliesI 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 Repliesi want to change the color of border rows and columns in the grid view in asp for printing purpose.
View 1 RepliesI 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
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..
How can I Expand and Collapse the rows in gridview for a column having same row data.
View 2 Replies[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
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#.
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
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]....
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?
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 RepliesNeed 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 RepliesCreated 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);
}
Given a GridView control defined like this:
[code]....
The "FilePath" and "AttachmentID" fields are being set correctly in the grid, however, the CheckBox control is never set correctly; it is always unchecked.
My question:
How do I get this CheckBox field set from C# as I'm creating the new row?
P.S. I am not sure if I am creating the row correctly in the first place.
I am trying to set the top gridview's column's width to the body's column width and then the left columns height to the body's coloumns height. Here is my code:
<form id="form1" runat="server">
<div>
<asp:Table ID="Table1" runat="server">
<asp:TableRow>
[Code]....
I've got a grid view on my form that is bound to a data table at run tim. The data table is returned by a function rather than direct from the DB so I can't set the datasource at runtime.
I bind the grid in the page_load event like this:-
Code:
Dim _dt As System.Data.DataTable
_dt = _srvc.GetVinylShutters(0)
_dt.Rows.Add(_dt.NewRow)
grdShutters.DataSource = _dt
grdShutters.DataBind()
(_dt.Rows.Add(_dt.NewRow) is just there to add a blank row in, otherwise I wasn't seeing any columns at all)
I've then got the following snippet which I want to use to hide some underlying columns:-
Code:
For Each col As DataControlField In grdShutters.Columns
Select Case col.HeaderText
Case "OrderID", _
"ShutterID", _
"ModelID", _
[Code] ...
The thing is, wherever I put this it doesn't seem to hide the columns. If I break into the code I can see that grdShutters.Columns.Count equals zero althought I can see that the bound datatable has 38 columns.
I've tried the Page's Load, LoadComplete and PreRenderComplete events as well as the gridview's DataBound, RowDataBound and RowCreated events. I get teh same result in all of them. The grid doesn't actually have any columns until it appears on the screen.
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 RepliesI am trying to set come columns to invisible after all of the rows are binded but I'm having trouble. I'm hiding columns that have empty data which I save in a session variable. This works fine. Then I tried changing the columns visible property using the ColumnByName routine in the DataBound but that must be the wrong event because I do not think the columns exist yet.
The columns are autogenerated btw.
Where can I set the columns properties after it has binded? Can i do this before the columns are autogenerated the the screen itself?
I am looking to 'hypothetically' post nine rows of data with column headers for 15 different columns. That would be too many textboxes. All the data is directly calculated in VB.net. I want to insert some sort of spreadsheet-type deal with the tool "Table" or something I heard about "Gridview?".
View 2 Replies
