|
try to use this one can solve ur problem.
SELECT Format([StartDateTime], "dd mm yyyy") as StartDate, Format([StartDateTime], "dddd") as Day,
Count(*) as ChatCount
FROM Messages where 1=1 group by Format([StartDateTime], "dd mm yyyy")
Devjit Das.
|
|
|
|
|
Eval is just syntactic sugar, it's just a shortcut that does the same thing. I got the impression you were trying to do a <%# block in your code behind, you can't - that block is to tell the aspx that it's code, you're already in the code behind and don't need it.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I guess you are doing this in code behind. It's not possible to do this on code behind. You can use the GridViewRowEventArgs object e, and access the cell value instead.
|
|
|
|
|
how to use Distinct in ms access
i want to count distinct starttime from table
Piyush Vardhan Singh
|
|
|
|
|
Microsoft Access Team Blog: Writing a Count(Distinct) Query in Access[^]
SELECT Count(*) AS N<br />
FROM<br />
(SELECT DISTINCT starttime FROM yourtable) AS T;
i haven't tested it yet but i hope it gonna work..
btw, This form is for ASP.NET question only.. Please don't post the question related to database here. Thank you.
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
it show all starttime count. its not show according different starttime count
Piyush Vardhan Singh
|
|
|
|
|
|
iam having one text box when i enter some value in the textbox and press enter key then iam calling java script through asp.net to excute.but in one situation this java script funtction not to execute ...means it should stop and another script has to execute how it is possible
|
|
|
|
|
jagadeeshkumar2106 wrote: but in one situation
Can you code a return off condition in that function?
|
|
|
|
|
Hello Friends,
I've created a simple menu in which images get changed onmouseover..... it's working great in Internet Explorer but looking ugly in Mozilla..........
Here i'm giving the URL ......
http://www.saamstesting.com/Rough_New.aspx
|
|
|
|
|
Start firebug to find out the errors. It shows 17errors to me.
|
|
|
|
|
means.................. make it clear plz
|
|
|
|
|
FireBug[^] is an add-on for mozilla firefox. It will show the errors in the page, it's very easy to debug javascript and CSS.
|
|
|
|
|
|
I tried to access your page. I got the error in IE6... As N a v a n e e t h suggested, you should try to use "Firebug", Firefox extension to find out the error..
You can get the Firbug from this link.. If you need the tutorials for using Firebug, I have the series of Firebug tutorials for beginners. you may check-out..
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
Michael Sync wrote: I have the series of Firebug tutorials for beginners. you may check-out..
Great one
|
|
|
|
|
Thanks, man.. 
u know, i think my writing is suck.. Only this post was featured as a popular post in del.icoi.us... I think people don't like other posts of this series even I used the same effort for all of my posts.. I should read some writing books or attend some classes..
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
Michael Sync wrote: u know, i think my writing is suck.
Maybe your first language won't be english. I too have the same problem. But I found some good posts in Scott Mitchels blog which explains how a technical article can be written. Marc clifton also has a good article here in CP
|
|
|
|
|
Different browsers have different HTML/CSS/script engines. It can be a challenge to write code that looks good in them all.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Christian Graus wrote: It can be a challenge to write code that looks good in them all.
I don't feel much difficulty till now by using W3C standards and not any proprietary methods. Alternatively I used to change the CSS/JS, by checking the browser version.
|
|
|
|
|
hi
how to implement paging & sorting in gridview...both r working but if my page size is 20 and records r 60 then the sorting done on 60 records insted of 20 record of current page...
i have tried like this
public DataSet GetDatasetForPage(DataSet dsGlobal, int pageindex, int pagesize)
{
string Query = "Select * From tb where Deleted!=1";
SqlConnection myConnection = dbAccess.SQLConn;
dsGlobal.Tables[0].
SqlDataAdapter dapter = new SqlDataAdapter(Query,myConnection);
dapter.Fill(dsGlobal, pageindex, pagesize, "tb");
return (dsGlobal);
}
but i don't want to execute select statement each and every time...
Jintal Patel
|
|
|
|
|
The alternative to doing the select every time is having all your records, unpaged, in viewstate. That is a nightmare, you don't want that.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
can any one help me to create multilingual website its urgent
|
|
|
|
|
You can search in Google.
asp.net localization [^]
Ravi_21 wrote: its urgent
If it's urgent, you may consider hiring the ASP.NET freelance developer...
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
Keep all the text in resource file and it will be loaded automatically depends upon the browsers language settings.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
