I have perform indexing on date column in many of my sql tables. My question while applying indexing date we have sort option as well to perform the indexing in descending or ascending order.
While index the date column sort should be asc or desc.
If I sort desc will it increase performance because 98 percent time user is retrieving current data.
In gridview columns im displaying date and time, as below.
23/02/2010 11:19:52
Im also doing sorting on these columns.
But the issue is during sorting its only sorting on "day (dd)"....
for example....these 3 values are from column, Date.
23/02/2010 11:19:52
18/02/2010 10:25:10
17/03/2010 09:30:51
when I click for "Ascending" sort....it should get "17/03/2010 09:30:51" on the top (because of month 03) others have 02, but it doesnt, it gets in the above order, its just sort on day (dd).Below is my code for boundfield....
<asp:BoundField
DataField="Date"
HeaderText="Date" [code]...
can I add a column to gridview that will convert the utc date to my local time? HOw?
View 2 RepliesI m working with VS-2005 without ajax functionality(With out Update Panel). I have a gridview which has a two colmn inside first column there is image. When user clicks on the image a pop up form with calender control should open when user selects the date from calender that date should get sets up in second column
View 4 RepliesI have a column with nvarchar datatype storing the date. I am using a Gridview to display and edit data of that table. Now when I update the table the nvarchar column containing date in the format mm/dd/yyyy gets converted to Jun 9 2010 12:00AM format. I don't want this to be happening. I don't understand why this is happening as I don't have datetime column.
View 4 RepliesHow should i insert null values into a database. I have textbox1 and the textbox2 will convert the value out of textbox1, when i the time i click save and the textbox1 is empty i got an error, "Conversion from string "" to type 'Date' is not valid." i just want to insert null value if the textbox is empty.
View 1 RepliesI've managed to render TreeView using custom made Hierarchical Datasource based on Linq queries on self referencing table. Rendered output looks well but... Every Node in NodeCollection has the same index = 0. Therefore when I click on any collapse button - the whole tree Collapses. In generated html every node has the same id = MainContent_TreeView1n0 I suppose n0 should increment to n1 n2 n3 and so on.
View 5 RepliesMy question is related to this post:
http://forums.asp.net/p/1016715/3297261.aspx
When ever I click on the paging it does a postback but does not move the page to the secong page.
[Code]....
How to handle page indexing , editing and cancelling events in asp.net?
View 2 Repliesi am using C# and VS 2008. how can i compare my datagrid column with current system date/time with current system date.
let us say current value in Date1 column is: Tuesday, February 16, 2010
foreach (GridViewRow r in GridView1.Rows)
I want to find the sum of sales column from the table. Like today is 16-01-2014, i want the sum of sales column of 7 days back i.e. till 09-01-2014. I cannot put static dates as everyday date will change and every day i want that query to automatically see 7 days back records.
View 1 RepliesI have a datagrid with two columns ( File Name, and Date Created ). I want them to be sorted when clicked (ASC or DESC). I went into the design view and added the allow sorting feature and added the column names, so they are clickable in the header of the data grid. I also already added the onsortcommand as well.
My datagrid is named dgFileList and the onsortcommand method is named dgFileList_SortCommand.
The procedure that is already loading on page load is a DataSet. (where I think my problem is)I dont have anything in the back end beside the dgFileList_Sortcommand method. From what I have read, it seems like I can't use a DataSet to be sorted...I'm using visual studios 2005, C#, not VB.
I need to check for two differect text to make the Edit button inactive. For example, I need to make the button inactive when the ActionTypeName field has value either Accepted date or Received date. I can do one check with Accepted date but not both.
View 1 RepliesI want to check that a specific url is indexed in google using asp.net.Is google provide any api, webmethod anything regarding this.
View 2 RepliesI have a .aspx file with a datagrid in it:
<asp:DataGrid ID="Gifts"
AutoGenerateColumns="True"
runat="server" AllowSorting="True">
</asp:DataGrid>
The .aspx.vb file associated with it fills it in with a datagrid object.
Protected WithEvents Gifts As System.Web.UI.WebControls.DataGrid
Public GiftData As DataTable
Gifts.DataSource = New DataView(GiftData)
Gifts.DataBind()
That all works fine. However I want to format one of the columns with a particular date format. Is there a way of doing that in the vb code? I know I can do it in the .aspx by specifing AutoGenerateColumns="False" and then explicitly defining the columns, but I want to do it in the code as it's more future proof for my application.
I have implemented URL rewriting and I would like someone to answer if my new URLs will be indexed by google or not.
BACKGROUND:
I have many databound linkbutton which redirects to URL like: www.example.com/product.aspx?PLU=4985783028
What I intended to do is to make above URL look like www.example.com/MY-Nice-Product1-For-Sale-4985783028.xyz . Whuich internally should rewritten as above. I could have easily implemented such URL rewriting but all my databound link button redirects to
/product.aspx?PLU=4985783028 and when this the page at this URL is served to browser it will look like
/product.aspx?PLU=4985783028 and not /MY-Nice-Product1-For-Sale-4985783028.xyz
WHAT I DID:So I implemented my own method of Rewrite. Steps for which I did is as follows
1. I wrote code inside Global.asax in Application_BeginRequest event.
2. I checked for URL if its product.aspx or not (using fullOrigionalpath.Contains)
3. If its product.aspx I would takeout the "PLU" Query parameter and by string manipulation and then call a function to determine product name from the unique ID ("PLU").
4. And then I would redirect the page to "/productname-PLU.xyz" (e.g. here productname is
"MY-Nice-Product1-For-Sale" . AND PLU is "4985783028" so that is redirects to "/MY-Nice-Product1-For-Sale-4985783028.xyz")
5. Once redirected, again, "Application_BeginRequest" event will be called. and there I would check if URL contains. ".xyz" extension.
6. If so, I would takeout PLU by string manipulation and then rewrite URL to right URL which looks like
"/product.aspx?PLU=4985783028"
7. Then after user will see "/MY-Nice-Product1-For-Sale-4985783028.xyz"
on their browser addressbar
This is how I achieved my goal so that all old URL redirects works too and all new URL works too and in both case user will see new URL.
Following is the code
[Code]....
So finally the question is "Will my new URL be indexed by Gooogle?" because the basic intention of doing this was to help with SEO .
i dont know why this happens and when happens......i have one employee table that contain date field and that field contain two different values one is -'2008-10-01 00:00:00.000' and second is '2008-10-01 12:00:00.000'.can anyone explain when this type of value insert in database.
View 2 RepliesI've got a datagrid which i wanted to sort, since i dnt have much knowledge of .Net, so what i did was to save that datagrid in a DataTable, then again save the same DataTable in a DataView, then apply sorting on that DataView. this is the code, and its working fine.
Code:
protected void dgEOBSearchResults_SortCommand(object source, DataGridSortCommandEventArgs e)
{
DataTable dtEOBDocumentListTable = (DataTable)Session["sEOBDataTable"];
if (ViewState["sortExpression"] == null)
[code]...
but the issue comes when the i try to sort the Date Column, the dates are in MM/DD/YYYY format, so if i try to sort the date column, the dates are sorted on month basis, rather than year basis. now i cant change the date format, is there any way to sort dates in DataView?
Is there a way to prevent search engines from indexing a site by modifying the ASP.NET Web.config file?
View 2 RepliesDeveloping a web site in .Net 4. Very close to being complete with most functionality, so I thought I would attack what seemed to be a tough one (something I have not done): site content search.
I've been digging around for an hour or so, and I'm a little perplexed. How do I perform content search on an ASP.net website?
A few things I'll throw out there before you answer with something I've already seen and cannot implement:
I am developing on a Win7x64 computer using VS2010 w/TFS.Site has been converted to .net 4, and is in C#.Will not have access to put site on Windows Server 2008 for another month, but would really like to implement search if at all possible beforehand.All that said, can I implement searching via indexing? I've looked at using Windows Search, but nothing looked like it worked right. This site will be served up on a Windows Web Server 2008. Do I need to somehow develop against a Server 2008 to implement search via indexing?
I am having a little trouble with an 'IndexOutOfRangeException'. I think it is because when the code tries to get the DateModified col from the database it sometimes contains NULLS (the users haven't always updated the page since they created it).
Here is my code;
s = ("select datemodified, maintainedby, email, hitcount from updates where id = @footid")
Dim x As New SqlCommand(s, c)
x.Parameters.Add("@footid", SqlDbType.Int)
x.Parameters("@footid").Value = footid
c.Open()
Dim r As SqlDataReader = x.ExecuteReader
While r.Read
If r.HasRows Then
datemodified = (r("DateModified"))
maintainedby = (r("maintainedby"))
= (r("email"))
hitcount = (r("hitcount"))
End If
End While
c.Close()
I thought (after a bit of msdn) that adding;
If r.HasRows Then
End If
after adding I am still getting the same old IndexOutOfRangeException
(ps, I have tried datemodified as string / datetime)
my webpage perform content search using Windows Indexing Servicemy production machine is Windows XP everything finethen i tested my published Website in Windoes 7the Summary Fields always empty
View 1 RepliesI have a Timestamp column in my Table. I want to read the date time value and display in UI.
In Linq the Timestamp column is represented as System.Data.Linq.Binary.
I dont know how to retirve date time value in "MM-dd-YYYY" format from this Linq.Binary
- Why I am using Timestamp?.
I want to perform some operations based on the last modified date time of the particular row. Since I am using TimeStamp column in my Table as version column, It will contain the last modified date details, So i want to read the date time value from this time stamp column to do some other operations.
look this code:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string sql = "select date from news_events";[code]....
Which Get method should i use to retrieve date from the column to dropdown list"ddl_month". Is above method correct or suggest me another one below is the error associated with above code..
Error Argument '1': cannot convert from 'System.DateTime' to 'string'
what type of files can we search using Microsoft Indexing Service
View 3 Replies