I have a gridview that I am loading from a stored procedure. I need to be able to hide certain columns and change the column names. Since it is loading with stored procedure the columns aren't listed in the gridview->edit columns properties.
View 1 Replies
I am struggling to show different views of gridview with database values. Here is my requirement.
Database Table:
I need to show one drop downlist with three values 1,2,3. If user selects 3 i Need to show a grid like below
Age,AnnualSales and Assortment are names which are coming dynamically from database.
High,Medium and Core all are values
Here my question is I need to show same attribute names.
Like If the name changes from "Assortment" to "Location" I need to show it in different page index .
In page index 2 i need to show like below.
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 ?
[Code]....
Refer to datatable columns with database column names?
I have a gridview which makes use of a datasource. The columns are auto-generated.
Right now, my task is to make the first column into a url column. Does anybody know how to do it?
in asp.net page user able to select gridview Columns, and it will hide remaining columns and that selection done by check box with column list bellow is Image link , what exactly I am looking for [URL] it look bellow after selection of column done [URL]
View 1 RepliesGridView1.Columns.Count is always zero even SqlDataSource1.DataBind();
But Grid is ok I can do
for (int i = 0; i < GridView1.HeaderRow.Cells.Count;i++)
I rename request headers here but
GridView1.Columns[i].Visible = false;
I can't use it because of GridView1.Columns.Count is 0. So how can I hide them ?
As per my requirement, I am getting CompID, Company Name and URL from SQL database. I want to display just CompName and URL in gridvew. So, I need to hide the CompID in gridview. One way I can do BoundField field Visible to false but I need to retrive that compID id when user selected any of the row. if I set visible to false user wont see any compID in gridvew but I want access the selected compID also using SelectedRow.Cells[1].Text..
View 1 RepliesI have the asp.net application where I am having the editable grid view with the edit,Delete,Add options. this grid having as usual Template fields . I want to hide some columns. I know i can do that by using columns index. but i don't want to follow it. instead I want to hide columns by Id. this is because if in my application further I need to add more columns then there is need to change the code gain and again in the core. so I am choosing this way. Bu as i found <asp:TemplateField /> does not contain Id attribute. so it is become impossible for me to hide <asp:TemplateField/> by Id.
View 3 RepliesI want to write the default column names in gridview when the data is not coming from the dataset or you can say that datset is blank.
I tried to use this [Code]....
But this does not help me and i am not able to see the column with name as 'ID'
my sp return resultset with different column names based on different parameters passed to sp and now i want to show that data in asp.net(c#) gridview so how can i achieve this
View 1 RepliesI have a GridView that is successfully populated by an IList. IThere are about 2 dozen columns I only need 8. I am trying to call:
this.grdView.Columns[0].Visible = false;
But I get an index out of range error. And when I call, this.grdView.Columns.Count I get 0.
I have tried this on several events including: grdView_RowDataBound
I want to hide few columns of a gridview before they gets displayed. I want to do it by create a common function which can be used by multiple controls. I am using an extension and would like to know how it can be done.
Here is my code
[Code]...
I want to create an extension to hide or show columns provided in the list as an array. 1st function is used on page. While below two functions are needs to be used for multiple applications
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.
My grid view will display the data like below..
Id Name Mark1 Mark2 Mark3
1 aaa 50 30 20
2 bbb 50 30 30
3 ccc 50 30 20
if mark3 has all fields with 0 means i want to hide column mark3. How to do this..
I have a Gridview and I want to hide a column when empty. The code works then the column is in Boundfield but not in Templatefield. Can anyone show me the code of how to do it in Templatefield?
Here's my code using OnDataBound event:
protected void hideColumn(object sender, EventArgs e)
I have a webpage that lists information about trucks and their map sections and whether the combination is active and will be used.
On the page I put a check box that says Show Only Active and marked the checked property as true by default. When the RowDataBound event fires I check to see if that checkbox is marked as true and if it is I check if the individual map sections are marked as active. If they are not active then I set the row visibility equal to false like below.
[code]....
dv = new DataView(table);
Table.Columns.Add("ID", typeof(string));
table.Columns.Add("Type", typeof(string));
table.Columns.Add("EmpName", typeof(string));
table.Columns.Add("Manager", typeof(string));
row = table.Rows.Add();
row["ID"] = result["ID"].ToString();
row["Type"] = result["Type"].ToString();
row["EmpName"] = result["EmpName"].ToString();
row["Manager"] = result["Manager"].ToString();
Then I am adding boundfield to gridview for all 4 columns. Now I want to check if "Type" column contain "Sales" thne do not show "Manager" columns. Let me know can I do this?
I am using item template and eval function in the gridview to display the records. Can I add a coulmn which is not in the table?
I have to add some columns which is not in the table and assign the values from code behind to that particular column
I have 2 gridviews they are bind by sqldatasource ,it contains Id , Name and Price
i dont want to show ID coloumn when page is loaded.How to hide it?
How can I hide a column in a GridView ?
I tried using the markup:
<asp:TemplateField ShowHeader="False" Visible='<%# MyBoolProperty %>' >
<ItemTemplate>
<asp:LinkButton ID="attachmentButton" runat="server" CausesV
CommandArgument='<%# bind("ID") %>' OnClientClick="$('#b
Text='<%$ Resources:Resource,Attachments %>'></asp:LinkB
</ItemTemplate>
but it didn't work and gave me the following error:
Databinding expressions are only supported on objects that have a DataBinding event.
System.Web.UI.WebControls.TemplateField does not have a DataBinding event.
I tried also to hide it programmatically, but seems I can't reach to the column by name (there's no name for TemplateField column).
I am updating a gridview. Problem is that when I hide certain fields that I do not want the user to update, they lose their values ie. the data is wiped out in the field unless I show them on the grid and make them writeable. Is there a property I need to set for the field to retain the value when the grid is updated or is this in the sql statement?
View 7 Repliesi have done sending gridview data as excel to mail, it is working fine
then i had 5 columns in gridview but i want to send 4 column instead of 5 column.
protected void Button1_Click(object sender, EventArgs e)
{
fn_AttachGrid(); // here calling function to send mail gridview data as excel format
}
[Code]....
I want to hide a column of GridView based on a condition. How can I access the column in C# code?
if() // condition
{
// Disable code here. ?????
}
How to disable editing the data in the cells of datagridview in c#?
View 1 Replies
