Comments by Prashant Bangaluru (Top 84 by date)

Hi Mika,

at 153: Send_Mail("Running of an emai query report has failed on " +DateTime.Now.ToString("ddd dd MMM yyyy HH:mm") );



Line 455: which is in send mail function: using (SmtpClient email_Client = new SmtpClient(Smtp_Server))
{
email_Client.Send(Email);
email_Client.Dispose();
Line : 455 attach.Dispose();
}

Hope this code snippet helps to help me

But all the querries are not taking time. Every query is running before 5 secs.

Hi Mika, I have updated the details now. Can you please check once.

Sorry the job runs monthly once .. I ran the profiles but ddnt find anything.. How can I share the profiler details here

Hi Ryan, Looks like these details are not logged neither in SQL log nor in EventViewer.
Do you have any idea how to get that?

Oh yeah.. Thanks for that.. I will verify the logs and update you.

Thanks for your comments. Is it because of query taking long time or any deadlocks?

Yeah sure .. I will do that.

I am really sorry .. I am confusing with my question.. The exact issue which I am facing is this http://stackoverflow.com/questions/3863012/server-word-automation-permissions-some-answers-and-some-questions

I am really sorry .. I am confusing with my question.. The exact issue which I am facing is this http://stackoverflow.com/questions/3863012/server-word-automation-permissions-some-answers-and-some-questions

Hi Praveen.. I need the code for creating a session in server if the session is missing. Do we have code for this ?

I am not saving the file in xml.. I am feeling that I have to do some encoding and decoding which I am missing.

Hello Sinisa, the second solution helped me to fix my issues.. THanks for your help..

I sinisa thanks for ur reply.. Looks like ur solution meets my requirement I will try and update you.

SOrry for the late reply ..I just updated the table structure actually they are 2 different coumns.

Thank you.. I understood..

Hi Los, We have to perform all the operations on a single table. I have edited my question . Thanks for your time

Hi Sri, We have to perform all the operations on a single table. I have edited my question . Thanks for your time.

Hi Nirav, Thanks for sharing the link.. Can we store user data into some foreign languages.. Like my project is UI should be displayed in French and All the data entered should be saved as french... How can we achieve this..

Just thought for a sec.. Now its confirmed .Thank You:)

Thanks for confirming on this.. I will start searching the articles
for this ..

Hi Ataseven, This solution is what i expected .. Thanks for your help ..

ITs like from the web page user can add the id's and choose a name and address for it.. Initially it will be loaded with some values and our job is if user changes the details or adds new details /removes it.. I should store his activity into daatabse .. Id'd are identity in DB.. Please let us know if you need any furher info.

Its the semi colon in the csv files which is creating a prob as the cell data can have any no of special characters.

Thanks for your response.. The table columns have the Special characters which making the csv come with wrong format..I have one doubt which need to be get it confirmed that without installing anyy excel cant we craete an excel file or we need to do any configurations in SSIS ?

I dont support your comments completely because I have learnt many .Net topics and Technology just for my certifications and which really helped me to understand theory "why we need to study?" and etc. Yes, It is true that Practical knowledge helps but most of the times we will not be unable to tell most of the "Why" questuins.I also believe certification is also equivalent to reading articles and implementing one example. Please correct me if I am wrong..

Hi Habib, Thanks for your response. I ll try the code now

I just edited the question also.. Can you please answer to my question.. I ll come back if I face issues

Sorry.. In haste and urgency I mentioned complet code.. Sure I ll try to write the code first and come back to community. Hope I ll resolve myself

I gave the evry one access but the application is still throwing the access error.

I tried that also.. Still its not working

Thanks for your response.. We gave the Read/Write control to the folder. Then also Its not working. I am also not getting which permission I am missing.

Hi Ahmed,
Thanks for the reply but the real problem is while saving word document to a PDF it should be saved as secured pdf, means it should say as secured in the title bar of the document.

I am actually converting a VB script code to C#.. Where it is checking the Shared path already connected or not.. If it is connected it will ask for disconnection else it will ask for connection.Please find the code snippet
Dim intI
Dim objDrives

DriveIsConnected = False
Set objDrives = objNetwork.EnumNetworkDrives
For intI = 0 To objDrives.Count - 1 Step 2
strDriveLetter = objDrives.Item(intI)
strNetworkDrivePath = objDrives.Item(intI + 1)
If strNetworkDrivePath = strPPath Then
DriveIsConnected = True

Sorry the mentioned link is comparing with the network drive letters, What i need is it should check with paths like '//xyz/abs' ..not with the drive letters like 'A:\'.

Hi ,Thanks for your reply I checked the file permission and memory they are as in the test envi.
The only prob is when we log into server and try to generate it is working but we log off it is failing to regenerate.

Hi ,Thanks for your reply We mentioned the user id and password in web.config but no use.Checked all file permission to the directory ,directory has got all the permissions I tried all the above options but not working..

We are unable to do this can you please provide the sample code. when we searched in google, they mentioned to have the application name same in the webfarm. Do you have any idea to update the same application name for both websites.

I just found the error.When I am converting to XML it is adding a special character in front of XML .Hence the xml is not loading.But I dont know how to remove that..Can you help me now

Thank You....

I dont know JQuery that's why I am suspecting that it is problem with Jquery.Because when I loaded that xml with hardcoded value it is working but when I load the result.d nothing is showing..Its true I should learn the tech.

Hi Suresh, Now I am trying same logic with console application .We made it to run every 5 mins but the problem is we are loading the xml every 5 mins.Can you please tell me how to load an xml daily only once.

Like some time the applications will not be available when we hit on the URl..That time we need to send a mail to Mantainance based the page availability.

Hmmm..Thanks for helping at the right time..I am still confused how it was working in .net 2.0 with the same code..

Many Thanks Bro..Its working perfectly...What is that .d does??

[WebMethod]
public static string Sample(int Id)
{
string msg;
StringBuilder sb = new StringBuilder();
sb.Append("<table cellspacing=\"3\" cellpadding=\"3px\">");
//Morecode
sb.Append("</table>");


return sb.ToString();
}

Thanks for your reply...It is not working in my application when I tried the same.

Sorry Suresh.. The assignement is cancelled..But I ll do as a hobby assignement and post asap

Thanks Suresh..I feel that I can start this assignement today only..thanks for giving inputs at right time.

Thanks Suresh..The First link is really help ful for me..Author explained it very clear and good manner..I want to add one more question here how do I check for files in different folder at different time...?Can I use an xml whill will tell at what time which folder to check etc..Please advice me on this also

Oh Sorry for late reply.I solved that issue it was because of the date format.I was passing the date as 'ddmmyyyy' but it was expecting 'mmddyy'.It worked two days before fine because it was sending date as '12122012',

It is working for 2 conditions which I mentioned in my question .1.when input1 and input2 are not null ,give the result (column1=input1 and column2=input2) (Result should have both vaues matched)

2.Input1 is matched and input2 is null-Return results for matched for input1

But the 3rd Condition
3.Input1 is not matched to column1 and input2 is not null,Return matched for column2=input2

Oh I am very very sorry It is actually J.allFloors ..

Thanks for your solution..But I am using a stored procedure which is having 10 unions so I have to do everything in where condition only

Ya Thanks a lot..I am getting result but only missing 3rd condition,If the floor name is present but input1 is not matching it should give result for rows for matching floorname

Thanks for your reply,,But its not working for me This is the code snippet I am using .. INNER JOIN @TEMPFLOORS j ON j.BuildingId = g.BuildingId WHERE @index='9' and ((g.propertynumber=@input1 and (j.AllFloors=isnull(@input2,j.AllFloors )))) and (f.scheduleddate>=@From and f.scheduleddate<=@To) Please help me where I am missing

Thanks for your reply,,But its not working for me
This is the code snippet I am using ..
INNER JOIN @TEMPFLOORS j ON j.BuildingId = g.BuildingId
WHERE
@index='9' and ((g.propertynumber=@input1 and (j.AllFloors=isnull(@input2,j.AllFloors ))))
and (f.scheduleddate>=@From and f.scheduleddate<=@To)

Please help me where I am missing

Thanks Bro.

That's also true..Thanks for your reply

I upadted the question.Now is that Ok?

I searched both on google and youtube but no good videos found.If you know any links please paste the link

No Just learning in Home.Simple hobby project not for business

Sorry I stopped searching on google afterI joined to codeproject but definitely I try first in google in future.Thanks for your answer,

Sorry I stopped searching on google afterI joined to codeproject but definitely I try first in google in future.Thanks for your answer,

K ... Thanks to you and codeproject

Its k sir,I also wanted to make it as answer but now scenario is changed .My next question is going to be about that only..I ll ask by this thread only..

Thanks sir,I ll prepare it question since it is in raw form and I ll ask you.Can I get your mail ID if feasible.??

Can I ask Other Than Tech Question but regarding the above thread only??

Thank you sir..Thanks for your suggestion thanks to code project.

Thanks I got little info on that.But I have seen in a project.So I showed interest in it.If you have any example please post the same.

Thanks for suggesting that link.It cleared my question Thanks to both.

Thanks a lot..

Thanks for replying.The explanation is in VB language I dont about that.I am a beginner in C# but know about J2EE.If the explanation is in C# I ll be very comfert.Please post if any.Thanks in advance.