I haven't had any luck finding the answer yet. My problem is that I want to be able to update the dataformatstring on a gridview column at runtime. For example, I switch from displaying # of units to cost of said units... and I want to change the format of the column to {0:c}. It seems like it should be a simple task.
View 2 RepliesHow is it possible to change the displayed order of columns from a DataTable?
For example, dataTable "dt" contains two columns "a" and "b". I bind it to a GridView like this:
gridView.DataSource = dt;
gridView.DataBind();
But I'd like the GridView to display "b" first (leftmost).
Important point: I'm using this to export to Excel and there's no actual output to screen, using:
HtmlTextWriter htw = new HtmlTextWriter(sw);
gridView.RenderControl(htw);
I have a stored procedure that returns a dataset with a different number of columns and different column names depending on user input. How can I use this with a GridView? Normally I define the columns beforehand in a static fashion, but, have never done a dynamic dataset like this.
View 1 Repliesiam using ASP gridview. And i declare one label in headertemplate for setting heading of a particular column. How can i dynamicallly change the header text on a particular button click..
View 2 RepliesHow to change the skin ID of the dynamic controls
View 2 RepliesI have seen code for adding columns at runtime but here is another scenario for you. I am using a SQLDatasource control for my gridview. And the data returned can have different columns based on the filter meaning one time I may have a column A1, A2, A3 and another time I may have A2, A3, A4. Is there any way I can look at the columns when it is binded at the beginning and add the columns first?
I really need to use the SQLDatasource though because I am connecting to an AS400 and it is using a connection already made in the webconfig and do not know any other way. I do if it was MSSQL server but not this.
I have gridview which auto generate column is false, and I add some template columns, databind with a class ClassA . it works fine. now, I need add some columns to this gridview. the problem is: I do not know the # of columns that will be added (it is dynamic), and the data with these columns is in ClassA, but it is a array (or list). so, there is no public property for these data, only the array.
now, what I did is: I dynamically add template column to the gridview (column header ...), so, it shows the correct columns in the gridview, but how can I bind the data? I found some example, i.e.
[URL]
but it is for aleady know the data field (which is a public property in the class). all I have is just a array, and I need bind them to the newly created columns in sequence.
[Code]....
View 3 RepliesI'm trying to change the text of a GridView label in an ItemTemplate and I am having some issues. I searched all over and can't find a solution. This is what I am trying to do...
I have a GridView that has a comment field. Normally when the page is rendered the comment field is truncated using a truncate class that limits field length. The full contents can be displayed in a tooltip when the comment field is hovered over. That part works fine.
I also have an export to Excel class that will take the Gridview and export it to Excel and that part works fine as well...
Now the issue... Because of the truncated field, when I do an export it will export exactly what is in that field, the truncated version of a comment. When the export button is clicked I need to change the .text value of the label that is in the GridView ItemTemplate
From this truncated version...
[Code]....
And then back again after the export routine is complete.
I have accessed the contents of a label before using FindControl but never set a value, is this possible? Also, I have captured what is in the comment field on RowDataBound but by that time, it is already truncated.
I want to create columns in gridview dynamically based on rows in a table and each gridview colum should have a checkbox. When I Click the save button, I want to save the checkbox state. How Can I do this ?
View 2 Repliesis there a way I can add a column dynamically from code behind to the gridview in my page?
View 5 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 been searching for some time on the net for guidance on this question. Finally thought I will ask here...
I have a gridview that needs to be generated from code behind. There is a column with a name field and the remaining columns give the different user-ids linked to that id. Like this:
-- NAME, ID1, ID2, ID3......
The Name column will be populated from a table that has the Name as well as number of ID's associated with that name. eg [Name1][3]
I need to display linkbuttons that link to user-id related documents in columns 2 to n for each name.How do I dynamically add linkbutton columns from code behind?
[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
I currently have a table with a repeater that is being filled with data
<table width="100%" >
<tr>
<td class="add_border_bold" nowrap>Title</a></td>
[code]...
I have a DataGrid that is bound to a data set. Down column 1, I need each row in the column to be a link to another page or just plain text - which I can determine post-bind.
e.g.
<table>
<tr>
<td>Row 1</td>
</tr>
<tr>
<td><a href="page2.html>Row2</a></td>
</tr>
</table>
Can this be done in a DataGrid? I need to give the user an indication in the cell that there's a link versus no link to another page.
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 have certain columns in my DataSource such as "ID", "StartTime", "EndTime", etc.I would like to present them a bit differently in the listview.for example, I want to present the "StartTime" and the "EndTime" in ("hh:mm:ss") form, and would like to show only IDs smaller than 10.I thought about writing the code in
protected void ListView1_ItemDataBound(object sender, ListViewItemEventArgs e)
{
}
I have no problem writing the conditions in code behind, but the question is:since the ListView1_ItemDataBound event handler is fired for every column, how can I know in which one I am concerned, and so which condition to use?for example, if it is a "StartTime" then I want to have (DateTime)item.ToString("hh:mm:ss"), but if it is "ID", I only want to check if ID<5.
URL....According to my requirement based on columns value button text is changing. But I want to apply some action on it. Means previously, I used Command Name for a button and in Row Command event I have written the code which was working. But now, after writing this code I am getting an error message. Because now the button is converted into template field.
View 1 RepliesI have a GridView that has several dynamic columns (I do not know how many at design time and it could be 0-12 columns, hence need for dynamic columns). I have the columns in the grid and data bound to them - works great. There are other standard, design-time TemplateField columns with TextBox controls in them. These are bound with values that the user can edit. The grid is posted back via a Submit button. My question is "Why does gv.Columns.Insert() cause all my TextBox data to be null on Postback, but gv.Columns.Add() works like a champ?"
protected void BuildColumns()
{
// The first column to begin to insert the columns in the GridView
int columnIndex = 5;
BoundField aoColumn = new BoundField();
aoColumn.HeaderText = "New Column 1";
gvMyGrid.Columns.Insert(columnIndex, aoColumn); // kills txtQuantity.Text on postback
gvMyGrid.Columns.Add(aoColumn); // works fine
columnIndex++;
foreach (MyEntity my in _myEntityCollection)
{
BoundField myColumn = new BoundField();
myColumn.HeaderText = String.Format("{0:d}", my.StartDate);
gvMyGrid.Columns.Insert(columnIndex, myColumn);
columnIndex++;
}
}
I then go on to assign values to these BoundFields in the _RowDataBound method and all of this works great. However, when I post back and try to reference some TextBox and they are all null. And yes, I have the BuildColumns() call wrapped in if (!IsPostBack) on Page_Load. Of course I would like to use .Insert() so that the columns can go in the proper location and not at the end of the Columns array.
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 Repliesif there is a way to dynamically change the session ID from the context of a SessionStateStoreProvider (or some other customizable module) in C# for ASP.NET.
I am implementing a custom SessionStateStoreProvider, and I was thinking about augmenting the session ID to tell the store provider where to go look for a session. I've implemented a custom SessionIDManager, which lets me augment newly created session IDs with the required tag. The problem is that the desired value of that tag might change during the life of a session. For example, the session may be read from one location, but may need to written to a different location. In this instance the ID would have originally been tagged for location A, but on writing the store would want to write to location B. The tag should be updated to reflect location B for the next session read.
So, from the context of SessionStateProviderBase override...
public override void SetAndReleaseItemExclusive(HttpContext context,
string id, SessionStateStoreData item, object lockId, bool newItem)
... is it possible to change the session ID? I know that the HttpContext.Session.SessionID property is not settable. Is there some other way to feedback an update like this? Or is there a more appropriate to carry state like this across calls?
this may or may not be a big deal but what I am looking to do is based on some data returned to my view I want to change the background-color to what value is being returned. Black, Yellow, etc.... How can I in my aspx page set my Style background-color based on this value in the model. I know Attributes are used in Web forms control but not sure in MVC how to do this
View 3 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 ?
I have a datasource, which includes many columns, idealy, I need use a gridview to show:
1) first 3 columns: template fields, these fields depends on values in some columns of datasource. I use template fields, hard coded. works fine.
2) the other columns. This is I do not know how to do it. In the data source, there are about 10-20 columns data, each time, the # of columns of the data varies. idealy, I need show each of them as a seperated column in gridview. The entire data source may have 30 columns, but some of them are used in 1), and I only want show these 10-20 columns in gridview. Some columns in data source, I may not use them at all. is there a way to do this? or have to seperate them as a detail view style UI?