ASP.NET

Microsoft Access Team Blog: Writing a Count(Distinct) Query in Access[^]

13-Nov-07 20:57

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."

Re: how to use Distinct count in ms access

Piyush Vardhan Singh13-Nov-07 21:21

Piyush Vardhan Singh

13-Nov-07 21:21

it show all starttime count. its not show according different starttime count

Piyush Vardhan Singh

Re: how to use Distinct count in ms access

Vasudevan Deepak Kumar13-Nov-07 21:38

http://en.allexperts.com/q/Using-MS-Access-1440/Selecting-Distinct-Records-MS.htm[^]

13-Nov-07 21:38

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
Regional Weblog (in Tamil) :: Voicing for the Society

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

how i can stop java script function not to excute

jagan12313-Nov-07 20:21

jagan123

13-Nov-07 20:21

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

Re: how i can stop java script function not to excute

Vasudevan Deepak Kumar13-Nov-07 21:27

Looking different in Mozilla

13-Nov-07 21:27

jagadeeshkumar2106 wrote:
but in one situation

Can you code a return off condition in that function?

.NET- India 13-Nov-07 20:01

.NET- India

13-Nov-07 20:01

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

N a v a n e e t h13-Nov-07 20:09

13-Nov-07 20:09

Start firebug to find out the errors. It shows 17errors to me.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

.NET- India 13-Nov-07 20:12

.NET- India

13-Nov-07 20:12

means.................. make it clear plz

N a v a n e e t h13-Nov-07 20:17

13-Nov-07 20:17

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.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Vasudevan Deepak Kumar13-Nov-07 21:39

13-Nov-07 21:39

Even this is good:

http://www.mozilla.org/projects/venkman/[^]

Michael Sync13-Nov-07 20:17

13-Nov-07 20:17

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..

N a v a n e e t h13-Nov-07 20:24

13-Nov-07 20:24

Michael Sync wrote:
I have the series of Firebug tutorials for beginners. you may check-out..

Great one

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Michael Sync13-Nov-07 20:37

13-Nov-07 20:37

Thanks, man.. Big Grin | :-D

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..

N a v a n e e t h13-Nov-07 21:42

13-Nov-07 21:42

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

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Christian Graus13-Nov-07 20:20

Christian Graus

13-Nov-07 20:20

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 )

N a v a n e e t h13-Nov-07 20:23

paging & sorting in gridview

13-Nov-07 20:23

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.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Jintal Patel13-Nov-07 19:58

Jintal Patel

13-Nov-07 19:58

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

Re: paging & sorting in gridview

Christian Graus13-Nov-07 20:01

Christian Graus

13-Nov-07 20:01

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.

creating multilingual website

Ravi_2113-Nov-07 19:33

Ravi_21

13-Nov-07 19:33

can any one help me to create multilingual website its urgent

Michael Sync13-Nov-07 19:47

13-Nov-07 19:47

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...

N a v a n e e t h13-Nov-07 19:54

13-Nov-07 19:54

Keep all the text in resource file and it will be loaded automatically depends upon the browsers language settings.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Vasudevan Deepak Kumar13-Nov-07 21:31

13-Nov-07 21:31

Ravi_21 wrote:
its urgent

Avoid such words. They are considered rude here.