Post your code. There are only 10 types of people in the world, those who understand binary and those who don't.

Please do not post the same question in more than one forum.

Use Google.

ven753 wrote: If i give continue it will show Parameter '@row_number' must be defined. There's an @-sign in there (declaring a user-variable), so .NET will assume you're declaring a parameter. There's no parameter in the collection with those names, hence the exception. Easiest way out is to create a stored procedure. Wrap your SQL in there, call the sproc from .NET. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

You can't without using an unsecure technology like ActiveX or Flash, or downloading an executable to the client side to run. It would represent a massive security hole if a website were able to get full access to the filesystem.

ven753 wrote: Columns property it will show. Only if you're referencing a DataGridView, and that's a different control. Either you switch to the DataGridView, or you adjust the requirement of needing the alignment. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

Hi, Try below : DECLARE @JoiningDate DATE SET @JoiningDate = '10/10/2013' IF (YEAR(GETDATE()) > YEAR(@JoiningDate)) BEGIN IF (DAY(@JoiningDate) = DAY(GETDATE()) AND DAY(@JoiningDate) = DAY(GETDATE())) BEGIN /* This will exceute on every year of joining date. Below is the print statement to check the testing result. */ PRINT CONVERT(NVARCHAR,(YEAR(GETDATE()) - YEAR(@JoiningDate))) + ' Year(s)' END END

Refer: how-to-schedule-the-start-and-stop-of-a-windows-service[^]

hello Please share us complete details i.e how you are displaying an images on site. as this is due to image object is not getting null after rendring images and it is till in use at server.

Make sure you're calling Dispose on the MailMessage instance after you've sent it. The simplest approach is to wrap it in a using block: using (MailMessage mail = new MailMessage()) { ... SmtpClient smtp = new SmtpClient(); smtp.Send(mail); } "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Where are the excel files hosted? It could be that the excel files are hosted in your local box and the links direct you to http://localhost. In this case, the files will open only when clicked from the local box. Check the links and fix them. You may need to move the excel files to a server and update the links with the server's address.

You can drive the save to MHT using automation. Basically, even though MHT isn't exposed via the save function in 2010 (not 2013 sadly) you can still get to it via VBA so you're going to have to do something like this: Public Sub ConvertToMHT(ByVal FileLocation As String) ActivePresentation.SaveAs FileLocation, ppSaveAsWebArchive End Sub

Try using a MemoryStream[^] to store the Excel file, and pass that stream to the Attachment constructor[^]. var ms = new MemoryStream(); using (var sw = new StreamWriter(ms)) { RenderExcelAttachment(sw); } var attachment = new Attachment(ms, "data.xlsx", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); message.Attachments.Add(attachment); "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

try Session.RemoveAll();

You'll have to make a network share to that location to use that code, or create a web service to get the list of image url's from the other box.

Technically session.removeAll works. Keep in mind that it's a server side call, and will erase all the session values on the web server. Now if the browser still honors the session value, or thinks that the session value is valid, then that's a browser issue, or something else on the server is keeping the session value alive. So you make a session in a test page, that contains a word or something, and click a button to remove all, and see if the session is erased., and play around with it. I know that in certain modes, the session value will write a cookie on the client, with the session values. Using Firefox to examine the cookie values is useful to confirm the removal of the session value. Chrome has alot of bugs in it, and became very bloated with code. It could just be a Chrome issue. That's out of your control, nothing you can do about it. [EDIT] Maybe it's the way you implemented the session, eg. Dim m_context as httpcontext = httpcontext.current m_context.session.add("Login", true) if (true = m_context.session("Login") then m_conetxt.response.redirect("admin.aspx") End if or perhaps the correct context was not used to create or remove the session, or the spelling of the session name does not exactly match. Don't forget to delete your browser cache for a true test.

ven753 wrote: What could be the problem. It could be the format of the date. Why is there a DATE-function on colmn1? Is it a varchar? Please don't crosspost. The question should not be in the .NET forum. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]