This is how my table in db looks like
Remarks Id Remark
1 Rem1_aaa
2 Rem1_ccc
1 Rem1_bbb
2 Rem1_ddd
i want the output as:
Id Column1 Column2
1 Rem1_aaa Rem1_bbb
2 Rem2_ccc Rem2_ddd
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 table think as table1, with 3 columns
col1 col2 col3 -- Columns
Y N 1 -- Data
but i want
colname val
col1 Y
col2 N
col3 1
This is datat table format :
TagName Timestamp Value
Tag1 21-2-2011 12
Tag1 22-2-2011 1
Tag2 21-2-2011 13
I want in this Format
TimeStamp Tag1 Tag2
21-2-2011 12 13
22-2-2011 1 0
Table1
t1c1 t1c2 t1c3
1 1 jim
2 2 ruth
3 4 paul
4 8 sam
5 16 NA
Table2 ( Need this)
t2c1 t2c2 t2c3 t2c4 t2c5
10 1 1 jim 2010-02-03
10 2 1 ruth 2010-02-03
10 4 1 paul 2010-02-03
10 8 1 sam 2010-02-03
The tricky part I have to perform is to copy rows( only t1c2 -> t2c2, t1c3->t2c4 columns) untill I see NA(Not applicable string) in t1c3 to Table2 putting (10 in t2c1, 1 in t2c3, current date in t2c5 columns for all rows).
im using sqlbulkcopy to import all the columns and rows in an excel file to a database. My question is, if my database has 1 more extra column which i have to map it to a session variable and that extra column in the database is not found in the excel, isit possible to do something like dat?
View 3 RepliesI 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 dataset.table which has some null values. am trying to trasform this using xslt to display like excel. If the value is null, then that node is ommitted by the xml. i tried deafulting the null values from the database itself and thats not generic. Handling null values is troublesome. I tried couple of methods to default null values by looping and thats not optimal solution. I used LINQ to handle null values but couldnt comeup with a neat solution. what am looking for is a generic optimal solution to handle these values.
View 2 RepliesI 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 Repliesi want to make a datagrid with 2 columns and many rows the columns i want to have databinding with a datatable
i want the 1 row 1 column of datagrid have data from 1 row of datatable
i want the 1 row 2 column of datagrid have data from 2 row of datatable
i want the 2 row 1 column of datagrid have data from 3 row of datatable
i want the 2 row 2 column of datagrid have data from 4 row of datatable
......
......
i use something like this
[code]...
but i have two times the same in tha datagrid left and right
how i will set No Of Rows & Columns for textbox in Mobile web controls.
View 2 RepliesI have a CSV file (with semicolon field separator) of 150MB (about 2 milion rows and 35 columns).
Now I want to loop through the CSV per row and get each row column.
I want to add rows and columns to grid dynamically. plz give me right code for it.
View 1 RepliesGiven 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 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'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.
I 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?
How can I loop through table and row that have an attribute id or name to get inner text in deep down in each td cell? I work on asp.net, c#, and the newest html agility package.
An html file have several tables. One of them has an attribute id=main-part. In that identified table, there are many rows. Some of those rows have same attribute name=display. In those named rows, there are many columns which I have to extract text from. Something like this:
<body>
<table>
</table>
<table>
[Code]....
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 have a IEnumerable result, passed to my view. Now, I want to display five elements for my Model in one row and next five in second row. How can I do that?
View 1 RepliesI 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 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#.
Below is the result set when I execute my stored procedure. Based on condition no.of rows will change. I am using typed dataset to store result set.
NSV QTY MONTH/YEAR
264.95 31248 APR/07
273.23 34044 MAY/07
230.96 22232 JUN/07
711.93 81992 JUL/07
427.23 50345 AUG/07
297.90 36961 SEP/07
495.37 43079 OCT/07
648.48 52428 NOV/07
622.06 46364 DEC/07
407.02 46461 JAN/08
605.45 73439 FEB/08
224.81 28121 MAR/08
308.12 33356 APR/08
328.22 35605 MAY/08
372.41 34107 JUN/08
I have to show above result in RDLC file Like below.
APR/07 MAY/07 JUN/07................JUN/08
264.95 273.23 230.96.................372.41
31248 34044 22232 ...............34107
RDLC report? If I use table control,
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?