Forms Data Controls :: DetailsView Hide The Column If No Data Present?
Mar 8, 2010
I have an application where I display the data from sql table to details view. There are many columns in SQL table, among them I combine two colums firstname and lastname to Name using templateField.
My code:
[Code]....
So, the problem is: If Name colum is empty, No data at all, I want to hide that Name column in detailsView.
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..
my requirement is : am having a excel sheet with some values listed i want to pass each value present in any(specified) column to a text box present on a remote page (a site other than mine) as a input and capture the result displayed on the page and then store the input and reuslt side by side in db this should repeat till the end of the input values in the excel sheet.
I've programatically created a DataView item by adding columns and rows to a table in the class file. Then I add that to my webform using a GridView. I'd like to hide some of the columns so that the end user doesn't see them but still be able to access their values.
How do I do this programatically? The table.Columns.Count returns the actually number of columns. Somehow when it converts into a DataView, it is only returning 1 column.
I am trying to hide the first column of my gridview, a template/command column.
I want to export my gridview to Excel and the teplated contol shows up in the Excel file as a column.
This is what I tried in code :
Me.GridView1.Rows.Item(0).Visible = False - This doesn't work ! Me.GridView1.AllowPaging = False Me.GridView1.AllowSorting = False Me.GridView1.EditIndex = -1 Me.DataBind() Response.Clear() Response.ContentType = "application/vnd.xls" Response.AddHeader("content-disposition", "attachment;filename=SearchedItems.xls") Response.Charset = " " Dim swriter As New StringWriter() Dim hwriter As New HtmlTextWriter(swriter)
How can I make the column of ListView Control invisible. The last column's header I have put in a label control and its item are in a html img control .
i have a detailsview with a dropdownlist. i would like to be able to select a value from this dropdownlist and depending on the selectedvalue display a specific control/header in another column.
I have a parent table and a child table. Essentially the parent table is called Contracts and the child is called Programs. Each Contract can have multiple Programs and in the Programs table I have a column called amount. On my page I have created a DetailsView that lists the columns of the Contract table. I would also like to include on this DetailsView a field that sums the Amounts column of all programs associated with this contract. How would I go about doing this? Currently I have a LinqDataSource that pulls all the columns from the Contract table and I have bound the DetailsView to this datasource.
Now in server side i am trying to hide this column but failed !!
protected void gv_RowCreated(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.Header || e.Row.RowType == DataControlRowType.DataRow) gv.Columns[2].HeaderStyle.CssClass = "hiddenClass"; // here i am setting display:None using css class }
I am facing a problem with Gridview control. I have created a Gridview1 which is having 3 button column that has been added at design time and some column can be added through the Datatable at runtime. At Design time GridView1 has 3 button column
At Runtime I do GridView1.Datasource=dt; //Now my gridview is having 7 columns i.e. 4 more columns added through datatable.
I can easily display that GridView1 on webpage but I dont want to show some column that I added through Datatable to the user.
When I try to hide that column, I get error like Index out of bound exception but when I hide button column I can able to do that easily.
I am new to using ASP.NET and I am using a datalist to represent the data obtained from querying a database.However,I am facing 2 issues:
1) If the string returned after querying the database is too long,the datalist is displaying the long string as it is which is not looking good.I am using Eval to fetch the data from the database for the sake of displaying.I need to have some page breaks so that the information fetched is presentable.
2) While repeating the datalist I want to hide all the columns except for 1 column whose value are unique.Upon searching I found this link: http://www.programmingknowledge.com/DataList.aspx but the code is in VB and I am not familiar with it.I am familiar with C#.
I am inserting the front end code for my datalist.I also want to know if datalist is the best control to present the data from the database.
I have a gridview, which contains a template field with a button. On this button, I want to show and hide another column with this one button. I don't want to use Java Script because my site already uses a lot of this and AJAX. So, can someone show an example of some code behind, which is what I want to do on how to show and hide another column on a gridview?
Now I wanted to hide, that is to make some of the columns visible false.
First how can I do that, Second should I write the code in the same page_load event or I should write the code some where else, cause when I add this line of code