I have created Grid where in Columnsname come from Database and it will be generated from a setup page where Icreate column in SQL dynamically.
Now I wanted to have an idea about these grid. How to fetch data in this grid and how toinsert data into database.
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]....
I am working on the dynamic grid view(create dynamic columns).I need some thing like that given bellow in the fig:
columns1,2,3 are dynamic and the modules under the columns are also dynamic. to create grid like that.
Column1
Column2
Column3
Module1
Module2
Module3
Module4
Module5
Module6
Module7
Module8
in the gridview, i want the small lines to separate the columns.
I used row style property but it doesn't work.
tried to use gridview.columns.count to see if there are any columns bt it shows zero, second how shall i et the names of columns in the gried view at runtime i need them to be stored in an string array
View 2 RepliesI am developing an application using ASP.NET with C#.NET.in my application i have a gridview control and radobutton list having the values as Manufacturer and Distributor. based on the radiobutton selected value,the gridview will bindedup.
i am using SQL SERVER 2005 as backend server. in my database i have one table with columns as
1.mfropendate
2.mfrclosedate
3.mfrawarddate
4.distopendate
5.distclosedate
6.distawarddate
My gridview has 3 columns as Opendate,closedate,awarddate.
if user select the radiobutton as manufacturer,only mfropendate,mfrclosedate,mfrawarddate have to bind. and if user select the distributor the remaining 3 fields will have to bind. for that i had write a storedproc as create procedure sp_GetDraftBids as begin select mfropendate as opendate,mfrclosedate as closedate,mfrawarddate as awarddate, distopendate as opendate,distclosedate closedate,distawarddate awarddate from draftbids end GO
i.e i had taken the alias names for that fields so that i will bind the only 3 columns to grid view as opendate,closedate,awarddate.
My gridview code is
[Code]....
here i had taken the same alias names as i have to bind only 3 columns to gridview.when i run my application i am getting the records in data table with column names as opendate,closedate,awarddate,opendate1,closedate1,awarddate1.i.e it does not allow the same alias name.
for two radio button conditions i.e for manufacturer and distributor the gridview binded with opendate,closedate and awarddate columns as i had binded the gridview boundfields withat names.
but when user select the distributor radiobutton i have to bind the opendate1,closedate1 and awarddate1 to the gridview. for that should i can i change the storedproc are any other solution is there?
How to resize the width of columns of grid view? I want a column 250px wide.How I can do this?
View 4 RepliesI have search for a long long time and could not find a solution to access to grid view's column properties. I have binded a grid view through this method, the bindGridView function will return a table with columns and rows.
The problem here is I cound not access to columns properties such as Grid_View.Columns.Count or Grid_View.Columns[0]."something". It seems like the grid_view does not have any column. But I can access to the Rows properties.
I have put this code within a (!IsPostBack) and set the AutoGenerateColumns to true?
I need to access to columns badly as I need t add additional column to the binded grid view.
[Code]....
I have developed my application using ASP.NET with Visual Basic. I have a table that contains 3 fields. The name of the table is "Customer" and the names of the fields are "Name", "Address", and "Amount". I have a gridview that displays these three columns. I want to summarize the value in the "Amount" column for each record and display the summarize value in the footer of the "Amount" column.
I added some code to the "ItemTemplate" and "FooterTemplate" of the template for the "Amount" field and wrote two functions One function adds the value of the "Amount" field to a variable called "TotalAmount" and the second function 'gets' the value stored in the "TotalAmount" variable.
I am not getting any error messages and all of the items are displayed in the gridview but I am not displaying anything at the bottom of the "Amount" column. What more do I need to do?
This is my code for the "Amount" template:
<asp:TemplateField
HeaderText="Amount"
SortExpression="Amount">
<EditItemTemplate>
<asp:TextBox
ID="TextBox1"
runat="server"
Text='<%# Bind("Amount") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label
ID="Label1"
runat="server"
Text='<%# Bind("Amount", "{0:c}") %>'>
<%#SumAmount(Eval("Amount")) %></asp:Label>
</ItemTemplate>
<FooterTemplate>
<%#GetTotalAmount() %></FooterTemplate>
<FooterStyle
BorderColor="Black"
BorderStyle="Solid"
/>
</asp:TemplateField>
This is the code in my .vp file
Dim TotalAmount as decimal 0.0
Function SumAmount(ByVal Amount
As
Decimal)
As
Decimal
TotalAmount = TotalAmount + TotalAmount
End
Function
Function GetTotalAmount()
As
Decimal
Return TotalAmount
End
Function
I am using two Grid Views to display data. One (headersGV) is used to show custom headers which change depending on the device type in the second table (dataGV).
The second displays device data and is bound to db tables. This table has a sort mechanism enabled, the functionality of which is in the header cell of the table, hence the need for the headerGV for column headers.
I need to align these two seperate tables so that the headers align with the data columns in the other table. The dataGV columns dynamically resize depending on the data displayed.
I have tried inline styles, css bound to both tables at different levels of priority, onbind methods, and overriding DataBind() method.
I am trying to create a recipe system that will pull material amounts from an already built inventory database upon request for testing purposes of the different recipe runs. What is throwing me for a loop is that each time a user will request a recipe comparison they will have a different number of recipe trial runs for comparison purposes. In order to do this I'm guessing you will need to generate a gridview-like control with a dynamic number of columns which would be specified on a web form page prior to arriving at the recipe formulation page which will contain the control for the recipe formulation. As a result the user will have different columns and rows on this formulation page, with the rows being a static number of 30 (30 being maximum amount of ingredients to include in each recipe). The columns will contain the recipes to be compared, i.e. ProductRun1, ProductRun2, ProductRun3, where the number of ProductRunX will be determined by user input. So the user when they come to this aspx page will be presented with a blank editable grid of X columns by 30 rows deep. The left-most column will contain the ingredient names in a drop down box for users to select to input into their recipe and the rest of the columns will be editable fields where the user can type in the amount of each material to be used. The setup will look roughly like this:
| ProductRun1 | ProductRun2 | ProductRun3 |
ProductRun4 | ... |
-------------------------------------------------------------------------------------------------------
Material1 | Material1_Amt | Material1_Amt | Material1_Amt | Material1_Amt | ...|
-------------------------------------------------------------------------------------------------------
Material2 | Material2_Amt | Material2_Amt | Material2_Amt | Material2_Amt | ...|
-------------------------------------------------------------------------------------------------------
Material3 | Material3_Amt | Material3_Amt | Material3_Amt | Material3_Amt | ...|
-------------------------------------------------------------------------------------------------------
(...)
-------------------------------------------------------------------------------------------------------
Material30 | Material30_Amt | Material30_Amt | Material30_Amt | Material30_Amt | ...|
-------------------------------------------------------------------------------------------------------
So my question is how would I go about tackling something like this and what controls would I use. All of the forum posts around the internet show the GridView control being tied to data in a database already and not having the ability to have a fully blank and editable table upon the page loading so that it can accept user input. Another wrench into the situation is that the column numbers can vary. What control would be used in this situation or would it be better to use just a repeater of textboxes to build this type of control? Another thing is once the control is built how can you pull the data from such a control with the intentions of entering it inside a sql server database?
I have a grid with one itemtemplate field with autogenerated columns=true.I want to show the itemtemplate filed after autogenerated columns .
View 6 RepliesI am dynamically binding dataset to a gridview(No Columns at design time) .I need to show Totals for some of the dynamically generated columns in the footer.
View 3 RepliesI have a Gridview with autogeneratecolumn = yes since the datasource always returns different columns of data.
However, except from left most column, all columns to the right should be formated to #,###.#
How could I format these columns to the right dynamically ?
I have the following code:
[Code]....
With this code behind:
[Code]....
Initially, I wrote the GetTeamMember() method to display the FullName in the ItemTemplate.
Then as I wrote the EditTemplate, I needed to populate a DropDownList with a list of names (first and last). It was fairly easy using the LinqDataSource, however it currently only shows the LastName. I could write another method GetTeamMembers() to populate the ddlTeamMember with the data I want, but I thought maybe there's a better "LINQ" way.
So I'm looking for a better way to get FullName (i.e. Firstname + " " + LastName) into both lblTeamMember and ddlTeamMember.
Options I thought of are:
I could write a method GetTeamMembers() I write a StoredProc that returns the extra column Better way?
I have a requirement where on the left hand side we have a tree view control and on the right hand we have dynamic columns.
Below screenshot gives an idea of the requirement. what is the best way to implement this?
Year1, Year2, Year3 are dynamic and are based on the user input.
I put in my page 1 table like grid with this style:
header of columns are select from table persons(so number of them are dynamic)
header of each row are select from table goods(so number of them are dynamic)
in table , in each cell,show the price & the date ,that this person,buy this goods
for example,in may 2008 ,Jack&sara buy pencil.so in front of pencil&buttom of jack we write his price and in front of pencil&buttom of sara we write her price.
so this table has 2 column & 1 row
in may 2009,
Jack&sara buy pencil.so in front of pencil&buttom of jack we write his price and in front of pencil&buttom of sara we write her price.
and jhon buy pen & suzzan buy book so this table has 4 column & 3 row
Price Date
Price Date
Price Date
Price Date
Pencil
Pen
book
then I want in each cell,I have 1 CHECKBOX that user of my program,checked each on that want. how can I design my page?
is ther any component?or I must create <TABLE> dynamically
I need to bind a repeater with data having indefinite number of columns. How can i do that? Do i have to create template class for that?
View 7 Replies[Code]....
I want to merge these columns DescriptionHedding, Description and header text is Deacription
Need row editing on page_load for all the cells and need to validate each cell entry. Means cell1 one entery isvalid it fills thrid cell and insert or update to a table in the database. How do i handle on tab clicking to update in databse.
View 1 RepliesI have a condition to check weekdays with a particular time corresponding
to that day that were added to a grid view using a drop down list and two text boxes.
The drop down list has weekdays and textboxes has from and to time.
I have to verify a condition to avoid duplication of same day with same time should not occur in the table twice.
(i have used time picker jquery to get time.)
how should i write the condition in sql and use that in C#
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
i have a grid view with all columns as TemplateFields( No BoundField). Based on certain condition i have to set Visibility of few columns false. Suppose when there is no column 'CaseList2' in the DataTable, then the second column of the grid (whose column index is 1 )should be invisible. But when the Gridview binds it gives error DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'CaseList2'
i googled it and found that
GridView1.Columns[1].Visible = false;
should work. But its not working actualy.
Code:
[Code]....
Codebehind:
[Code]....
how to create dynamic template columns in gridview .
I have writing some of the code but it gives me error
The type or namespace name 'GridViewLabelTemplatecould' not be found (are you missing a using directive or an assembly reference?)
I have paste some my code
[Code]....
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]....
