C# - GridView - Columns.Insert() Cause Data To Vanish On Postback But Columns.Add() Works OK?
Oct 13, 2010
I 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.
View 1 Replies
Similar Messages:
Mar 18, 2010
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 Replies
Sep 20, 2015
I 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
View 1 Replies
Jan 13, 2010
My datasource is an ado data table that I have convert to a new data table so that each row in the original table is now a column with 1 row in my new table. I then bind the new datatable and create dynamic template fields with a text box where I bind the values. My problem is, when I try and retrieve the values changed by the user in the rowcommand event, the template columns no longer exists.
Does anyone know how i can retrieve these values? I've read over and over that you have to rebind the grid on each postback when you use dynamic templates, but I'm not sure how to do that and retrieve the values entered in the text boxes on the client side.
[Code]....
View 1 Replies
Aug 3, 2010
i am making relation between two datatables and m getting this error
in this ds.Tables(0).Columns("In_ID") datatype is string
ds.Tables(1).Columns("row_id") datatype is integer
how i do the type casting here to make dataset relation
ds.Relations.Add("Rel_1", ds.Tables(0).Columns("In_ID"), ds.Tables(1).Columns("row_id"), True)
View 3 Replies
Mar 4, 2011
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
View 3 Replies
Jan 19, 2010
GridView1.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 ?
View 5 Replies
Jan 27, 2011
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?
View 1 Replies
Jan 20, 2010
I apologize for the odd title. I've been trying to figure out how to do this and can't quite put it into words. Basically, I need to try to display a GridView with a whole bunch of columns (37 in one case) in two "rows" of columns. More or less.
So instead of this:
Column1 Column2 Column3 Column4 Column5 Column6
Data Data Data Data Data Data
Data Data Data Data Data Data
Data Data Data Data Data Data
I'd like something like this:
Column1 Column2 Column3
Data Data Data
Data Data Data
Data Data Data
Column4 Column5 Column6
Data Data Data
Data Data Data
Data Data Data
As in the example there can be multiple rows returned which all need to be displayed. I'm trying to stop a very large horizontal scroll bar being required. I've been searching as much as I can but haven't found anything that fits what I'm looking for.
View 1 Replies
Sep 20, 2010
I 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]....
View 1 Replies
Jan 13, 2010
I m trying to add template columns at run time. but it get lost on post back ,
I have to add columns on postback ,what approch should i use that the columns should not diappear at postback
View 1 Replies
Apr 21, 2010
I have two columns first name and last name , that have duplicates, how can i remove the duplicates and only leave the distinct members intact?
View 6 Replies
Jun 30, 2010
I've created a new ASP.NET website. I've generated an Entity Data Model from my database and have dropped a entitydatasource and gridview onto my page and wired up the gridview to pull from the entitydatasource. Now I get columns like this: id extension prefix did_flag len ten_id restriction_class_id sfc_id name_display building_id floor room phone_id department_id
In each case where the item is named something_id this reflects a foreign key relationship in the database - and I did choose to have the EDM expose foreign key relationships. I'd like to make it so the gridview pulls in the values for these foreign keys rather than just showing the ID numbers - so, for example, department_id might have a value of "101" right now but it should pull from the department table "Marketing".
View 1 Replies
Feb 9, 2010
I am developing an web application. One of this form has a textbox. When the user enter chars i need to fetch the records from db and display as 4 columns in AUTOCOMPLETEEXTENDER CONTROL TOOL KIT and it's column name also. When the user click any one of the row, i need to get the 2nd clicked column name and display it in textbox.
how to display 4 columns and it column name in autocompleteextender control?
View 1 Replies
Feb 21, 2010
I am trying to arrange the report parameters in three columns instead of two columns. I have about 13 report parameters . Is there a setting anywhere to be done.
View 6 Replies
Mar 17, 2011
I have a gridview with predefined columns and a selectcommand. Why do I get the columns twice? I want to keep the predefined columns and the selectcommand, but avoid getting the columns double.
<asp:GridView ID="gvMeldingen" runat="server"
AllowSorting="True" DataSourceID="MyDataSource"
onselectedindexchanged="GridView_SelectedIndexChanged"[code].....
View 1 Replies
Mar 5, 2010
I'm creating a table in an asp.net code behind dynamically, and I want to have a footer row that only has 2 cells. The first should span all the columns in the table-1. Is there some way other then keeping track of the # of columns in the table manually for me to set the colspan to be # of all the columns in the table-1? Preferably a HTML or CSS solution?
View 2 Replies
Feb 21, 2011
I've the following code which successfully makes an average for all the columns from a table. What I need to do though is ignore certain columns in this equation.
Dim totalNumber as Double = 0
Dim count as Integer = 0
For x = 0 To xyz123.Tables(0).Columns.Count - 1
Dim current as Double = 0
If Double.TryParse(xyz123.Tables(0).Rows(0)(x).ToString(), current) AndAlso current <> 0 Then
count += 1
totalNumber += current
End If
Next
Dim averageRating as Double = totalNumber / count
View 2 Replies
May 8, 2010
I have a Access DB. I have relations with two tables. For example In my table1 I have three columns as T1ID, Name, Description and Tbale2 I have three column as T2ID, T1ID which is a foreignkey from Table1 and desc.
What I want is that : for example, I wanna copy the columns from table2 which has the value of 2 under the foreignkey field and I wanna insert them into table2 again with the value of 3 under the foreignkey field !
View 4 Replies
Mar 11, 2010
I have table contains 457 columns i need to ecport this table data to Open Office Calc spreadsheet.
Uisng c# in asp.net
View 3 Replies
Oct 19, 2010
I have a SQL Server 2000 table with 7 columns and would like to add a constraint that prevents a row being added with the same value for both Col2 and Col3.
So, for example, if Col2 = 205 and Col3 = 5, then the constraint should prevent inserting another row with the values for Col2 = 205 and Col3 = 5.
The following is an example of what I would like to prevent:
Col1 Col2 Col3 Col4 Col5 Col6
1 205 5 1 1 1
2 205 5 0 0 0
View 2 Replies
Feb 22, 2010
I Need to insert a row in a excel plan.It's ready filled with some data... I just want to put a new blank row in the plan and fill four columns with a kind of title to that collum.
View 1 Replies
Aug 1, 2010
I am trying to insert 8 different selected values from a CheckBoxList into 8 different columns of a database. As it now, I am only able to concatenate all 8 selections into a single string in one column. But this is not what I want to do. In my DB I have Column1, 2, 3, 4, 5, 6, 7, 8. Is there any way of getting this done?
View 5 Replies
Jun 10, 2010
I am trying to sort Columns in Gridview. In case, I set AutoGenerateColumns="true" and code the gridview as under:
<asp:GridView ID="GridView1" runat="server" AllowSorting=true onsorting="GridView1_Sorting">
</asp:GridView>
And in .cs:
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ViewState["sortOrder"] = "";
[Code]....
ie if I set AutoGenerateColumns=false and define Template Field, Sorting is not done. Can Anyone tell me how to sort a Gridview when AutoGenerateColumns is set to false and Template Field is defined?
View 3 Replies
Feb 20, 2011
I have a GridView with 5 fields. Only two of the fields are edittable (the others are READONLY).
I have an UpdateCommand as follows
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:NHLPOOL %>"
SelectCommand="SELECT [PlayerID], [Firstname], [lastname], [Goals], [Assists], [Goals]+[Assists] as Points, [AsOfDate] FROM [PlayerStats], [Player] where [PlayerStats].[PlayerID] =[Player].[ID] ORDER BY Points DESC"
UpdateCommand="UPDATE PlayerStats SET Goals =@GOALS, Assists =@ASSISTS, AsofDate=GETDATE() WHERE PLAYERID = @PLAYERID">
</asp:SqlDataSource>
The issue is I want the PLAYERID GV column to be READONLY but I get a runtime error when updating if the PLAYERID is READONLY.
I get the error "
Must declare the scalar variable "@PLAYERID"."
View 1 Replies