VS 2008 Adding Columns To A Gridview Dynamically
Jul 13, 2010
I 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.
View 6 Replies
Similar Messages:
Nov 11, 2010
is there a way I can add a column dynamically from code behind to the gridview in my page?
View 5 Replies
Jul 27, 2011
I have a situation where I needed to add a row to my gridview. So say I have rows 3, 4 and 5.
My Datakeys are defined as "ID, CostingID". I did that so I can reference the two ID values I need when saving records.
here is the code in my RowDataBound event.
Basically if it is a datarow, I'm adding the value dataitems so I can get a sub total in the footer row.
Then, I have a boolean field called isDisbursement. So I sort my data by that field. So all records with the disbursement flag as true will display first.
Then as soon as the disbursement flag hits false I add a row to display the Total of the disbursement records value field.
All this works. My problem is, because I added a row at index 4 it inherits the datakey of the row that was at index 4 before. So when I'm looping through the grid rows to save the values I'm having a problem. I've attached an image so you will understand better what I'm trying to achieve. The "Total Disbursements" is the row I added. But it gets the following rows datakey because it is now at index 4.
when I do this, as soon as I reach row 4, although it doesn't have a CostingID it gets the CostingID of row 5 that used to be row 4:
Code:
Dim CostingID As Long = Convert.ToInt64(Me.grvCostings.DataKeys(row.RowIndex).Values("CostingID").ToString)
Dim strValue As String = CType(row.FindControl("txtValue"), TextBox).Text
Code:
If e.Row.RowType = DataControlRowType.DataRow Then
If Not IsDBNull(DataBinder.Eval(e.Row.DataItem, "value")) Then
_SubTotal += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, _
"value"))
End If
[Code] ....
View 1 Replies
Apr 20, 2010
I am returning an IList to my model of data about users. I want my end users to be able to select which columns they want to see.
I know I can do this with a huge "if statement" however, I know there must be a better way. I have created an Enum with the column names. I feel if I could take the IListItem.EnumName I would be set. However, I'm not too sure on how to do this.
View 2 Replies
Jun 30, 2010
Dim AlterTable As String = "alter table [Upload] add [Country] nvarchar (50) default 0 NOT NULL,[Address] int default 0 NOT NULL"
Dim connection As Data.SqlClient.SqlConnection
connection = New Data.SqlClient.SqlConnection()
connection.ConnectionString = ConfigurationManager.ConnectionStrings("ASPNETDBconnectionString1").ConnectionString
Dim cmdUpdating1 As New Data.SqlClient.SqlCommand(AlterTable, connection)
cmdUpdating1.CommandType = CommandType.Text
connection.Open()
cmdUpdating1.ExecuteNonQuery()
connection.Close()
This is the code which I am using for altering the number of columns in a table in the DB. so with this code i am able to add new coulmns dynamically. Now my major requirement in this is to obtain the headercount from the user( say "telephone number" and "language") and based on it generate the columns dynamically in the table in the DB.
View 12 Replies
Jun 29, 2010
I wanted to know if it is possible to dynamically add columns to a table in the Database?I know how to create a table dynamically in the DB the code for it is given below, howver I do not know, how do I add columns to it dynamically.
Dim NewTable As String = "CREATE TABLE Dynamic " +
" (" +
" job_id smallint" +
" IDENTITY(1,1)" +[CODE].....
View 7 Replies
Feb 25, 2010
I am working on an application, where a user will enter their primary information (Name, Address, Email, Phone etc), then enter their automobile information (usually a fleet of automobiles).
My web page currently has one row of text boxes (Car Make, Year, Model, VIN, Mileage, License Plate)
Below this is a button called "Add More Cars"
What I am trying to do here is allow the user to add more cars if they have more than one that needs to be registered.
My problem is how do I do this dynamically?
2nd problem, how do I collect the data entered by the user (for all cars), to be able to write them to the database?
View 2 Replies
Feb 24, 2010
My C# web app requires the user to enter automobile information. The user can add information for one auto, or more (max 20).
My page has these text fields: Car Number, Car Make, Car Year, Mileage, VIN I have a button that allows the user to "Add More Cars" is to allow the user to add more than one car.
When the user clicks "Add More Cars", how can I dynamically display the text boxes, and keep track of how many cars the user has added (in order to load them to an array and write to database)
View 3 Replies
Jul 7, 2010
I am using subsonic in asp.net forms C# and I have an instance where I need to loop through a recordset and for each one call the Database to get specific information from a view about that record.
in this instance it is a venue, loop through and for each venue I show there spend and there budget, but I am at a loss as to how I can say use a gridview, execute more code on each row and then add more columns to that row.
just as an update i have been playing with the idea of something like this:
DataSet ds = new DataSet();
ds.Tables.Add(LinqToDataTable(club.All().Where(x => x.level == 1)));
ds.Tables.Add(LinqToDataTable(ViewBudgetSpend.All().Where(x => x.periodfrom == curperiod)));
DataRelation relation = new DataRelation("budgets",ds.Tables[0].Columns["clubId"],ds.Tables[1].Columns["clubid"]);
ds.Relations.Add(relation);
still working this out though.
View 1 Replies
May 3, 2010
I've got a tough one (at least for me!). I have a gridview control which is actually from ComponentOne but most is the same as the normal gridview. It has a feature that lets me move columns around so they are in different order. I want to be able to click a button and see the order of these columns and which ones are visible. This is to be used for a custom report I am generating.
Does anyone know how to find out what columns are visible and in what order? I'm doing it in VB coding for asp.net.
View 3 Replies
May 13, 2010
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 Replies
Jan 6, 2012
I have a simple gridview control on .aspx page. It has one combo box in the gridview control and rest of the columns in the gridview control are all bound controls.
When the user picks something from combo box, I should multiply the number (picked from the combo box) with other number in the same row (meaning in a different column on the same row). I want to do all this in server controls not thru JQuery or Javascript.
Basically my problem is I am able to read data from unbound combo box control in the grid. But I should be able to read the contents of another bound column in the same row and perform multiplication between those two fields.
Code:
<asp:GridView ID="GridViewActuals" runat="server"
DataSourceID="SqlDataSource1" DataKeyNames="gl_number"
onrowcommand="GridViewActuals_RowCommand" Height="285px"
onrowdatabound="GridViewActuals_RowDataBound"
onrowupdated="GridViewActuals_RowUpdated"
Font-Names="Verdana" onrowupdating="GridViewActuals_RowUpdating1">
[Code] ....
View 2 Replies
May 14, 2010
I'm just wondering if anyone can assist me with this gridview problem
I have this Sql statement that outputs a gridview like this
Job Location Activity 1 Activity 2 Activity 3
Job1 Location1 0 0 1
Job2 Location2 1 0 1
Job3 Location3 0 1 0
* These columns are placeholders
I want to include a footer total that looks like
Job Location Activity 1 Activity 2 Activity 3
Job1 Location1 0 0 1
Job2 Location2 1 0 1
Job3 Location3 0 1 0
Final Total 4
Im not binding the database to the gridview via design view I'm binding it programatically in the default.aspx.cs file
So far the only tutorials I've encountered are ones the have the database bound through design view and gridviews with only one column that can be added. In my particular example I have multiple columns that need to be added and I have already bound the data to the gridview.
View 6 Replies
Mar 2, 2011
I have a Gridview on my aspx page. On my page_load event I check for a record in the database, if the record exists for that row in the gridview I would like to add a new column in the same gridview and add a button control to it. This adding of new column in the Gridview should happen in the codebehind (c#). see the code I wrote for this, but when I run it, it does not create any column on the gridview page.
[Code]....
View 6 Replies
Jul 22, 2010
I am trying to set come columns to invisible after all of the rows are binded but I'm having trouble. I'm hiding columns that have empty data which I save in a session variable. This works fine. Then I tried changing the columns visible property using the ColumnByName routine in the DataBound but that must be the wrong event because I do not think the columns exist yet.
The columns are autogenerated btw.
Where can I set the columns properties after it has binded? Can i do this before the columns are autogenerated the the screen itself?
View 4 Replies
Jan 21, 2011
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.
View 2 Replies
Sep 27, 2010
[Code]....
View 3 Replies
Jun 15, 2012
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
Jun 18, 2010
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 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 19, 2011
I'm having an issue with trying to add a button to my grid. My GridView is first loaded with data in the PageLoad event.
I'm then taking the data in the first cell of each row, and creating a button that will link to a URL. To get the URL, I have to run a query with the data in the first cell as a parameter. I was doing this in the RowDataBound event at first, but hitting that query for every row was making it really slow.
So I decided to add a button that would retrieve the URL only when you clicked the button.
Here's my GridView:
[Code]....
The grid generates fine, the button gets added to the grid for each row. But when I click on it, the RowCommand event doesn't fire, and the page just refreshes.
View 4 Replies
Jan 26, 2010
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?
View 3 Replies
Oct 21, 2015
[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
View 1 Replies
Dec 22, 2010
I have a gridview that I am dynamically creating and populating.
GridView myGrid = new GridView();
myGrid.Showfooter = true;
myGrid.Columns.Add(new BoundField() { HeaderText = "Serial #", DataField = "serial_number" });
...
...
...
myGrid.DataSource = myDS;
myGrid.DataBind();
My problem is that I'm having problems figuring out how to add a templatecolumn with a dropdownlist in it.
View 1 Replies
Mar 15, 2011
I've read a few articles on this, but I keep doing something wrong, and I'm not sure what. I took out all of my customization and just want to add a single header row to the very top of my GridView... Can someone show me how I'm screwing up? This is the code I'm trying to use...
[Code]....
I have tried a few different ways of referring to the GridView table... e.row.parent, gv1.controls[0], etc, but nothing seems to work.
I don't get any errors, just nothing ever shows up when the GridView is rendered. I can't find the code using Firebug to look at the HTML either... what am I doing wrong?
(have also tried using "0" for the rowIndex when creating the new GridViewRow)
View 3 Replies
