Forms Data Controls :: How To Change The Column Header From A DataSet

Feb 21, 2011

The following query returns me the column name from the table in the database, and stores the column name in the grid. How can I change the column name in the grid using following code, if its possible?

DataSet p_dsInformixDataDs = new DataSet();
string cmd = "SELECT * FROM CUSTOMERS";
try
{
using (IfxDataAdapter da = new IfxDataAdapter(cmd, m_InformixDBConn))
{
da.Fill(p_dsInformixDataDs);
}
}
DataView myDataView = new DataView(m_dsInformixDataDs.Tables[0]);
if (myDataView .Count > 0)
{
GridView1.DataSource = m_dsInformixDataDs;
GridView1.DataBind();
}

View 5 Replies


Similar Messages:

Forms Data Controls :: Dynamically Binding Dataset Table Values To Datagrid's Header Column?

Jun 29, 2010

I want to dynamically bind dataset values into datagrid's header datafield.

Is it possible? To be more clear, when you click on datagrid's (Collection) from properties window, you get selected columns created from Bound column. So in those columns I want to dynamically display dataset's table values in those columns.

i.e like ds.Tables[0].Rows[0][0].

Is it possible to do it in Datagrid ItemDataBound function like,

e.Item.Cells[1].Text = ds.Tables[0].Rows[0][0]

or something like this? I know the above code is wrong and wont work since I tried it out and while building it throwed error saying, Cannot implicitly convert type 'object' to 'string'.

View 5 Replies

Forms Data Controls :: Change The Header Text Of A Merged Gridview Column?

Jan 9, 2010

I have a merged column of firstname and lastname by "Select firstname + lastname from table" but when it appears in the gridview the header text of the column is "Expr1000". How can I change the header text of that merged column?, and I want to change its text into "NAME".

View 3 Replies

Forms Data Controls :: How To Change Sort Column Header Text And Retain The Sort Link

Jun 3, 2010

I have a simple dynamic gridview with following code -

GV = new GridView();

View 3 Replies

Forms Data Controls :: Gridview Column Header Button Instead Of Header Name?

Nov 28, 2010

is there anyway i can add in the gridview in header column name a button instead of label ?

column name 1 column name 2 column name 3 button

i am using checkbox column in item template for the button ,i wish after selecting checkbox for some row to click on the button on the header !!

View 2 Replies

Forms Data Controls :: ListView Column Header / How To Show Header

Mar 11, 2010

i have a problem with ListView control,when i bind data to it, it shows the heder of it also.

i don't want to show me the hedear, what should i do?

[Code]....

View 11 Replies

Forms Data Controls :: GridView Header / Change The Header Based On The Session Variable

Feb 16, 2011

I am using the following code to change the header based on the session variable

[code]....

View 2 Replies

Forms Data Controls :: How To Add A Column Header To A Column Of Auto Generated Select Buttons

Aug 18, 2010

I have a gridview which has a column of auto generated select buttons, where a user can select a row.However, I would like to add a column header to my auto generated select buttons in order to make the gridview look complete, but I am unable to see how I can do this. Does anyone know how I can add a header text to an auto generated select button?

View 2 Replies

Data Controls :: Pass GridView Column Header Values To Another Pages Table Header

May 7, 2015

How to pass gridview particular column values to another page's table header...

View 1 Replies

Forms Data Controls :: Sorting A Column By Simply Clicking On The Column Rather Than Clicking On The Column Header?

Jan 14, 2010

I am looking to sort a column on my gridview by simply clicking on the column rather than clicking on the column header. In the design I have been given, the column header will not be shown, and I need to be able to give the user to sort this column, by simply just clicking any where on the column.

View 2 Replies

Forms Data Controls :: Header Column Not Sync With The Column Data In EditItemTemplate?

Oct 21, 2010

i have a grid view and i use TemplateField.

when i am in ItemTemplate all the column (7 column) are label so it fit to the current screen

by when i use EditItemTemplate or InsertItemTemplate the coulmn don't fit the the current screen and

i have to use the ruler in order to see more information about the cell (which is ok - because in each cell i have a dropdownlist or long textbox)

but when i drag the ruler to the right size to see more information only the cells are moved but the header coulmn stay so i see the current coulmn with worng header coulmn

View 1 Replies

Forms Data Controls :: Column Header And Row Header For Data?

Aug 16, 2010

I want to display something like the following, what would be the best tool to use?

TravelOption1 TravelOption2 TravelOption3

City 1 400 555555 2121

City 2 355 33333333 3455

city 3 444 22 4433

city 4 777 6544 4333

View 9 Replies

Web Forms :: How To Change Gridview Header Column Names Dynamically

Apr 5, 2012

I want to change Gridview Header column names dynamically with if condition.

for example

IF condition 1 

UserID |   Full name | Transaction Amt |  Tancaction Date 

IF condition 2 

UserID | Full Name | DOB | Balnace | Date 

How to change Header column name for single Gridview dynamically ?  

View 1 Replies

