Basically I have a table as follows:
Page Title ¦ DateTime
Home ¦ 20/09/2010 17:25:01
Home ¦ 20/09/2010 16:01:16
Home ¦ 20/09/2010 17:24:01
About Us ¦ 06/09/2010 17:27:01
Home ¦ 03/09/2010 14:25:01
SiteMap ¦ 21/09/2010 17:21:01
I want to get the unique page title but latest date, therefore query result would be:
SiteMap
Home
About Us
I got a datarow[], that will further filter a datatable.
From the datarows, result, how can I add in the function to order the value and group the values?
[Code]....
I need to sort the gridview values when I click in the title of each colum.
View 2 RepliesI have a gridview with some columns and I need to sort the gridview by a date-column. But it doesn't sort it correctly. This is the code I use:
dt.DefaultView.Sort = "Meldingsdatum asc";
gvOutlookMeldingen.DataSource = dt;
gvOutlookMeldingen.DataBind();
Group Validation of Two DateTime Picker Using Javascript in asp.net
View 1 RepliesWe have a webservice which stores data in sql server 2008R2.I am trying to build a billing system and struggling with the next sql query.
scriberID,X.SubscriberName,X.ProductID,X.ProductDesc,X.NumOfTransactions,X.UnitPrice,SUM(X.NumOfTransactions
* X.UnitPrice)
AS ExtendedPrice
[code]...
When I click on my GridView header "End Time" all the rows which contain the string "N/A" disappear.
Here is my code:
[Code]....
Note: GetSortDirection returns "endTime ASC" or "endTime DESC" and save in ViewState:
[Code]....
Then I fill the DataAdapter and use the ViewState info to sort it:
[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?
Am building a Form for out intranet that runs on ASP.NET and C#, it is to be a survey from a SQL database. I have the connections setup can pull informations/Questions from the database. I am having a problem with setting up radio buttons within a datalist, ive never done this and i know they require unque names.
It is to be 4 radio buttons per question where only one can be select, i know how to group just not via a datalist with unique names
I am trying to store a SQL Server datetime into MySQL datetime field, but MySQL stores the date value as all zeros. I use this function to trim the fractional part from the SQL Server datetime, but get the same result when trying to store it in MySQL.
[Code]....
I am trying to get data from mysql database and store in sqlserver database. i am getting the following error
The given value of type MySqlDateTime from the data source cannot be converted to type datetime of the specified target column.
How to get Unique ID of LDAP logged in User? Is GUID is the unique id of each user?
View 1 RepliesMy master page looks like:
<head runat="server">
<title>
<asp:ContentPlaceHolder ID="PageTitlePlaceHolder" runat="server" />
</title>
Content pages look like:
<asp:Content ID="TitleContent1"
ContentPlaceHolderID="PageTitlePlaceHolder" runat="Server">
My Page
</asp:Content>
This works by placing the content page specific title on the page ("My Page" in this example). Now I want to add a global prefix to the title in my master page for the site name. So I want:
<head runat="server">
<title>
Example.com:
<asp:ContentPlaceHolder ID="PageTitlePlaceHolder" runat="server" />
</title>
However, when I do this content pages are still rendered without "Example.com" in the tile, it's like it's ignored.
Why is this happening and how can I achieve this?
I have the following:
[code]....
I keep getting this error:
Message = "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."
What i'm trying to do is group by ContentObjectId and then get StartDate that is greater than today.
I'm using entity framwork and MS SQL2008
Is GUID (globally unique identifier) really unique, or it can be duplicate.
System.Guid.NewGuid().ToString()
How generate the unique no. 1,2,3 and so on .... on button click of each new user ..
the code mentioned below is a readwrite coding in vb.net ...
but the problem is it generate the same id for different users on button click event... but i want the no. of times button clicked the new ids will be generated
[code]....
I have a below Page title in my master page
<title>My Test Application Name®</title>
It renders Fine with Register symbol after the text "My Test Application Name" on start of the page but on any postback the title turn into My Test Application Name® Kindly let me know what can i do with minimal effort to fix this issue
Every time I create a new aspx page and add some new photos and text, after I finish, I have to update page title, Web.sitemap, Sitemap.xml to feed search engines, static sitemap.aspx page, add photos to proper folders, update database to display feeds etc, and I have to remember to upload all new files including links to any new pdfs....This routine eats my time and drives me crazy.
I was wondering if there is such interface, where you need to create only 1 aspx page, for example "Articles" which can populate Texts, photos etc into pre-defined sections, but at the same time it displays with different URL's, so there is a permanent link to it. After you finish it creates a title automatically, based on article title, populates Web.sitemap - does all the dirty work. Similar to how blog engines, Joomla and Drupal work.
I have a controller's action and view page that uses a master page.
The master page has the html title section like:
<title>this is the page's title</html>
How can I access this section from within my controller's action (preferably) or my action's view page?
How to Display Icon IN title bar of Browser with title?
View 7 RepliesIn my application I have the following message:Object reference not set to an instance of an object.
@Html.DropDownList("Title",ViewData["PersonTitle"] as SelectList, Model.Person.Title)
The dropdownlist contains simple strings (person titles). When you select a title, that title should be returned to my model. Controller code:
ViewData["PersonTitle"] = new SelectList(new[] { "Dhr.", "Mevr." });
Why is this not working ? Edit: The purpose is to change
@Html.EditorFor(model => model.Person.Title)
into something like this
@Html.DropDownList("Title",ViewData["PersonTitle"] as SelectList, Model.Person.Title)
How can I get unique session ID for every unique user who logs in ?? I'm using asp.net/c#
View 1 RepliesHow To Display Data In Following Format?
In the Format below abc has multiple occurance which count is displayed in brackets as 2669.
[code]....
I need to store click to my website to a database, I have a sql2005 table :ID, CLICk, PAGETITLE, DATE.
i insert the click and date but i cant get the page title.
The code that inserts data is in masterpage.master.
i need to finde the current page where the clickocured than take the title
I have a simple dynamic gridview with following code -
GV = new GridView();