I have 2 tables with a relationship by EmployeeID (Employee, Cases)
The relationship name is Purchases (ie employee->Purchases), and iterating through it gives each row in order by date (entry order perhaps?).
There could be thousands of rows, so I want to present this collection in reverse date order.
Would I have to define a provider or repository to call instead of just Employee->Purchases?
Here's my gridview when it comes it it's sorts on Age. Sorting is available for all columns/headers. How do I make the sort order to change on the ddsrpt sort to desc order when it's clicked?
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource7" EnableModelValidation="True" Width="789px"
CaptionAlign="Top" Height="126px" BackColor="White" BorderColor="#DCBE68"
BorderStyle="Solid" BorderWidth="1px" CellPadding="4"
HorizontalAlign="Center" CellSpacing="2" Font-Names="Arial"
AllowSorting="True" EmptyDataText="No Records" DataKeyNames="FO,CLMSSN">
[Code] ....
I got this error message - Gridviewsortdirection is not declared
I'm using Entity Framework for my object-relational mapping, and jqGrid for my grid.
I have an Employee entity, that contains a ContactID field. I have a Contact entity that contains fields FirstName and LastName.
I want to display a list of Employees in a grid, and give the user the ability to sort by FirstName and LastName.
Here's what I have right now:
public JsonResult GridData(string sidx, string sord, int page, int rows)
{
var pageIndex = Convert.ToInt32(page) - 1;
var pageSize = rows;
var totalRecords = GetAllEmployees().Count();
var totalPages = (int)Math.Ceiling(totalRecords / (float)pageSize);
IQueryable<Employee> employees = GetAllEmployees().
OrderBy(sidx + " " + sord).
Skip(pageIndex * pageSize).
Take(pageSize).ToArray();
}
As you can see, this only gives me the ability to sort by fields in the Employee entity, so I can't sort by FirstName and LastName.
How can I modify this to accomplish that?
I have a simple dynamic gridview with following code -
GV = new GridView();
The AjaxToolkit has a ReorderList. I'm searching for a jQuery solution that does the same and found this page. I would like to change the order of divs (vertically) and upload the new order to the database (ajax).
View 2 RepliesI try to sort a dictionary with no success
this code i wrote
var sortedDict = _GrandTotalUserDictionary.OrderBy(key => key.Value.Priority);
the dictionary looks like
"key1", new OrderItem(){title:'a', priority:1}
"key2", new OrderItem(){title:'b', priority:3}
"key3",
new OrderItem(){title:'c', priority:12}
If I have a specific order that I want to sort my List by, how do I do that? For instance, I have a list of items (coming from a database), with ID's ... and they come in order, i.e 1, 2, 3, 4. After receiving this list, I'd like to reorder the list above based on a specific order, e.g. 2, 4, 1, 3. How do I do this without complicate it too much?
View 11 RepliesI am wondering if the aspnet_Users table is always sorted (by UserName) even if I add new users which are alphabetically between two already existing users.
I've noticed that the method Membership.GetAllUsers() always seems to return a sorted collection of MembershipUsers.
Also when I look into SQL Server Management Studio and run a simple SQL query without ORDERBY clause...
SELECT [UserName]
FROM [MyDb].[dbo].[aspnet_Users]
...I get always a sorted result list.
I'm still very unfamiliar with SQL Server but I expected that when I add a new row to a table it is (physically) appended to the end of the table. And when I run a select statement without ORDERBY the rows will be selected in the order they were initially inserted into the database (so without any specific sort order).
I am wrong I guess. But how does it really work? Is it perhaps something special with the aspnet_Users table?
I am happy that the MemberShipUserCollection returned by GetAllUsers() is sorted but is it always guaranteed?
Update
I've just noticed that the database contains a stored procedure called aspnet_Membership_GetAllUsers. This procedure actually contains an ORDER BY clause by UserName. So if this stored procedure is indeed always called when I use Membership.GetAllUsers() in my code (at least if I am using the SqlMembershipProvider) it explains why the collection returned by Membership.GetAllUsers() is sorted by UserName.
Remains the question: Is Membership.GetAllUsers() actually based on this stored procedure?
How do I sort a data table based on a particular column which has integer values in ascending order?
I wrote this:
leadtable.DefaultView.Sort = "Id"
But it doesnt seem to work, it displays fine but when i get try to get the values of the sorted datatable in an array they dont come in an sorted ordere Datatble is defined as:view plaincopy to clipboardprint?
I am trying to correct the sort order of my ASP.NET drop down list.
The problem I have is that I need to select a distinct Serial number and have these numbers organised by DateTime Desc.
However I cannot ORDER BY DateTime if using DISTINCT without selecting the DateTime field in my query.
However if I select DateTime this selects every data value associated with a single Serial number and results in duplications.
The purpose of my page is to display data for ALL Serials, or data associated to one serial. When a new cycle begins (because it is a new production run) the Serial reverts to 1. So I cannot simply organise by serial number either.
When I use the following SQL statement the list box is in the order I require but after a period of time (usually a few hours) the order changes and appears to have no organised structure.
My webGrid is working perfectly fine. However, I would like the default sort order to be in the opposite direction. If it were SQL, I'd be adding a DESC somewhere. Here's my working line of code:
[Code]....
It correctly sorts on the UWDate column, but I would like it to sort the opposite sort order. Of course, once it is displayed, you can click on the title and it will resort at that time.
How to sort the dataset Values in Descending order , I have Followed the following way
decimal Length = 94;
decimal Width = 7;
decimal Height = 13;
DataTable dtCarton = new DataTable();
[Code]....
I have the following code for a gridview. When I click the Header, it can be sorted by ascending order. But if click the header again , it is still ordered by descending. What I want is that the sort order can be reversed when click the header again. How to do that?
protected void gvList_Sorting(object sender, GridViewSortEventArgs e)
{
DataTable m_DataTable = (DataTable) Session["gvListDatasource"] ;
if (m_DataTable != null)
{
[Code].....
For our website, we have decided we would like to maintain our user passwords as encrypted binary data in our database. We are using ASP.NET 3.5 to host our site and SQL Server Express 2008 for the database, both running on the same server. When a user logs in and submits a username and password, there will need to be some sort of encryption or decryption in order to verify the credentials. To me, it would appear that there are 3 ways to do this:
1)[C# Encyrption] On User creation, perform encryption in the Web App and submit the encrypted password to the database. To verify credentials at Login, perform the same encryption on the submitted password and ensure that it matches the value stored in the database.
2)[SQL Encryption] On User creation, submit the plain-text password to the database and have it perform one of the SQL encryption variants during INSERT. To verify credentials at Login, have the database perform decryption on the password during the SELECT statement, and compare the plain-text submitted password to the one in the database.
3)[Mix] On User creation, submit the plain-text password to the database, and have it perform one of the SQL encryption variants during INSERT. To verify credentials at Login, perform the same encryption algorithm used by SQL on the submitted password ( is this possible? ), and ensure that it matches the value stored in the database.
Does anybody have an opinion as to which of these options is best? Number 1) is the most familiar to me, and would be the easiest to use with LINQ to SQL ( which is our current data model ), so I am leaning towards that. But if there are better options I would love to know about them.
I want to orderby the list. Today date is on the top and then next date and all dates but when today date is passed then it comes on the end of the list. Is there any formal query in linq or some other code is used to achieve this?
08/01/2015
09/01/2015
but when today is passed then it automatically go to end and next today date is on the top
How do I sort a data table based on a particular column which has integer values in ascending order?
I wrote this:
'Sort the datatable based on sequence id leadtable.DefaultView.Sort ="Id" But it doesnt seem to work Datatble is defined as:
[Code]....
I have a datatable,columns are(User_id,Name,Address,DOB)
values like(12,abc,delhi,22/2/2000)
(14,pqr,mumbai,13/3/1989)
(8,klm,banglore,17/5/2001)
(9,asd,pune,12/9/1999)
Now I want to sort these rows on DOB in descending order..how can i do so?
I have seen the MVC source code,and I found that the source register the Areas like this:
foreach (Type areaRegistrationType in areaRegistrationTypes)
{
AreaRegistration registration = (AreaRegistration)Activator.CreateInstance(areaRegistrationType);
registration.CreateContextAndRegister(routes, state);
}
so... how can I change the order without change the source code?
I am buiding web application about news.My problem i need to change order of articles in that category.
Example :
+ Article A ----> position 1
+ Article B ----> position 2
+ Article C ----> position 3
+ Article D ----> position 4
+ Article E ----> position 5
+ Article F ----> position 6
All articles A -> F are inside category. Sometime i want to Article E is position 1, or article C in position 6 ...and so on Now i can't imagine what i have to do ?
Tried this:
<HeaderStyle CssClass="headerstyle" />
And in the css:
.headerstyle a{
text-decoration:none;
color:#7dad4a;
display:block;
}
But nothing...
I found this article on how to manipulate the rendering sequence of asp.net controls.: [URL]I placed some placeholders on the page to encapsulate the controls i want to move around. The problem is, that RenderChildren does render the controls without the html i placed into the placeholder like this:
<asp:PlaceHolder id="phOneToMove" Runat="server" Visible="true">
<tr>
<td><asp:Literal id="label1" Runat="server">Caption</asp:Literal></td>
<td>
<asp:TextBox ID="textbox1" runat="server"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator ID="validator1" Enabled="true" ControlToValidate="textbox1" runat="server" EnableClientScript="False" ErrorMessage="error"></asp:RequiredFieldValidator>
</td>
</tr>
</asp:PlaceHolder>
The controls are rendered without the tr and td around.How can I handle this? All I want is to change the order of the placeholders like in this example phOneToMove.
can change the order in dropdownlist
DateTime NextMont = month.AddMonths(i);
I've a webpage, which has a panel which contains three panels. What I would like to know, if there is a way to change the panel order..
[Code]....
And depending on some server variable reorder the panels.. And also, let the user drag and drop the panel in the desired position
I have an ASP.NET website application, and there is a home page for my web site. I need to be able to change the default document of my website programmatically (C#) so that I can make another web page take priority above the one that already exists. I would then like to revert back to the previous default document order.
Example :
I have two home pages - Home1.aspx and Home2.aspx. In the IIS default document settings I have added the two pages and made Home1.aspx be the first default document then Home2.aspx the second. I need in some cases to be able to change the order of the two default documents so that Home2.aspx is the first default document then Home1.aspx the second.
How can I do that from my C# code?
I'm trying to use images representing arrows to allow the user to change the order in which items appear in a list in a grid view in ASP.NET.
I have a class which has a value named "position", the class is displayed inside the GridView and is ordered by position. In each of the rows of the gridview are an up and down arrow which i want to change the value of "position" for the object represent by the row of the gridview. Whats the easiest way to do this?
[Code]....