Forms Data Controls :: How To Bind Grid View Columns Dynamically
Feb 9, 2010
I 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?
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.
I just want to bind controls to the grid view but i want to do it dynamically.As an example i just want to enter students marks to text box to adjacent subjects??
thinks students are in row's and subjects are in columns and it similar to matrix in mathematics . but some times no of students and no of subjects are vary.
i am wking on an assignment in which i have a gridview that contain deptno in a dropdownlist.by selecting a particular deptno from that dropdownlist,the number of employee of that department displayed in second dropdownlist that is for displaying employyee of a department.And after selecting the employee its salary detail and date of joining displayed in textboxes?we have two database table one is for employee(fields are deptno,empname,salary,joining date,status(true/false))and second department(fields are deptno,deptname,location);;;
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
I am trying to bind a table to my grid view. This grid view has an extra column Serial Number where I want to show numbers starting from 1 till the last entry.
I 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.
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 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'
My requirement is i want to bind data to gridview2 which is placed in gridview1..Iam using EDM objects to refer database...So for Gridview1 Iam getting out put...now how to bind to gridview2...For gridview1 I binded the data which is in onetable...And for gridview2 i want to bind MENU table data...so how can i bind the data...
this is the gridview2..in gridview1 row.
[Code]....
I also tried using FindControl() but iam not able to proceed further.
I have a gridview, in an update panel, that's populated by an object data source when the page loads. This same Grid View is going to use a different data source and slightly different columns collection at runtime. The columns collection will be very similar, with one column added and three removed. Is this the best way to do this?
The other solution would be to create another grid view and data source to use when needed. The two Grid Views can be toggled off and on to use the correct one as needed. I've done this and it worked well, as far as I can tell. I'm curious if there are performance implications because of the additional Grid views and data sources. Or, if there are other reasons not to do this.
Which of these two ways is the best way to do this? Should I toggle between the two Grid Views at runtime or modify the grid view(datasource and columns) at runtime in the code behind?
I want my gridview columns to have fixed width. Even though data is long,i want it to be shown only till the width permits. Further, I want to provide tool tip, so user can see full value in that. I don't want wrap to happen. Fixed width is working but data wraps. I tried all types. But no results.
Now I wanted to hide, that is to make some of the columns visible false.
First how can I do that, Second should I write the code in the same page_load event or I should write the code some where else, cause when I add this line of code
I have a grid view that displays some diary data that consists of a date, a diary entry and a diary entry type (eg holiday, info, meeting..)How can I change the background colour of a row depending on the diary entry type.So for example if the type is 'holiday' colour the row yellow, if its 'meeting' colour it red etc etc
i hav a dyanmically generated gridview with autogenerated columns = true.. i want to change the width of a column of a grid... i tried to do it in row databound event as...
e.Row.Cells[1].Width = Unit.Pixel(300);
but it doesnt work... and since d columns are genrated dynamically i cant set d width as grd.columns[0].width =...