One of my table columns is for date and I understand how to use the ORDER BY statement in general. But how would I have the gridview sort with only the future items (relative to the current date) apear and leave out the past entries?
View 10 Replies
i get this data from history table for a paricular ConsignmentNo.
................
i want the sql statement. 1st condition is sql statement should be order by CurrentStatusDate.
.......................
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
Order Table
Order No Date Product Qty Customer
A101 10-Oct-2010 Mac Book 10 John
A102 10-Oct-2010 I-Phone 25 Smith
A103 10-Oct-2010 I-Pad 40 Kallis
Here Order No is primary key
Order Detail Table
Order No Date Product Qty Customer Batch No
A101 10-Oct-2010 Mac Book 03 John B01
A102 10-Oct-2010 I-Phone 05 Smith B02
A103 10-Oct-2010 I-Pad 10 Kallis B03
A101 10-Oct-2010 Mac Book 02 John B04
A102 10-Oct-2010 I-Phone 07 Smith B05
A103 10-Oct-2010 I-Pad 15 Kallis B06
Here Batch No is primary key
The above table is just a sample table.
I have more than 1000 Order in my table. And for each Order there are at least 12 Order Detail is available in my Order Detail Table. It uses to take long time on loading the report for the first time. So, I thought to select Top 20 records from Order table. I have used the below query in crystal report command
Select Top 20 O.OrderNo, O.Product, O.Date, O.Qty,OD.Unit,OD.Rate from Order O
inner join Order Detail OD on O.OrderNo = OD.OrderNo
1. After execution of above query, I would like to know whether all the records from Order Detail Table will be checked during execution (OR) only matching Top 20 records of Order Table will be checked in Order Detail Table and executed?
2. How to use stored procedure in Crystal Report command?
3. What are the steps I need to take, to load Crystal report fast during first time page load?
The code below returns a dataset that I use in a Gridview. How can I modify my select statement to format the DateEntered as a Date in gridview with no time and TimeEntered as Time in gridview without date info?
[Code]....
I have a formview, selecting * from friends, where [date] = getdate()
The problem is the friends table date columns datatype is datetime, i cannot make it just date.
I only want to display data if the date is the actual date, i.e. between 00:00:01 and 23:59:59
How do i select only the date for both getdate and my date column?
SelectCommand="SELECT * FROM [friends] WHERE ([date] = getDate())">
I was wondering in which order MSSQL executes a command. Say if I have this statement:
select top 1 * from table1 t1
inner join table2 t2 on t2.productid = t1.id
order by t1.buydate desc
what is done first:
- find if there's a matching record in t2 through the join
OR
- sort the results in t1 based on the buydate?
And when I have a large database with many records in both t1 and t2, what are possible performance issues I might hit?
I am having a DOB field in database of type Datetime.I am retrieving this into a gridview .I want to display only date into the gridview in 'DD-MM-YYYY' format and that to in sorting order. How can I do that. I know that by converting DOB to varchar and using SQL Date formats codes(103,105...) I can do that but I can't able to display in sorted order as it will check only the date part and sort the dates. It will not chk the month & year. And I also want the user to insert the date in 'DD-MM-YYYY' format and this to be stored in database. How can I do this? Pls respond me ASAP.
View 6 RepliesI have two table Order and Order Detail.
What i need is i need to bind last 10 Order in Gridview/details view with paging, and the same order detail also fetch from database and shown in another gridview.. if user click any oderNo in first Gridview/DetailView then i need to show Respective order detail in anther gridview..
without postback coz we already fetch 10 order with orderdetails from the database..and if user click next 10 orderNo using paging then again we need to load 10 orderNo with respective orderdeatils from database like this going on....as well as let me know how to take print of particular oder and order detail....?
I'm looking for the best way (Performance) to do gridview columns formating RunTime /Dynamic depending on the datatable Columns type ,I want to bind the datatable to a gridview and format the Date columns to short date, and currency columns formatted with comma ex 10,000.00 inplace 100000.00 at datatable the column type is double run time (without converting them to String) since I do a filtering and sorting at these columns.
View 3 RepliesHow can I change gridview templatecolumn order dynamically?
View 4 RepliesAfter I complete an order and return to my products area my shopping cart still shows the items that were ordered. I have checked the database and the items are not there anymore. somehow my code is remembering the data.
View 3 RepliesI want that all my others GridViews be like this (the only thing that change is the data content):
dont forget that this has already some behaviours because of the pagination for example that i want to maintain in all others GridViews.
How to change GridView columns order or index during runtime.
View 2 RepliesIn gridview boundedField, some Departments are listed like:
CIT
Customer Change Mind
Customer Issues
Logistics
Regional Engineering
Regional Sales
Can I change the order like:
Regional Sales
Regional Engineering
CIT
Logistics
Customer Issues
Customer Change Mind
I mean to say the list will not be on Asc or Desc. May I change order as per my own list order?
What I have is a command column with 2 link buttons, Review and Update. The Review link will show a more in depth look at the record (pretty much a detailsview) The Update link will allow the user to edit a few select fields. The Update link works fine, because I put the code in the GridView3_SelectedIndexChanged event. When I click the Review link (which has code in the LinkButton1_Click event), there is no data from the Selected row, because the row is not yet selected. Is there a way to trigger the selection BEFORE the button click event? It seems like this should be easy, but I haven't needed to do this before.
View 3 RepliesIn Gridview, Item Template i want to display Dropdown containing Order Status. On Dropdown selection I want to update Status corresponding to that Order. I just want to know how can I get OrderID value(which I had stored in Label in Item Template), in dropdown onselectedindex event. Grid view can't have Edit button.
View 3 RepliesI have a DropDownList inside the EditTemplateItem (if the user clicks edit) in a GridView.The DropDownList receives all available rows from the database. My problem is,if the user clicks Edit in the GridView to edit a row and opens the DropDownList Box the original item is not selected but the first one.That means the items are sorted. Have someone an idea how I can solve this issue that the right item / the original is selected if I change to edit mode of the grid view?
View 2 RepliesI have a stored proc which returns months year in nice words, but having problem ordering them:
SELECT count(id) as counter, datename(MONTH, PublishDate) + ' ' + datename(YEAR, PublishDate) as date
from BLG_BlogPost where active=1 group by datename(MONTH, PublishDate) + ' ' + datename(YEAR, PublishDate)
And that returns:
April 2009 (8)
August 2009 (3)
February 2009 (2)
How can i order them?
My sql statement is not functioning correctly. The gridview does post the items correctly but the results are not correct. Can someone assist me with the sql statement where I'm going wrong with it?
I only have one being reffer to the code because I was testing to see it work. Eventually, the search will be base on multi select and the selected items are going to the stored procedure to search for the proper records.
The following is the site code and sql code. -carlos
Site behind code:
[Code]....
[Code]....
I have walked through other posts with a similar problem but I am very stuck.I am normally use Php/MySQL and am new to ASP (actually only this new client uses it and I'm trying to help them). I am trying to filter a table to only show the last 90 days of records. I found what I thought was the easy solution shown below:
FilterExpression="columnname < GETDATE() - 90"
Or, if you can modify your SQL SELECT statement
SELECT col1, col2, col3 FROM tablename WHERE col3 < GETDATE() -90
However when I added it I get this error:Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: Type 'System.Web.UI.WebControls.BoundField' does not have a public property named 'FilterExpression'.I think I have added the code to the wrong place or have another file to edit but I have no clue honestly. The best I can do is show you the file I have the code to in hopes someone may know what this is. Here is the code from the file I added the solution to (my edit is bold/italics/underlined towards the bottom): And shouldn't I have some select statements somewhere like I normally do with MySQL?
<%@ Page Language="C#" MasterPageFile="~/SecureRck.master" AutoEventWireup="true"
Codebehind="Default.aspx.cs" Inherits="SecureRckWeb.Reps.Default" Title="Reps" %>
<%@ Register Assembly="schedule2" Namespace="rw" TagPrefix="cc1" %>
[code]...
I have parent gridview5 and nested child gridview6 within it. The page is working as expected and formatted as i need it now.. I added a select button to the child gridview6 and when i click on it i get an error: {"Object reference not set to an instance of an object."}
I found examples of using the find control, but within the parent gridview.. and i use that fine with other controls.. but cant figure out the right combination of finding the selected row for the nested gridview so that i can display a modalpopup.
I'm quite new to asp.net. I use MS Visual Studio 2008 and MySQL database. When I try to edit a record via gridview and the generated UPDATE syntax I get an error.I inserted a gridview into my asp.net web application and connected it to my database (all is OK). Then I checked for auto generation of update and other syntax:
[Code]....
When I test in a browser I get a pop window form for editing a record. But when I click "update" I get the following error:"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, strSkrajsanNaziv = ?, strKraj = ?, strDavcnaSt = ?, SkupinaID = ? WHERE Stran' at line 1"what's wrong with the UPDATE syntax? Is this syntax only valid when using MSSQL?
I have a conditional Eval statement in a Gridview that returns a boolean result to display an image if two datafields(strings) are identical:
Visible='<%# Eval("customerA").Equals(Eval("customerB")) %>'
Works great except I don't want the image to display if both datafields are empty. How can I add that logic into this Eval stmt?
On Page1 of a project, I have a Gridview showing a table of customer names (showing CustID, CustName, CustJoinDate). When I click on a record, I have passed a querystring to Page2 showing an address table for that customer. This part works for me.
The SQL statement in simply: Select * from CustAddress where CustID = @cust
What I would like to do though, is capture that @cust to a session variable so that I can use it later on.
