Forms Data Controls :: On Fly Programatic Datagrid / Gridview In VB
May 12, 2010
I have a interesting problem and being relatively new to .NET I thought to try the forum for some guidance. I need to present information from a database, typical, but I need to create stand alone views of the data based on the "category" for the reported information. I don't know how many or how few categories I might need to generate but each needs to be displayed in its own datagrid or gridview. I did a prototype report where I could dynamically generate a variable number of columns in a generic datagrid already placed on the page based on the database but the user "changed their minds", also typical, and want a different view (actually views). Does anyone have any thoughts on creating anywhere from 1 to a dozen (or more) datagrids in the code behind and then pushing them out to the aspx page for the user? Can you dynamically generate datagrids and gridviews on the fly? Or would you need to?
View 3 Replies
Similar Messages:
Apr 5, 2010
Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.
The above error occurs with gridview control , when used with template field columns with item template / and edit templates etc.
updating a row within gridview, at the time of loadiong it loads perfectly fined, but when tried to modify an existing row within gridview control, then it produces the error. Make sure the grid view control has to be a child control which manages the child table info with in a master form. to reproduce the above problem the grid view must be loading the child records info of a master within the masterform, meaning both master data and gridview data all to be managed in one single form.
I had to replace gridview control with datagrid and then it worked perfectly fine. I wasted almost 4 days of my time., there is no way we could figure out the problem. here is the full info of the problem.
Server Error in '/' Application.
Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.
Source Error:
[Code]....
Stack Trace:
[HttpException (0x80004005): Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.] System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +306 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Page.LoadAllState() +312 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1661
Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082
View 2 Replies
Jun 30, 2010
Does any one know the way to convert the following from DataGrid to GridView?
[Code]....
View 1 Replies
Dec 23, 2010
I am going to have a page that list an (image, description, category) this needs to be an editable list (the user should be able to edit description or select a cateogry from a dropdown or delete the whole image). lets say I need to display 20 rows per page.here are my questions:1) should I use datagrid, gridview or datalist?2) would PagingBulletedList works well with any of the above control3) when I go to the database to get the rows , since i am going to have 20 items per page should I just bind the control with all the rows or should I just display the first 20 items and when the user click page 2 i go to the database to bring the second set of 20 items?
View 2 Replies
Apr 6, 2010
I have 2 grids gvParent & gvChild I would like to filter gvChild when a row is selected in gvParent the linking fields are contractNo
I added a column for selecting:
<asp:TemplateField ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Select"
OnClick="LinkButton1_Click" Text="Select"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
I know how to handle the filtering of the grid (create a criteria and set to rowfilter of the dataview) But, I dont know how to get the value of the column of the selected row.
View 5 Replies
Dec 7, 2010
i want to sort the datagrid(gridview) programatically.
View 4 Replies
Jan 29, 2010
I have a set of data that has been displayed as just a simple GridView with the item name being a hyperlink to view details. I'm attempting to update this scenario so certain fields (sortOrder and isApproved) are editable from the main page and do not require visiting each item in the grid. I have converted the GridView to a DataGrid and have included a TemplateColumn for the columns in question. I have them hooked up to display the values appropriately. At this point, I'm trying to find a way to peek into the DataGrid and it's related data source to determine if the values have changed on the click event of a button. At that point, I could persist those changes back to the respective SharePoint list.
I'm not very familiar with the DataGrid, or GridView for that matter. Can anyone point me in the correct direction on how I could gain access to the data source at an item/row level during a button click event where the button exists outside the context of the DataGrid?
View 1 Replies
Jan 29, 2011
I want to PIN the header part of my DataGrid or GridView? How is it possible? Ex: Suppose we have 100 rows in data grid, and 1 row with header. If you scroll data grid, header row shouldn't scroll. It should be fixed or PINNED. Only rows with data should scroll. Is there any in built function in data grid to achieve this functionality or any other methods to do this?
View 1 Replies
Mar 4, 2011
I have Datagrid , i want to clcik on row and get data in textbox , but my textbox is FreeTextBox control,i tried to use javascript but work for asp.net control not working for freetext box control, how i can capture this code is sample code but it work for asp.net control but not working for my freetextbox
[Code]....
View 1 Replies
Sep 22, 2010
Simply put... I want to duplicate the example found at this link, in VB.net rather than C#.
[URL]
I would like the selectedvalue of the dropdown to display additional data base on its selection in multiple text boxes.
I have tried using the DropDownList OnSelectedIndexChanged property, within a DataGrid EditiItemTemplate, but I cannot retrieve data from the selection. (AutoPostBack is "True"). I can however use a button onclick event to fire a "prre-defined" selection value.
View 2 Replies
Feb 25, 2011
I am familiar with populating a gridview with data. I am able to bind the Data pulled from the database into the gridview
gridview.DataSource = myDataTable;
gridview.Databound.
If I write the following code, teh gridview will no longer show the data
gridview.DataSource = null;
gridview.Databound.
My question is , I want to make the same thing with a user control that contain a gridview. when I use the user control in an aspx page, I am able to populate it with data, but when I try to make this code, the Datasource does not show, instead, I see .DV. So I tried this code but then , I do not see DataSource property instead I see DV (DataView), when I put .DV = null, I get an error message that the object is not in existed. any idea how to clear the user control gridview from its data.
View 2 Replies
Oct 15, 2010
I have a DataTable of datetime objects - starttime and endtimes for 1 to infinite (almost) weeks. I've created a webcontrol of my own because I can't get either a DataGrid, GridView or a Repeater to break line after each week in my DataTable.
But it most be possibly to make it happend.
My data is sorted by asc using my Startdate.
Is there an eventhandler on either of the mentioned controls where I can do my check for every 7th day and then make my control break into a new line for the next week and so on?
View 3 Replies
Aug 2, 2010
I'm trying to change one section in code from DataGrid format to GridView format. The reasoning is that the sample application that was displayed was using a DataGrid even though it should have been using a Gridview for 2.0 and above. Most of it shows up without an error except one line in 3 lines which are pretty much the same. I bolded them and just want to know how do I re-write them for the Gridview?
Protected Sub NewsGrid_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles NewsGrid.RowCommand
Dim connection As SqlConnection = CreateConnection()
If e.CommandName = "Delete" Then
Dim com As New SqlCommand("DELETE FROM ElectPageEditor WHERE NewsID = @NewsID", connection)
com.Parameters.AddWithValue("@NewsID", e.Item.Cells(0).Text)
Try
connection.Open()
com.ExecuteNonQuery()
Catch generatedExceptionName As SqlException
Finally
connection.Close()
End Try
ElseIf e.CommandName = "Edit" Then
Dim command As New SqlCommand("SELECT NewsText FROM ElectPageEditor WHERE NewsID = @NewsID", connection)
command.Parameters.AddWithValue("@NewsID", e.Row.Cells(0).Text)
Try
connection.Open()
Dim record As SqlDataReader = command.ExecuteReader(CommandBehavior.CloseConnection)
If record.Read() Then
NewsEditor.Content = record.GetString(0)
EditedNews.Value = e.Item.Cells(0).Text
lse
NewsEditor.Content = ""
EditedNews.Value = ""
End If
' Will close the connection as well
record.Close()
Catch generatedExceptionName As SqlException
Finally
connection.Close()
End Try
End If
' Add code to delete row from data source.
ReadAllRecords()
End Sub
View 4 Replies
May 27, 2010
I have 2 datagrid (using .net 1.1). I need to access column of second grid ( i need to make a column of second grid as disabled) when i click "Cancel" link button in First Grid. How can this be done?
View 7 Replies
Aug 9, 2010
I can't figure out what I"m doing wrong.. I followed this sample online at
http://www.4guysfromrolla.com/articles/091102-1.aspx to include a gridview in an email. But, it keeps throwing this error.. 'GridView' must be placed inside a form tag with runat=server.I've verified that the gridview is in a form, and there are no template fields in the gridview. Heres the gridview on my asp.net page..
[Code]....
[Code]....
View 3 Replies
Sep 30, 2010
I have "Order" object with Columns Ticket,OTP and CustomerName etc.Intially on DataGrid, I'm binding Ticket only , when user clicks on "Column Chooser" button, another windows appears to pickup CustomerName,OTP columns to add specified column dynamically on Datagrid. Environment : Asp.net ,C# with Object Data source
Public Class Order
{
publc void Order()
{
}
public string Ticket
{
get
{
return this.strTicket;
}
set
{
this.strTicket = value;
}
}
public string OtpNumber
{
get
{
return this.strOtpNumber;
}
set
{
this.strOtpNumber = value;
}
}
public string CustomerName
{
get
{
return this.strCustomer;
}
set
{
this.strCustomer = value;
}
}
}
}
View 1 Replies
Mar 30, 2010
I have the following script which is used with datagrid type of controls in my webform. would like to use gridview control in place of datagrid. Not able to find equivalent property in gridview for datagridcolumn. here is the script, it is used with datagrid headers text, want to achieve the same with gridview column headers.
If TypeOf (aControl) Is DataGrid Then
Dim aDataGrid As DataGrid = aControl
Dim aColumn As DataGridColumn
Dim i As Integer
i = 0
For Each aColumn In aDataGrid.Columns
i = i + 1
s1 = s & " c" & Trim(i)
aColumn.HeaderText = aHt(s1)
Next
end if
View 1 Replies
Jul 7, 2010
Ultimate goal is to provide protection against programming mistakes. I want to make sure that every page in a portion of my web application has a role specified like below. Ideally I would like to programatically check all requests coming in ( think IHttpModule ) and make sure that the page being requested has a role specified.
I can't seem to find how to get programatic access to the allowed roles.
[code]....
View 2 Replies
Mar 25, 2010
I created a Function called GetWordsLike("word") it look in database to get some words that they are like "word". i also have a TextBox in my page to get "word" from User.
i use ObjectDataSource to databind a gridView and this ObjectDataSource use the GetWordsLike("word") Function to get the data frome database.
now i need to give this "word" to ObjectDataSource programatic.
View 4 Replies
Jan 8, 2010
I had called the data from query to data table and now i have a gridview in which i am using one datalist and 2 text boxes and and reming coloumns are bounded iahve to assiaign them values which datatable have either null or any value.
View 2 Replies
Oct 10, 2010
I have a datagridview control that I'm using to display cache data to the end used on a web form. The issue that I'm having is that every time I re-run the application, and the cache data is re-generated... it loads duplicate data that's being displayed to the end user. I can't seem to figure out how to keep this from happening.
What I would like to have happen is that only unique data rows be returned and cached for the end user. Unless there are new data rows on the database that needs to be included in the cache data results...the previous data results should not be duplicated. I've tried to change a few properties on the datagridview control, but nothing seem to keep this from happening.
[code]....
View 3 Replies
Nov 10, 2010
How to set value to datagrid using vb.net? only for specific column but is for every row.
View 3 Replies
Jan 11, 2010
I have a problem there that is i want to insert the data in database from datagrid but i have various controls like textbox and datalist in grid view inside datagrid now i want to insert the values of that text box and datalist in database how i can do this.
View 5 Replies
Aug 18, 2010
I have to include a button 'del' in my datagrid. I already have two buttons 'savechanges' and 'cancel'. how to include one more option saying DEL in the same datagrid?
View 4 Replies
May 30, 2010
I am new to asp.net programming!!I have a datGrid Control on my web page and am able to load the data into the datagridafter loading the data to the grid , when i select a row from the grid I am loading those values into the text boxes that are present on Now what the problem , if my grid has say 20 records and having the vertical scroll to view all the 20 rows.
When i want to show the data of the 16 row ( say in this instance ) after scrolling the down for the 16 row ...after selecting the 16 row the data is getting posted to the corresponding textboxes ,but the here the data is getting scrolled to top after selection and not able to see the seleted row , for this i need to scroll down again!!!
View 4 Replies