Forms Data Controls :: Gridview Column Change / Replace A Column Data Field Value to 'Not Applicable'?

Jan 6, 2011

I have a gridview which is binded to a Sqldatasource. I would like to replace a column data field value to 'Not Applicable' if that column has got a value of 2 in database.

View 2 Replies

Forms Data Controls :: How To Add Dynamic Header Column To Grid

Feb 7, 2011

I need to add dynamic header column to grid Urgent from database table

how can i achieve this

my gridview should be expandable horizantally

View 14 Replies

Forms Data Controls :: Sorting Using The Column Header Of A Gridview?

Jul 7, 2010

Dear all; I have the following gridview

Type Cost

BENZ 40,000

TOYOTA 20,000

Now, I would like a situation if either TYPE or Cost is clicked on, it would sort things in ascending order. see example below.

if Cost is clicked on, we will have the following sorting order.

Type Cost

TOYOTA 20,000

BENZ 40,000

I am still new to visual studio.net.

View 13 Replies

Forms Data Controls :: How To Get Datagrid Header Column Text

Jan 20, 2011

Is there any way to get the datagrid header column's text before the grid loads.

View 7 Replies

Forms Data Controls :: How To Change Header Css In Gridview

Feb 27, 2011

I used css for one header column in my gridview and how can change this css when user click in this column on header?

View 4 Replies

Forms Data Controls :: Finding The Header Column Clicked In Cs Code?

Feb 10, 2011

I am using ASP.NET 2.0 and C#. I have a gridview, which has template columns. The columns have header text available. I would like to do sorting on each of the column header in the gridview the user clicks.

How to identify which column, the user has clicked?

View 2 Replies

Forms Data Controls :: GridView Sort Column Header Underline?

Feb 17, 2011

AllowSoting is true on every column of my gridvieww.

i want to remove those underlines in everycolumn ...

how can i do that?

View 3 Replies

Forms Data Controls :: MS SQL 2005 And DataSet - Computed Column

Feb 16, 2010

I have a datatable in MS SQL that has FirstName and LastName. In MS SQL I created a computed field called FullName that was ((rtrim([LastName])+', ')+rtrim([FirstName])) I created a DataSet and a Business Logic Layer. In my typed DataSet I saw FullName in the listing when I created it. I am able to use FullName in my webpage. I use it to populate a dropdownlist. However, now when I make changes to the Customer Table I am getting this error message (seen below)

Question: Should I have created the field FullName in my MS SQL Table or should I have left it alone and somehow just added a column to the DataSet and placed an expression in the FullName column? The column "FullName" cannot be modified because it is either a computed column or is the result of a UNION operator. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The column "FullName" cannot be modified because it is either a computed column or is the result of a UNION operator. Source Error:

[Code]....

Source File: c:Users ottfarmsAppDataLocalTempTemporary ASP.NET Filesinternalauburnriverside98ea0e1f2a7f0720App_Code.lbdcba1v.2.cs Line: 1240 Stack Trace:

[Code]....

View 1 Replies

Forms Data Controls :: Change The Header Text To Mem No Instead Of MembershipNumber?

Feb 3, 2010

I have a gridview which is binded to a table at runtime.So when the gridview displays the header text is exactly same as table field text which I want to change ,How can I accomplish thisFor example my table field name is MembershipNumber, so my gridview header also displays the same name. What I want is I want to change the header text to Mem No instead of MembershipNumber

View 5 Replies

Forms Data Controls :: GridView Disappears When Click A Column Header To Sort?

Jul 28, 2010

I have a page with a TextBox, a Button, a GridView, and a SqlDataSource. I click the Button to execute the SQL in the TextBox using the SqlDataSource. The SqlDataSource populates the GridView. Everything works as expected until I click a column heading to sort.

When I click a column heading, the GridView disappears and I have to click the Button to display the grid again. When I do, the grid is displayed in the order of the column I clicked.

I don't understand why the GridView is disappearing when I click a column header.

Does anyone know how to fix this so the GridView is sorted and displayed only by clicking the column header?

ASPX:

[Code]....

Code behind:

[Code]....

View 9 Replies

Forms Data Controls :: Gridview Column Formatting Depending On Text In Header?

Mar 30, 2010

I want if the header of a particular column contains a word "S", the header and row turns red. I used following code to make header red and it works fine. How to make it such that the rows also turn red if condition is met ? I cannot hardcode in columns since the Gridview is autogenerate colums as data structure keeps changing.

Protected Sub GridView1_DataBound(ByVal sender
As
Object,
ByVal e
As System.EventArgs)Dim HeaderRow
As GridViewRow = GridView1.HeaderRowFor
Each c
As TableCell
In HeaderRow.CellsIf c.Text.EndsWith("S")
Then
c.BackColor = Drawing.Color.OrangeRed
End
If
Next
End
Sub

View 2 Replies

Forms Data Controls :: ASP Grid Won't Change Header Font Size

Mar 24, 2011

I am setting everything in a skin --- all the properties work -- expcept that I cannot change font size

View 2 Replies







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