below is my code using for simple gridview and i am only having problem with the sorting and paging is working as expected and i even define the ONSorting event but it still throws me an error: [Code]....
[Code]....
My griedview code :-
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" RowStyle-BackColor="Black" Font-Names = "Arial" Font-Size = "10pt"
HeaderStyle-BackColor="Black" HeaderStyle-ForeColor="Black" ForeColor="Black" AllowPaging ="true"
OnPageIndexChanging = "OnPaging" PageSize = "5">
[Code] ....
Error is:- The data source does not support server-side data paging.
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.NotSupportedException: The data source does not support server-side data paging.
Source Error:
Line 34: con.Open();
Line 35: GridView1.DataSource = cmd.ExecuteReader();
Line 36: GridView1.DataBind(); Line 37: con.Close();
Line 38: }
I added a radiobuttonlist to the page.
<asp:RadioButtonList ID="Pending" runat="server" AutoPostBack="True"
OnSelectedIndexChanged="Populategrid" Height="16px"
RepeatDirection="Horizontal" Width="755px">
<asp:ListItem Value="250">Pending Over 250</asp:ListItem>
[CODE] ..
following is the code i write
[code].....
it gives error"The data source does not support server-side data paging."
i grid view contain the following coloum
id name DateofBirth DateofJoining
1 a 22-Aug-1980 10-jan-2000
1 a 22-may-1980 20-feb-2000
1 a 12-Feb-1980 15-mar-2000
1 a 3-Aug-1980 7-jan-2000
how to sort if we click DateofBirth or Dateofjoining and not sort any where if we click(Id,Name)
protected void BtnSave_Click(object sender, EventArgs e) {
try {
lblErrorMsg.Text = "";
GridView1.Visible = true;
string str = ConfigurationManager.AppSettings["prink"].ToString();
[Code] .....
I am using Object Data Source to bind data in the gridview. I haveset the property AllowSorting=true. While running the application, Icould sort the data only in ascending order. Is there any way toachieve two way sorting in gridview ie. both ascending and descendingon successive clicks ?.
View 1 RepliesModerators Note: THIS ISSUE IS BIG FOR ME AND EVEN IF POSSIBLE, GET THE REPLY FROM THE DESIGNER OF GRIDVIEW. I have been looking for him for long. I am really fed up with reviewing a good lot of web pages on how we can possibly customize the gridview to enable sorting and paging. So many sites have listed out a lot of information and so many guidances. But the problem is that one works out fine and the other is a burden. I really feel bad about being given the job of customizing this kind of a gridview which has no user friendly approach to it. Also, this control is rendered without the pager links inside the <tfoot> tag. I have tried the Pear Pager in php. It is that good and easy to use and compared to that, the gridview in asp.net is the worst ever control i have ever tried so far.
1. i can use the images to indicate the sorting direction
2. I can have the custom pager like
[code]
<<Previous 1 2 3 .. 7 Next >>.
[/code]
When i click the next when i am viewing the page at 3 , the pager links should change as
[code]
<<Previous 2 3 4 .. 7 Next >>
[/code]
Kindly look into this type of requirement and firstly tell me whether this is possible with the gridview control. I would like this request even to be escalated to the designers of the gridview control also, so that Microsoft comes out with a reply THAT WORKS and not the kind of stuff like surfing through a lot of links and pages and finally wasting a lot of days precious time and still breaking the head with this useless control. I have spent a lot of time in searching for a perfect way. Not writing a code that is non-standard. I am really serious b'cos I have spent weeks in customizing this control. If I dont get a solid reply atleast now, I am going to generate all the output by HTML content by custom coding.
This is my code and i am only able to edit the one data under the category school.But what i nd is to edit the other categories like the name,email...etc..how do i modify my code in the update command.Another thing is to delete the data how do i do that?
[Code]....
I'm new to ASP.net 3.5 and trying to create a test site so I can figure out how to use it in the real world. I have created a FormView (Formview1) based on a Client table using Linq Data Sources. The page includes a DropDownList to lookup Clients. I have added a list option (<asp:ListOption value="" Text="(Select Client)" and set AppendDataBoundItems=true so my added option is displayed. I decided to try to use Formview with only the Edit and Insert Modes, and I have set the Default Mode = Insert. When you open the page, a blank Client record is displayed.
The Client record contains serveral lookup fields and they have drop down lists for each. When I select a client from the Client DropDownList, is get the following message 'ddlClientType' has a SelectedValue which is invalid because it does not exist in the list of items I had this problem before and decided the best way to handle this (in the interim) was to turn off foreign key constraints for each of the lookup fields (e.g. ClientType) in SQL Server. That worked for 2-3 days. Now the problem has started again.
When I develop in other applications, I would simply create a lookup data source based on a Union Query with the actual data and a blank record. How can you do this using Linq DataSources. Can you get access and modify the queries?
I am using a ListView and i want to get my datatables sorted by clicking table headers. I am binding my ListView to DataSet via DataSource peoperty of ListView.I donot want to use ObjectDataSource or SQLDataSource Controls.
View 2 RepliesI've been using the Item Inserted event for my data controls, such as details view. I'm wondering if there are advantages to doing this with the data sources instead of the data control. There is a lot of overlap in the events provided by these two types of controls. Are there advantages to using the events raised by the data source instead of the ones raised by the data control itself. Should I be using the events raised by the data source instead of the control used to enter the data?
View 2 RepliesI just need implement something in order to sort data DESCENDING instead of the default ASCENDING.
I have a Gridview and I tried some code like this:
[Code]....
protected void gv_data_Sorting(object sender, GridViewSortEventArgs e)
when i sort the grid and it is display in sorted order and when i go to next page it will show data in default order. how to maintain sorting order duing paging
View 9 RepliesFollowing Code is for Sorting GridView Formed With DataSetSource: ttp://www.highoncoding.com/Articles/176_Sorting_GridView_Manually_.aspxBut it is not displaying any output. There is no problem in sql connection. I am unable to trace the error,
[Code]....
aspx page
<asp:GridView ID="GridView1" runat="server" AllowSorting="True" OnSorting="GridView1_Sorting">
</asp:GridView>
I have a GridView or DetailsView and its bound to a CslaDataSource.I noticed that the "Object_Select()" event is fired automatically with every time the page is loaded or refreshed.How I can perfrom mnaual biding between the DetailsView Control and CslaDataSource ?I want to control binding via code using the DetailsView.DataBind() method in certain cases only.
View 4 RepliesI'm creating a page that allows the user to create a new object that will later be stored in the database. The problem is that the design of ASP.NET data controls seems to insist upon only working with pre-existing data that has been stored in a database (or XML, etc...).
I'm basically trying to get the user to compose a list of items and specify a quantity for each item. I could do this by generating table rows but the rows are lost at each postback. The data view controls seem to be designed only to be bound to a data source but until the list is complete, the data can only be in memory.
What control is appropriate for this and how can I achieve this with that control?
Actually i am using procedures and calling them using linq.I have a gridview and there is no data source bound to it in aspx page.I am binding different procedures with gridview in code behind.I am feeling myself unable to sort the data.
here is my code on page load event
if (Request.QueryString["Id"] != null)
{
if (Request.QueryString["Id"].ToString() == "0")
{
var list = db.prcSelectTodayNewListing();
gvListing.DataSource = list;
gvListing.DataBind();
}
else if (Request.QueryString["Id"].ToString() == "")
{
var list = db.prcSelectListing();
gvListing.DataSource = list;
gvListing.DataBind();
}
else
{
var list = db.prcSelectListingByStatusId(Convert.ToInt32(Request.QueryString.Get("Id")));
gvListing.DataSource = list;
gvListing.DataBind();
}
}
well i m making a project in asp .net c# i used data gridview which is bound at run time after many calculations... problem occured when i want to sort it.
View 8 RepliesI am using Visual Studio 2010 and SQLServer 2008. I have a GridView and code is
[Code]....
And populating grid on Page load Event like this.
[Code]....
I am trying to create FormView that has details aboout author. But some details about his books like pubdate, title resides in some other table. In the source page:
<asp:Label id"AuthorName" Text='<% #Bind("au_fname")%>' runat="server/>
but this field has to be obtained from other table:
<asp:Label id="AuthorTitle" Text='<% #Bind("title")%>' runat="server"/>
the title resides in titleauthor table, can we use two connections(author, titlesauthor) simultaneously.
Am using the following 2 events for child grid.
1. RowDataBound
2. RowEditing
I enable AutoGenerateEditButton = "true", which can show me edit button in the child grid. Also i have tried to use the event rowediting which can return e.NewEditIndex too. for the master i use sqlDatasource design time. for the child grid am confusing how to do the edit/delete/add.
following link good enuf for master grid
[URL]
for child grid datasource if am not mistaken, guess need to assign the datasource during runtime. am not sure how to do this?
Following is the link for my so far trial
[URL]
[Code]....
[Code]....
I have extended GridView in order to have consistent look & feel, paging and sorting. However, when the page is first time loaded, the select method is getting called twice. It works fine when i move between pages in pagination.
Note, i am using Asp.net 2.0.
i wanted to retrieve things from the data base and perform mathmatical operations on it then post it to the user, so i was told to use the bullited list and bind it to the object dataSource
how to perform such thing??
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 ?