There is a small advancement in my app, developing using ASP.Net and C# on fx4.0. Requirement is that my client needs dynamic paging size. He wants to set page size of all gridviews approx 10-15 , as needed. If he wants 5 then my app will display 5 and if he sets 10 then the app will display 10.
View 1 RepliesI need to create a dynamic gridviews with pagind ans sorting events .I tried like this
foreach (DataTable table in dsDynamic.Tables)
GridView gv = new GridView();
gv.ID = "gv" + table.TableName;
gv.SkinID = "grid";//theme for gridview.this theme has the gridview page size 5
[code]...
I am dynamically creating columns for my GridView and the DataFormatString is not doing anything.
Code snippet
[Code]....
I am in need of some assistance in regards to how to best set the values of properties for a Web User Control which is being included into a cell of a GridView with dynamically created columns. I have tried a few different approaches, but can't seem to get a satisfactory result. Also, to be completely honest, I am not really sure if I am using best practices for what I am trying to accomplish.
First off a little background:I have a GridView for which we will never know the exact number of columns at run time. The columns are predicated by user selection. I am creating the command text for the DataSet on the fly and then looping through the columns of the resulting DataTable in order to use custom TemplateFields. This works ok for just printing out the row values but not so much for when I need to insert the Web User Control into a cell.The Web User Control is in essence a collection of image links which are used as a "Quick Nav" tool. I need to pass the values of 2 fields from each DataRow to the control via properties (for example, CustID and ProductID). I am using custom TemplateField classes inheriting from ITemplate for displaying my fields and extending the DataBinding event like so: [Code]....
This won't work for my User Control as DataBinding is called after the control is loaded into the page and I need the properties to be set before the Page_Load event of the control is fired.Is there a GridView event I should be looking into instead such as RowCreated or RowDataBound? Or should I modify how I loop through the DataTable by doing rows first, then the resulting columns as I've seen done elsewhere?
Is there a way to use the GridView paging and having the links not use JavaScript. So that when you click on the page number 5 (for example) that link is a hyperlink.
View 3 RepliesI'm guessing this is actually an impossible task, but I thought I'd run it by StackOverflow to see if I'm wrong. Basically we have some dynamically created URLs for SEO purposes (around 300,000+ of them) and we want to do 301 redirects to them.
Our current URLs look like this:
http://www.site.com/<Brand>/<Product Name>/<productGuid>
Our old URLs looked something like this:
http://www.site.com/productpage.aspx?productGUID=<productGuid>
Google still has a load of the old URLs indexed, but we obviously want them to know that they should be replaced with our newer ones (and that it's not just duplicate content), hence the 301 redirects.
Our problem is that the <Brand> and <Product Name> parts of the new URLs are obviously dynamically created... making it impossible to create 301 redirects for them.
I'm binding data to my dropdown as follows:
[Code]....
So my dropdown will be populated with a list of years that could be different depending on the SchoolID passed in. I want my default value to be the max returned in the SELECT query minus 5 (so in other words, the max index minus 5). For example, if my list of years was:
2004-05
2005-06
2006-07
2007-08
2008-09
2009-10
2010-11
2011-12
2012-13
2013-14
2014-15
Dim conn As String = ConfigurationManager.ConnectionStrings("Elevation-TestConnectionString").ConnectionString
i have a page where i have a search area for users and a blank table. When a user performs a searcg,im creating in the cs the rows for the table and adding in the cells textboxes with values from DB. The textboxes ID´s are also being retrieved from the DB. Then, the user can change values from the textboxes. I also have an asp button that´s supposed to save the changes BUT i cant manage to persist the ids and last values between postback. Ive tried something ClientScript.RegisterArrayDeclaration but the array comes up empty. Then i used a hiddenfield but does the same trick.
what am i doing wrong?I add the hiddenfield,i try to add all the controls ids to an array but seems impossible,and there is no way i am getting the last values in another array. Im loosing everything between postbacks, but if i manage to save these ids and values, ill re-make the table in a sec.
I have a page that is currently generating dynamically created textboxes in a table format. The users are requesting that the tab order be changed from horizontal-vertical to vertical-horizontal. I know that you can use the tabindex attribute to control the tab ordering, but I can't for the life of me figure out the right way to get the sequential number properly for the textboxes. I guess this is more of a math question than anything else!
FYI, the textboxes are made while looping two different collections. First collection looped to make the rows, for each row, second collection (which is a property of the first collection objects) is looped to create the columns.
I'm wanting to adjust this code to pull the theme name from a database table, instead of just manually assigning a theme in the file. This way a site administrator can set the theme dynamically. If never done this with a global.asax file, so I'm not sure what the best way is to accomplish it?
Here's the code that needs tweaked:
[Code]....
The database table could be "ThemeName" with rows ID & Theme. If performing this in the global.asax file will cause any big performance issues.
I have a user control (i.e. ascx) that comprises of two related list boxes (i.e. once you change the selected item in one list the contents of the other list update). I'm adding this user control dynamically to a page on the click event of a button (i.e. using LoadControl).I wish to set the list box datasource properties, as well as the default selected item of the parent list from my parent page so I created public properties in my user control to accomodate this. I also created an event in my user control that notifes the parent page when the selected item changes in one of the list boxes so I can update the contents of the other list box.
I understand that I have to recreate the user control on every postback in order for it to function correctly but I'm not sure exactly how I should be doing it. I've shown below what I have currently - whilst it works the problem is that on postback I'm always creating the user control with all its default properties and then updating the properties that need to change(?). For example, when the choice in theparent list box changes the datasource of the list box is set twice (once in AddControl and then again in OnParentChanged)? As the contents of the list boxes originate in a database it means I'm making unnecessary calls to the database (unless I do some something like store each unique set of data in the ViewState).
I'd be very grateful if someone could review how I've done things and illustrate how perhaps I should be doing things. I'm not sure if the way I've done this is considered the 'correct' way. For example there may be a better way of doing things would avoid setting the properties twice? I'm a bit unsure of the way I've set the datasource properties of the list boxes and bound them. I wished to set the datasource from the parent page because I might have a second user control on my page that may also use the same datasource and I could reuse it (as opposed to each control making its own call to the database) so I'd like to keep this feature if possible.It would be great if posting code in reply that you use my example as a guide so I know what you're referring to.Here's the code for my user control:
[Code]....
[Code]....
Here's the code for my containing page:
[Code]....
If there's a better way to accomplish what I'm attempting I haven't found it yet. That being said, I have create a gridview like the one here,[URL]And with some minor tweaking it working great for all my fields, checkboxes, etc. The issue is my last column is another gridview, and I'd like it to function the same. that is, a dynamic gridview inside of a dynamic gridview. I get that I have to create it initially with null values or it won't show up. I guess what I'm having trouble figuring out is instead of go will null data in the parent gridviews column, do I place my blank child gridview. Do I create and bind the child gridview first, or second. Generally just not sure. Also, as far as storing the data from the child gridview goes, will each one need it's own datatable?
[Code]....
[Code]....
I have a Webform with a TextBox (Static) and 3 TextBox (Dynamic - based on the following article: [URL].... )
How to use this scenario with a single GridView table?
Based on the User input, the GridView might have (1 + 3) columns; (1 + 6) columns; (1 + 9) columns; ...etc.
I have a parent gridview5 with child gridview 6, today i deployed it to our dev server and on that server we have alot more records, so for the nested gridviews i need to enable paging on the parent gridview5. Doing so works fine, until i make a selection within the child gridview6, once any selection is made, and i try to page the page throws an error, i have the following bound to the parent gridview5.
[Code]....
[Code]....
Issue when setting Display ="Dynamic" for Required Field Validator.Here is my ASP.NET code. Simple. it has a A textbox associated with a required field validator and a submit button.
[Code]....
Do the following
1. Click on Button1
2. RequiredFieldValidator will be shown
3. Type some text in TextBox
4. Use your Mouse(no tab please). and click on the button , you can see that your page does not "POSTBACK" and only the validation gets cleared. you need to
click again the button for Submission of Form.This seems to be a bug by Microsoft when setting the property Display ="Dynmaic" and Is there a easy workaround without changing the intended behavior for this available?
In my asp.net Page I am using gridview. I am binding the gridview on page load and on paging event with one method. suppose as Bindgridview1();.
There is one search button for searching the records of user with different method suppose as Bindgridview2(); Â .Â
when I am searching the records with Bindgridview2(); paging doesn't work and directly bind with Bindgridview1(); which is on page load when I clicked next page.
I'm trying to extend the GridView control to enable sorting and paging for any situation.
When using my control I am fetching data from a database and filling a DataSet with it, then binding the GridView upon every page load. My first question would be, is this the correct approach?
To sort the GridView I am overriding the OnSorting method which stores the sort expression and direction in the ViewState, then creates a DataView and utalises the Sort method to sort the underlying data. It then sets the Data Source to this DataView and rebinds the GridView.
Paging is handled by OnPageIndexChanging which simply sets the PageIndex property and again rebinds the GridView.
My problem is; when any control causes a postback my GridView is no longer sorted, presumably because it is persistently rebound. If I don't rebind it then the GridView is empty on postback since the data isn't automatically stored in the ViewState. I have considered saving the data source in the ViewState but I would assume that this is bad practice for large amounts of data? - also DataViews are not seralisable.
The only solution I can think of currently is to override OnDataBound and sort the data every time. This results in a double sort when paging triggers a postback which seems inefficient. Code illustration of this below,
[Code]....
I'm looking for the cleanest 'best practice' solution as this is a learning exercise more than anything else.
I have a GridView that is populated via a dataset that contain 1 table. I have enabled paging on my GridView.
In my Updating event, I handle the new values and call a store proc to update my database with the new values for the selected row. In order to minimize the call to the DB, instead of getting back a new dataset with the updated values, I simply update the row of the dataset that I have in session with the new values and then I bind back my gridview.
The problem that I have is since I have let's say 5 pages of 10 row... If I update a row on the first page as soon as I click update, the gridview will show the new values. However, if I select page 3 for example, click on update and update the values, once the update is done, the gridview will still be displayed with the old values.
My question is, can I control the style of the paging element separately of top and bottom, I have set the paging to appear in both top and bottom of the gridview, and I want to see that the top pagination is little high up in the page, to do that I used the cssClass and set margin-top:20px and made the position: absolute, this does change the position of the top paging area and set it rightly for me, but the bottom pagination has also come up as a result and now sits inside the grid data!!
View 3 RepliesOn my gridview I allow paging. After the user leaves for a new screen is it possible to have them return to the gridview page they had?
View 8 RepliesI hoping someone could answer a question for me. I am relatively new to developing web applications with .NET and I have question I can't seem to find a straight answer to. When allowing paging of a GridView control, how does retrieve the data per-page? Is all the data stored into an object, and then displayed x amount of rows at a time? Or, when moving from page to page, is it executing each time but restraining the result to the specified amount of rows?
View 7 Repliesi am paging my grid view datas. now am on 3rd page of gridview. in 3rd page i have list of buttons in each rows. when i click on one button it goes to another webpage. where i edit datas and save. when i click on save it comes back to page having grid..which loads from 1st page of grid...i want to load the 3rd page of gridview itself.
View 2 RepliesI have followed Custom Pagination article to implement the custom pagination using GridView.
I have also done custom pagination using the DataGrid but i am still confused on following things.
DataGrid which is there in the ASP.NET 1.1 having VirtualItemCount which is set to render the pagination interface [1 2 3 4 5 ... something like this] GridView does not have the above mentioned property then how to generate the pagination UI?
I am retrieving data from sql database. I want to split the records and binding it in three different grids. Everything is working fine before applying paging. I am getting The data source does not support server-side data paging. error
Code:
DataTable StoreDisplayTypeList = storeDisplayBL.GetStoreDisplayDetails();
var specialBook = from myRow in StoreDisplayTypeList.AsEnumerable() where (string)myRow["StoreDisplayType"] == "Special Book" select myRow;
var newRelease = from myRow in StoreDisplayTypeList.AsEnumerable() where (string)myRow["StoreDisplayType"] == "New Release" select myRow;
var Seller = from myRow in StoreDisplayTypeList.AsEnumerable() where (string)myRow["StoreDisplayType"] == "Best Seller" select myRow;
var featuredEdition = from myRow in StoreDisplayTypeList.AsEnumerable() where (string)myRow["StoreDisplayType"] == "Featured Edition" select myRow;
this.gvBestSeller.DataSource = Seller;
this.gvBestSeller.DataBind(); // Error
this.gvNewRelease.DataSource = newRelease;
this.gvNewRelease.DataBind(); // Error
this.gvSpecialBook.DataSource = specialBook;
this.gvSpecialBook.DataBind(); // Error
this.gvFeaturedREdition.DataSource = featuredEdition;
this.gvFeaturedREdition.DataBind(); // Error
protected void Button3_Click(object sender, EventArgs e) //export
{
GridView2.AllowPaging = false;
GridViewExportUtil.Export("Сводка.xls", this.GridView2);
GridView2.AllowPaging = true;
}
I need to avoid pageing for XLS export :-/