I use Server.Transfer("pagename", True) to navigate from a page where two dates have been selected to a page with a gridview that uses the dates to query the database and display the results. The gridview initially displays correctly but when I operate the select or sort it disappears.
View 8 RepliesI have a page with a TextBox, a Button, a GridView, and a SqlDataSource. I click the Button to execute the SQL in the TextBox using the SqlDataSource. The SqlDataSource populates the GridView. Everything works as expected until I click a column heading to sort.
When I click a column heading, the GridView disappears and I have to click the Button to display the grid again. When I do, the grid is displayed in the order of the column I clicked.
I don't understand why the GridView is disappearing when I click a column header.
Does anyone know how to fix this so the GridView is sorted and displayed only by clicking the column header?
ASPX:
[Code]....
Code behind:
[Code]....
Just spent about 8 hours googling and looking through this forum for a solution on how to make sure that I can dynamically sort. Here is the situation.
I have 1 Gridview that displays 10 different scenarios based on what button is clicked.
I am also returning only top 10 records. I am doing all of the data binding pragmatically. So I have BoundFields, HyperLinkFields etc.
I also want to sort some records. When I change DataSource SQL statement the gridview somehow remembers what the last sort value was and it errors out saying that value "x" cannot be sorted because it does not exists.
I tried this:
Tried setting gridview1.sqldatasourceid = null; gridview1.allowsorting = false; gridview1.databind();
Here I get an error that says that the data source does not support sorting? Doesnt it say gridview1.allowsorting = false;
I also tried gridview1.sort("", SortDirection.Ascending); This does nothin... except query my database one more time because i have a onSorting event that looks like this:
[Code]....
Here is an example of just one of those SLQ statements inside GetSQLQuery:
[Code]....
I have a gridview where in the users are allowed to edit certain data and there is an update on top of the page which will send out all the changes made inside the GridView. But, the problem is , as soon as the update button is clicked, the grid disappearsand no update is made. This problem occurs when the size of the data on the page is huge. When we have less amount of data on the gridview, It does update. But, when there is a huge amount of data on the gridview, it does not. We have tried to increase the page size on the server, but to no use.
View 3 RepliesI'm trying to figure out why my gridview disappears when I trigger the rowediting event.
The Gridview:
[Code]....
The code-behind:
[Code]....
When I click on the edit linkbutton, the gridview disappears. What is going wrong?
I've got a Gridview in which I use the RowDataBound handler to color the lines according to certain conditions
(ie if column x is value y then change the background-color of the row to z etc).
One problem though, as soon as I do a postback the coloring disappears altogether and all rows become white.
Is there some way around this so I can retain my background colors even after a postback?
I am populating a column in a gridview with a dropdownlist as follows:
[Code]....
[Code]....
When I edit the gridrow, the dropdown is there and I can select a new item.
But I can't find the dropdown during the rowupdated event. The cell control says it's a Textbox. All of the other items in the row are fine and I can get the data back. But I can't get the DropDown item.
Here are some of the things I have tried in the RowUpdating event:
DropDownList test = (DropDownList)e.FindControl("ddlPeriod");
//null
DropDownList ddl = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlPeriod");
//Also null
var test = row.Cells[8].Controls[0];
//Says its a textbox.
I have a datarepeater inside which I load a gridview. After the grid's binding is done I create an extra header line to group the columns (that's the only way I could do it, I couldn't figure a way to add an event for a control inside the repeater).That works fine and the page displays perfectly.However everytime I do a postback from other controls, I lose the 2nd header and 1 extra empty line appears at the top of the gridview
View 5 Replieshave an ASP.net 4.0 page containing a GridView, where during the Page_Init event I'm dynamically adding BoundField columns to the gridview. I also have some custom sorting and paging methods that I use with this gridview, which result in postbacks on the page. In Chrome, Firefox, Safari, and Opera the gridview behaves as expected. HOWEVER, in IE 6, 7, or 8 when I click to sort a column in the gridview, or go to the next page of results in the gridview, it does not bind on postback, returning nothing back to the browser. Again, in anything but Internet Explorer, paging and sorting (frankly any postback event) brings back the gridview in its expected state. I only have the problem in IE. Relevant snippets of my code follow, where you'll see my Page_Init event calling a method in my WebFunctions class to add the BoundField columns for the table I pass to it, and my Page_Load event that calls the method in the user control responsible for binding my dataset to the gridview. Initial page load works in all browsers, but postback loading of the gridview only works in non-IE browsers.
[Code]....
I have a gridview with daatsource from MembershipUserCollection. When my collection doesn't contain any records the gridview just disappears. I want to display the empty gridview indicating no records exist rather than the grid just become invisible.
How to make gridview always visible ?
I have a simple dynamic gridview with following code -
GV = new GridView();
I have a gridview with data. I want a button which is not part of the gridview. Then if I press a button the gridview is sorted by two colums. i.e column1 ascending column2 descending.
I am not looking to work with a Sqldatasource as I use a data access layer. So the sort would have to be from a datatable and databind or directly with the gridview.
I have a small problem I am returning some data from a query and have allowed paging, however when I click on the next button to view the following page the gridview disappears.
My datasource is specified in the code behind:
<asp:Panel ID="dtpanel" runat="server" Visible="False">
<asp:GridView ID="grddetails" runat="server" AutoGenerateColumns="False" AllowPaging="True"
OnPageIndexChanging="grddetails_SelectedIndexChanged" ViewStateMode="Enabled"
onselectedindexchanged="grddetails_SelectedIndexChanged" AllowSorting="True" >
<Columns>
<asp:BoundField DataField="Col1" HeaderText="Col1" SortExpression="Col1" />
<asp:BoundField DataField="Col2" HeaderText="Col2" SortExpression="Col2" />
<asp:BoundField DataField="Col3" HeaderText="Col3" SortExpression="Col3" />
<asp:BoundField DataField="Col4" HeaderText="Col4" SortExpression="Col4" />
<asp:BoundField DataField="Col5" HeaderText="Col5" SortExpression="Col5" />
<asp:BoundField DataField="Col6" HeaderText="Col6" SortExpression="Col6" />
</Columns>
</asp:GridView>
</asp:Panel>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void GridView2_SelectedIndexChanged(object sender, GridViewCommandEventArgs e)
{
int y = Convert.ToInt32(e.CommandArgument);
Control control = GridView2.Rows[y].Cells[0].Controls[0];
LinkButton btn = control as LinkButton;
string qval = btn.Text;
string query = "SELECT * FROM Table WHERE Col LIKE '%" + qval + "%'";
string connectionString = @"Data Source=servername;Initial Catalog=dbname;Integrated Security=True";
SqlConnection accessConnection = new SqlConnection(connectionString);
SqlCommand accessCommand = new SqlCommand(query, accessConnection);
SqlDataAdapter grddetailsDataAdapter = new SqlDataAdapter(accessCommand);
DataTable grddetailsDataTable = new DataTable("Table");
grddetailsDataAdapter.Fill(grddetailsDataTable);
int dataTableRowCount = grddetailsDataTable.Rows.Count;
if (dataTableRowCount > 0)
{
grddetails.DataSource = grddetailsDataTable;
grddetails.DataBind();
}
dtpanel.Visible = true;
}
protected void GridView1_SelectedIndexChanged(object sender, GridViewCommandEventArgs e)
{
int w = Convert.ToInt32(e.CommandArgument);
Control control = GridView1.Rows[w].Cells[0].Controls[0];
LinkButton btn = control as LinkButton;
string qval2 = btn.Text;
Label1.Text = btn.Text; string query = "SELECT * FROM Table WHERE Col LIKE '%" + qval2 + "%'";
string connectionString = @"Data Source=servername;Initial Catalog=dbname;Integrated Security=True";
SqlConnection accessConnection = new SqlConnection(connectionString);
SqlCommand accessCommand = new SqlCommand(query, accessConnection);
SqlDataAdapter grddetailsDataAdapter = new SqlDataAdapter(accessCommand);
DataTable grddetailsDataTable = new DataTable("Table");
grddetailsDataAdapter.Fill(grddetailsDataTable);
grddetails.DataSource = grddetailsDataTable;
grddetails.DataBind();
dtpanel.Visible = true;
}
protected void grddetails_SelectedIndexChanged(object sender, GridViewPageEventArgs e)
{
DataTable dataTable = grddetails.DataSource as DataTable;
grddetails.PageIndex = e.NewPageIndex;
grddetails.DataBind();
dtpanel.Visible = true;
}
}
i read Matt Berseth article also i downloaded this source. But i can not do sorting event. Everything is ok but sorting is not working.
[Code]....
I have a gridview with Edit buttons, which turn into Update buttons when pressed:
[Code]....
It worked fine before I added DBInterfaceGridView_RowEditing handler:
[Code]....
Now it seems to be working in Debug mode, but in Release when I press Edit, the gridview just disappears.
I want to create simple rating page where player's place,name and rating is displayed. I've created database with ID,Name and Rating Columns, binded Gridview to this database and created TemplateField "Place". With following code I've created numbered list for Place:
protected void Page_Load(object sender, EventArgs e){
for (int i = 0; i < GridView1.Rows.Count; i++)
I have 12 columns in a grid i want sort 3 of them when user clicks on Header, how can i do this.
U want these columns to be sort WOnumber,DD,PO.
I'm a newbie to .NET, so the solution might be really trivial. I have a database, I have an Entity Data Model, I add in my Index.aspx page an EntitryDataSource and a GridView. I connect them and everything works fine (the data is displayed as expected). The problem is that clicking on the coulmn name or on the pagination lists doesnt do a thing... Although I did set the properties AllowSorting="True" and AllowPaging="True". I also tried with another datasource type (SqlDataSource) and the same problem.
View 2 Replies[Code]....
Gridview does not sort on gvClaimDetails_Sorting
i am having a gridview in which all columns get dynamically added, i applied sorting in it, all column added as boundcolumn get sort properly but two column which are added as templated column do'nt get sort. Though my dataview have these column as it is.
View 2 Repliesi have the following code . .
[Code]....
i need to sort according to Due_By i mean most recent one shpuld come first . .
I am using gridview created by visual components. I have registered gridview_onsortclick event during the page initialisation, but when i try to click on the header of any column, this event does not get fired at that time. This event gets fired only after all the controls, sorting query is generated, filling the current dataset is done. But the same event is getting fired before query is generated and dataset is filled,for the other page. And one more thing to add with it, I want the sort function to be done on the whole dataset regardless of current page. Why is there such a difference in both the pages?
View 2 RepliesI have gridview. some columns are data, and some are link buttons. now, I need move these link buttons to a hovermenu. this is done. but I got a javascript exception, and it is because if there is no row was selected in gridview, it will pop this.
so, the question is: how can I select a row in gridview without select command? simply by code?
Is there a way to Sort a Gridview by a Calculated Column? I have a gridview with template fields using lablels and a linq datasource. Those columns sort just fine. I can not get the Calculated column to sort, because there is no sort expression to use...
View 4 RepliesI have the following sorting code that works find when clicking on a column header in a gridview.
Now, I'd like to fire this sorted table & fire it on load instead of having the user have to click a column heading.
how to do that?
Here's my code:
[Code]....