The value of mm is the same as the value of nn. You are cutting the time part which is the most important here. You should check dates between this interval [15.12.2009 00:00:00.001 - 15.12.2009 23:59:59.998] (and change the format in desired culture) I didn't notice that this question is re-posted! Man this is kind a rude! You've already got a good answer, so why re-post ?!

Only to the appropriate user :) In general I am agreed with you, but user not allays means dumb person. User of this admin module can be a developer(responsible for the maintenance of the system ) or a trained consultant who knows what he is doing.

Yap, this is true, but if you are building an administrative module you should grant this kind of rights to the admin of the application.

Do you know how to use google? I tried with - "kill connections sql server" and all of the top 10 results had the answer.

You should know that the sql command is executed on the computer where the MS SQL server is installed. This means that "C:\output_file.csv" is server's C drive. You may have no access to it! The second problem is the query itself. I think that this query is only available for MySQL user. A better approach will be to get the data from the server into a DataSet (on client side) and write a simple method to convert the data to scv file. I am quite sure that an article explaining how to do this exists in CP's articles.

Yap, you can do it this way

public static void SuperCoolMethod(params int[] list)
{
// code here
}

...

SuperCoolMethod(1,2,3,4,5);

I think you are making your life miserable. Sacha Barber has a great article about the screen savers WPF : A 3D screensaver written in WPF[^] You can check and Jacob Jordan's article Making a C# screensaver[^]

Try this tbUserName.Text = gvUsers.SelectedCells[0].Value.ToString();

Strahil Shorgov

you heard something called CellClick even. Then just get the value of selected cell and giv it to the Text property of your control(Label, TextBox ...) And don't ask your question twice!!!

Strahil Shorgov

check your stored procedures!

Strahil Shorgov

I always install the necessary software into the OS drive. There is no problem to use different drive My current(home) HDD is 250GB 50gb - XP and software 100GB - Starage Drive (folders for Projects, Music, Pictures) 100GB - Internet Downloads and Installation files(*.iso) for software (I hate CDs)

Strahil Shorgov

My choice will be: 2 * 30gb for operating systems + software installations 10GB for Backups 10GB for Internet Downloads (samples, eBooks, ...) 40GB for Projects(my projects), Music, Pictures and Movies - a.k.a Storage Drve

Strahil Shorgov

try different approach. Use this code in some button click event handler FileStream fs = null; string strContentType = "application/octet-stream"; string strPath = Server.MapPath("FILE_LOCATION_HERE") + "\\"; String strFileName = "FILE_NAME_HERE"; if (File.Exists(strPath + strFileName)) { byte[] bytBytes = new byte[fs.Length]; fs = File.Open(strPath + strFileName, FileMode.Open); fs.Read(bytBytes, 0, (int)fs.Length); fs.Close(); Response.AddHeader("Content-disposition", "attachment; filename=" + strFileName); Response.ContentType = strContentType; Response.BinaryWrite(bytBytes); Response.End(); }

Strahil Shorgov

try http://www.devexpress.com/Products/NET/WinForms/XtraReports/[^]

Strahil Shorgov

Pearl Jam, Puddle Of Mudd, 3 Doors Down and my favorite Creed and Scott Stapp

Strahil Shorgov

oh yeah Sorry friends. You have only one weekend, but I have 9 days holiday ;P. So I will go to my home town to visit my family and my friend. Far away from computers only clean air, sleeping and resting . Almost to forget - and large amount of beer :laugh:

Strahil Shorgov

I don't really mean to KILL her ! You will forget your feelings. Believe me ! 3 months is a short period to LOVE someone! Sometimes the things don't happens your way. Forget her and find someone that loves you. Sometimes you think that your in love but the real love is somewhere else. And don't smoke because X| X| X| and your friends will :((:((:((:((:(( http://www.cartoonstock.com/newscartoons/cartoonists/gcu/lowres/gcun6l.jpg :laugh:

Strahil Shorgov

Kill that girl! She don't deserve you ! And don't thing about smoking again! I quit smoking before 6 years and I feel Great and Strong and I code better ;P Be strong !!!

Strahil Shorgov

You can see the future, but I can see the past :zzz: The things you'r talking about already happened in the past :wtf: - I was there end I saw everithing except the dark era ;P that's the programming answer while(Galaxy.RepeatEra()) { People.LiveAndDie_OrGoCrazzy(); } :laugh::laugh::laugh:

Strahil Shorgov

Poor old man! :laugh: And remember don't "drink and code" ;P it's DANGEROUS Happy B-day!

Strahil Shorgov