Comments by sacraj (Top 52 by date)

I would like to get the portid's which are same. for example
id portid Daynumber
1 334 1
1 335 2
1 337 3
1 334 4

in this above sample the portid is same for the day number 1 and 4 so I need to get the port ids which has same port ids for the first and last day.

I have a Html button like this <button type="button" runat="server" id="btnTop" causesvalidation="false" önserverclick="btnTop_Click"/>. This button fires an server side event. I need to set commandArgument to this button. and get the value in the server side. How to do this?

I have replaced $(window) with $("#FooterDiv"). But it is not working for me.

Yes the above code works fine. But I need to call $(window).scroll(function () when the user scrolls down after my body area or body div. When the user scrolls down the page to Footer div The window.scroll function should be called. But this function is getting called when the user scrolls down the page till the end.

thanks for the solution

thanks for the work

If I use stored procedure. For each record the database connection is made, Would not there be any problem If we have lacks of records..

Yes, I had the problem with proxy of my server. Thanks for your help.

hi,
I am able to download .jpg,.gif and other types but not able to download .Zip file, When I download .zip I get the following error," The remote server returned an error: (502) Bad Gateway."

wc what is this, it gives me an error

the type or namespace name 'PeriodicalFile' could not be found

I am able to download .txt file, but not able to download .zip file from FTP Server.

What is the Visual studio version that you are using. I am using Visual studio 2010. Do I need to give any reference. When I paste the above code code compile time error.

I am unable to convert this

string sDate = "Wed Nov 10 14:13:10 IST 2010";
DateTime dDate = Convert.ToDateTime(sDate);

When I run this above code I get an Exception saying that"
String was not recognized as a valid DateTime."

How can I convert this string into date Time Format.

How can we use cell formatting in the data table using Microsoft.Office.Interop.Excel namespace. with this code
protected void ExportToExcel() {
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=MyFiles.xls");
Response.Charset = "";
this.EnableViewState = false;

System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);

gvFiles.RenderControl(htw);

Response.Write(sw.ToString());
Response.End();
}

I have solved this problem by myself. through select stuff()and FOR XML PATH.

The image is not on the same page. The image is in different page.For example on profile page it is 50*50, in home page it is 30*30. User would upload only one photo. the code should be able to generate the different size.

Msg 1033, Level 15, State 1, Line 4
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.

I wan to change the query ,how to change the query

I understand the difference between ++i and i++. How can we implement this in Paraller.For loop

I know the difference between ++i and i++. How to do this in Parallel.For

Please explain ++i vs i++ in Paraller.For. I am in urgent need

It is very urgent requirement. Not related to performance

please convert this to Parallel.For

What you have said is correct. But I would like to get a message as soon as the software is installed or uninstalled how to do that ...

How to add file properties If you can give me some steps to do this....

sid admno
1 s1
2 s2
3 s3

how to select studentid with group concat where admno in(s1,s2,s3)

the expected output is 1,2,3
help me with mysql query

When I run this query Select RIGHT(Convert(DateTime, getdate(), 0),7)

I get 5:01PM but I need time like this 05:01:00 PM

I would like to get date in 12 hours format
not in 24 hours format the above query gives 24 hours

I would like to get date in 12 hours format
not in 24 hours format the above query gives 24 hours

I used select * from sample This table has got 5 columns
after this I executed the query "select * from count(*)" It gives an error
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '*'.
What is problem in my query Please correct.

How Can I get his e-mail Id. Could not find it in his profile.

I shall again check this code on my Computer. Can not I get the list of installed software which are not installed using MSI(Microsoft Installer).

I have also used WMI to query the installed software list. But It does not give all the installed software.

Thanks for your help
I think your answer is for files and folders I do not want to get last access date for files and folders. I need the last access date for installed software.

Thanks for Helping.
What you have said is correct but I does not show all the installed software list. For example It does not show for Microsoft word,power point, Excel. I need to get all the installed software with last access date.

Could You please make it clear with out "
because I do not understand

ASP.net web app

I accept your answer It works fine for Forms, If you do not mind could you give a solution for opening a database connection only once and use it through the application using singleton method. Th e data base SQL-Server.

If I have another system name as "system11"
I will get the answer as system1,system11
If I use contains but I need only system1

Thank U for U

It is nice of U

Thank you for the help that U have done It was very useful for .

Yes I agree with your point, I have been searching this for long days , I am not able to get the answer, If you know some IT guys Could you please help me to solve this problem. Thank you

I am running this code from Administrator Which means the system has all the permissions I hope so If I am wrong Please correct Me

Sorry this solution throws an Unauthorized exception. I even tried with Administrator user. But I could not get the answer. Please help me it is urgent.