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:

Forms Data Controls :: Adding Columns To A Gridview Dynamically?

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

VS 2008 Datakey - Adding Row Dynamically To Gridview

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

C# - Dynamically Adding Columns To A Table In An MVC View

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

DataSource Controls :: Adding Columns To The Tables In The DB Dynamically?

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

DataSource Controls :: Dynamically Adding Columns To A Table In The Database?

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

Web Forms :: Adding Text Box Dynamically On C# 2008?

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

C# - Dynamically Adding Text Fields On C# 2008 Page?

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

C# - Adding Columns And Mid Binding A Dataset For Gridview?

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

VS 2008 - Seeing Order Of Gridview Columns?

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

Changing Gridview Columns Dynamically?

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

VS 2008 - How To Calculate Between Two Columns In Gridview Control

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

Forms Data Controls :: Adding All The Values In Multiple Columns In A Gridview?

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

Forms Data Controls :: Adding Dynamic Columns In An Existing Gridview?

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

VS 2008 Hiding Columns In Gridview After Binding All Rows?

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

Forms Data Controls :: Add Columns Dynamically In Gridview?

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

DataSource Controls :: Viewing Columns In A Gridview Dynamically?

Sep 27, 2010

[Code]....

View 3 Replies

VS 2008 Gridview - Hide Certain Columns And Change Column Names

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

Forms Data Controls :: Creating Gridview Columns Dynamically?

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

Data Controls :: Dynamically Insert Rows And Columns To GridView Like Excel?

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

C# - Dynamically Adding A Command Button To A GridView?

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

Forms Data Controls :: Gridview With Links / How To Dynamically Add Linkbutton Columns From Code Behind

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

Data Controls :: Dynamically Create GridView With X Rows And Y Columns On Button Click

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

C# - Dynamically Adding A Dropdownlist To A Template Column Within Gridview

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

Forms Data Controls :: Dynamically Adding Second HeaderRow To GridView?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved