Comments by CoderPanda

CoderPanda 12-Apr-14 15:58pm View

They both are good and valid approaches. Which one is better depends on what else you want to achieve.

CoderPanda 10-Apr-14 3:29am View

After this line
acc.Attributes["lookupfieldid"] = "Sampletext";
What do you get in acc.Attributes["lookupfieldid"] ?

CoderPanda 9-Apr-14 13:28pm View

What do you mean by not working? What is the error you get?

CoderPanda 7-Apr-14 7:23am View

Okay, what have you tried so far? This is a Q&A site. We can answer specific questions, but can not design the whole DB for you.

I suggest you start identifying the domain entities first and their relationships.

CoderPanda 29-Mar-14 15:16pm View

You have to provide much more details. What's the error you get?

CoderPanda 28-Mar-14 7:38am View

See if this helps.

http://stackoverflow.com/a/19545210/2671089

CoderPanda 28-Mar-14 7:34am View

You will have to paste the latest code again for someone to be able to troubleshoot, just saying it isn't working is not enough.

CoderPanda 28-Mar-14 6:17am View

Try this:
http://www.wikihow.com/Create-a-Shortcut-of-a-Specific-Website-to-Your-Desktop-from-Internet-Explorer-9

CoderPanda 28-Mar-14 6:02am View

And does it work?

I suggest you look at the CP article I have mentioned in the solution. It has the exact solution to your problem.

CoderPanda 28-Mar-14 5:44am View

Replace the word "jsonTypeName" with whatever name you have for your json type after it is de-serialized. Please paste how you are accessing formatted name and style?

CoderPanda 28-Mar-14 5:42am View

True. I agree.

CoderPanda 28-Mar-14 5:26am View

Code please.

CoderPanda 28-Mar-14 5:17am View

How are you getting the value of formatted name and style?

CoderPanda 28-Mar-14 5:10am View

Hi, Your questions isn't fully clear. Can you please paste your code so far?

CoderPanda 24-Mar-14 5:36am View

"From table" should have the actual table name and not the word "table".

If that is not the case then please share the actual error.

CoderPanda 24-Mar-14 5:24am View

5ed!

CoderPanda 24-Mar-14 4:00am View

Can you not loop through the columns and convert only those that have dates in them (based on the column name)?

CoderPanda 24-Mar-14 0:47am View

Not sure, but can you try increasing the interval to say 10000?

CoderPanda 24-Mar-14 0:46am View

While reading data from the dt, you will have to convert it. You don't have to find another way I think, just use the DateTime.FromOADate method.

CoderPanda 23-Mar-14 6:09am View

Are you sure you are getting any records from the DB?

CoderPanda 23-Mar-14 5:43am View

Upvoted your question. I don't get to see interesting questions like these too often.

CoderPanda 23-Mar-14 3:45am View

Sorry, it's not clear to me at all.

CoderPanda 23-Mar-14 3:40am View

Well you didn't mention that you want to post data to Sagepay.

I don't have direct experience with Sagepay, so not sure if they accept query strings etc. But a form's action attribute will post the form before it can go to server side code.

CoderPanda 23-Mar-14 3:22am View

What do you exactly mean by "some of them it do not return any cell"?
Can you paste sample data from the result please?

CoderPanda 23-Mar-14 2:57am View

Okay, do you see any associated ToString() method on the session or engine variable in your code? Or do you see the return type of the execute method? I think it is just a matter of getting this result and showing in your TextBox2.

CoderPanda 23-Mar-14 1:41am View

The DetailsView control that you are using has the DefaultMode set to Insert. I think that is where, when you save, it tries to insert the data into the dataset.

CoderPanda 22-Mar-14 15:05pm View

Which browser?

CoderPanda 22-Mar-14 14:28pm View

Thanks :-)

CoderPanda 22-Mar-14 14:26pm View

Okay, can you please check if somehow nothing is being returned from DB in the following line?
Session["client_username"] = dt.Rows[0]["client_user_name"].ToString();
If it is getting something from DB, then is there any other place in the code where Session["client_username"] is being overwritten?

CoderPanda 22-Mar-14 13:51pm View

Where are you fetching the the user's name from the DB and assigning to Session["client_username"] ?

CoderPanda 22-Mar-14 11:57am View

sorry, something wrong?

CoderPanda 22-Mar-14 5:49am View

Does TextBox2 has runat=server? Can you please post the HTML/ASPX part also?

CoderPanda 21-Mar-14 23:49pm View

This should be in the bugs and suggestions area. However I was able to download everything except the first one. Looks like that first one has been moved.

CoderPanda 21-Mar-14 8:48am View

Seems like the question is rather: How to display an error "Access is denied" when a user tries to end the .exe of the OP's application via task manager. I am not changing the original Question because even I am not sure.

CoderPanda 21-Mar-14 8:22am View

Please check the syntax in the IF block - condition. Seems like you are doing an assignment in the expression itself that is causing the problem.

CoderPanda 21-Mar-14 8:00am View

which language?
what is the usage - will you add it to your app-installer or use independently or something else?

CoderPanda 5-Mar-14 7:25am View

Do they have any developer API? I don't think so. If they don't then you can not use them programmatically.

CoderPanda 5-Mar-14 5:12am View

Sorry, your question is not at all clear.

CoderPanda 5-Mar-14 5:11am View

For the given string, how do you want your output to appear? It may be easier for me to help if you mention that.

CoderPanda 5-Mar-14 4:36am View

Please post the code here, so that someone can try and help you.

CoderPanda 5-Mar-14 4:06am View

Good answer, +5 from me.

CoderPanda 5-Mar-14 3:48am View

I think you got the question right, but any clarification on the question should be sought as a question/comment right below the original questions itself. Not as a solution.

CoderPanda 28-Feb-14 12:54pm View

There are already apps in the market for this and perhaps open source too. Any reason why you are trying to build afresh?

CoderPanda 28-Feb-14 1:23am View

What is the research you have done so far and what have you tried?

CoderPanda 26-Feb-14 3:28am View

Hi, Seems like your code isn't building. Can you mention what is the line in global.asax file is throwing that error?

CoderPanda 25-Feb-14 2:04am View

Interesting question. I don't have an answer for sure. But if I am allowed to guess, you may want to create a windows user group on the workstation that doesn't have rights to kill processes. Not sure if such a thing is possible either.

CoderPanda 25-Feb-14 2:00am View

May be a mistake or the moderators may have some reason. Please try in site bugs/suggestions section.

CoderPanda 25-Feb-14 1:59am View

Your questions isn't clear at all.

CoderPanda 25-Feb-14 1:57am View

Okay, what have you tried so far?

CoderPanda 25-Feb-14 0:48am View

Well, I will google it the way you would, so not much difference there. And it is better you try out some because what I like may not be really of your choice. We all have different paces of learning.
However, one thing that I would strongly recommend is look at videos than just blogs. YouTube videos would be a better source to learn IMO.

CoderPanda 24-Feb-14 11:42am View

Can I suggest using the slideshow feature in http://jquerytools.org/
Then perhaps have a div over the slideshow that can have the text box.

CoderPanda 24-Feb-14 6:05am View

Glad we could help. Thank you for accepting the answer.

CoderPanda 24-Feb-14 1:38am View

Unfortunately I won't be able to write code for you, but here are steps at a broad level, I am sure if you google you can figure out the way:
1. Write a console app
2. In it, try to read your excel file
3. Identify your DB tables and columns and how they map to the columns in the excel
4. Insert data from your excel into the DB
5. Now if everything works all right, then add a new task scheduler to windows and have this console exe invoked at specified intervals

CoderPanda 24-Feb-14 1:34am View

Yes, sure, but in that case you will have to write a windows service that runs at scheduled times and reads excel files from the desired location and imports into sql server. This will be certainly more effort than having a SSIS package.

CoderPanda 24-Feb-14 1:28am View

Someone with a high weightage has down-voted this solution. May I know why?

CoderPanda 24-Feb-14 1:27am View

Also, are you trying to capture it at a network level or only from the browsers being used at the current moment on the same system where your app is running?

CoderPanda 24-Feb-14 1:25am View

Hi, Why are you trying to build it when there are so many free products to do website traffic check for free?

CoderPanda 24-Feb-14 1:11am View

Quoting from the same SO discussion...

"...you would have to step through the wizard once manually, to set everything up. Once done, you can save the steps as a SSIS package into SQL Server and have that executed at any given time, by scheduling it in SQL Agent. Works on any machine - 32 or 64 bit - no problem."

CoderPanda 24-Feb-14 0:56am View

Have you tried the ideas given by me and Snesh yet?

CoderPanda 24-Feb-14 0:47am View

What does your data connection show (in Server explorer)? Are you using the local DB? Are you connecting to an external DB instead?

CoderPanda 23-Feb-14 7:13am View

What have you tried so far? Where are you stuck?

CoderPanda 23-Feb-14 5:15am View

Okay, so the SO threads that I gave you have solutions for this problem .

CoderPanda 20-Feb-14 3:22am View

Did you check your event viewer to see if app pools are recycling for some reason?

CoderPanda 14-Feb-14 3:01am View

Sorry, question isn't clear.

CoderPanda 7-Feb-14 1:12am View

So glad I could help Braydon. Happy coding.

CoderPanda 6-Feb-14 6:42am View

:) Welcome to the iText# lovers' dilemma my friend. This unfortunately is not possible for all types of HTML tags and CSS styles. I am sure if you google you will see many people ranting about it.

CoderPanda 6-Feb-14 5:37am View

Have you considered using jQuery?

CoderPanda 6-Feb-14 5:28am View

Okay. Do you have your documentation/help content ready? Is this in html format at this point? Now you will have to use the tool to convert that format to chm files.

Have a look at this:
http://www.helpndoc.com/sites/default/files/documentation/html/index.html

CoderPanda 6-Feb-14 3:03am View

Okay, no problem. We all start from the beginning.
First - do you know what a chm file is? If not then please read about it online - shouldn't take more than 10-15 minutes to get a basic idea.
Second - go through the links given and try to make a decision about which one to go with.

Then write back with your decision. I will guide you from there.

CoderPanda 6-Feb-14 2:10am View

And what is the needful here according to you?

CoderPanda 6-Feb-14 2:08am View

Wow! Couldn't get any more direct than this :)
How much can you pay for it?

CoderPanda 6-Feb-14 2:07am View

That depends on which one of the suggested methods you are trying. What did you try and where are you stuck?

CoderPanda 6-Feb-14 1:54am View

How are you planning to use bootstrap? Such as in an asp.net MVC project?

CoderPanda 6-Feb-14 1:11am View

Any reason why you are not considering just using a tool off the shelf instead of building it?

CoderPanda 6-Feb-14 0:59am View

You can put a debugger on the jQuery code and see if the on-change event handler method is being invoked in both pages and if there is any difference.

CoderPanda 6-Feb-14 0:33am View

Well then you need to study a bit about debugging a stored proc in MySQL. Downvoting solutions don't really help.

Try these:
http://stackoverflow.com/a/19540798/2671089
http://www.drdobbs.com/database/debugging-mysql-stored-procedures/218100564?pgno=2

CoderPanda 6-Feb-14 0:27am View

That's not very helpful. Did you try to get what gets passed into stmt1 at run time?

CoderPanda 5-Feb-14 23:56pm View

This should perhaps go to the networking forum. Not sure if TLS is used within the same domain which is why you may not be getting the error in the dev env. Also possibly the app or service that you are hosting may need privileges to communicate over TLS. I bookmarked this Question because even I am curious to know the answer. Please can you post the solution here when you are able to crack this?

CoderPanda 5-Feb-14 23:53pm View

please post your code for each scenario -
When sorting works without dynamic header
When sorting doesn't work with dynamic header

CoderPanda 5-Feb-14 13:54pm View

Not sure, but it can happen in case of call backs too. Is any jQuery callback causing it?

CoderPanda 5-Feb-14 10:22am View

Yes, you are right. By the way, I have used individual master pages for header, footer, body, side navs etc inside one main master page. That project was that content heavy in each of these sections. And it had worked well.

CoderPanda 5-Feb-14 10:06am View

Not fully clear to me. If I have to guess then I would say while assigning data from every cell, just parse it and for every \n create an item in the array and finally assign the array to the column in datatable.

CoderPanda 5-Feb-14 10:05am View

It's okay. Don't worry about it, just try to follow the links given and try to get a response back. You will notice that all the things relate to proxy class, using WSDL and SOAP handling is being taken care of internally.

But once you are successful I would recommend you actually study and understand what is happening under the hood :)
Good luck.

CoderPanda 5-Feb-14 9:58am View

Hi,
I would think nested master pages are suitable for this type of problems. Any reason why you think it isn't for you?

CoderPanda 5-Feb-14 6:07am View

yes, it was indeed a stupid response from me. I overlooked you clearly mentioned VB.net.

CoderPanda 5-Feb-14 5:54am View

Deleted

Apologies if it's a stupid response. I think it can be used this way.
But shouldn't it be [While (Reply_Status == REPLY.NO_REPLY)]
(double equals)

CoderPanda 5-Feb-14 5:50am View

Hi,
Sorry, questions isn't clear.

If you want to just tell the user that he/she can not copy it more than once then you can provide your own terms of copyright and distribution along with the software. See the link below for introduction to licensing of software:
http://haacked.com/archive/2013/07/17/license-your-code.aspx/

Otherwise if you want the user to not be able to copy it more than once then you will have to program it accordingly. That is a whole different story.

CoderPanda 5-Feb-14 5:41am View

Sorry question is too broad and subjective. Here is a link to get you started. It has further references inside.
http://software.intel.com/en-us/blogs/2012/12/26/securing-databases-with-intel-advanced-encryption-standard-new-instructions-aes-ni

CoderPanda 4-Feb-14 8:40am View

Thank you, it is always satisfying to be appreciated by people of your level of credibility.

CoderPanda 4-Feb-14 6:50am View

Okay, thanks. I personally don't think this is a dirty solution. Agreed, may not be the best. I guess we would just agree to disagree in this case.

CoderPanda 4-Feb-14 6:40am View

Hello Kornfield, thanks for your valuable suggestions. I can think of the following without being sure about them:
1. The OP actually mentioned dataset but didn't really mean the c# ado.net dataset. He may just mean his data items as a whole.
2. The realtime need of a solution many a times outweigh the actual solution. So as long as the OP is benefited with it should we really complain. Of course I don't guarantee that my solution is 100% and I am just trying to help. And I think the OP's job is to ensure the solution actually fits into his overall design/architectre and the broad scheme of things.

Please let me know if you think this is a valid approach.

CoderPanda 4-Feb-14 6:25am View

Thanks for accepting it as a solution. But I am not sure if you or someone else downvoted it and why. I would like to know so that I can improve my answer.

CoderPanda 4-Feb-14 5:40am View

I thought the original question was about Oracle and not SQL Server. But, this is a good one. I took a note of this for future. Thank you.

CoderPanda 4-Feb-14 4:57am View

Please mention the error you are getting.

CoderPanda 4-Feb-14 4:52am View

Thanks :)

CoderPanda 4-Feb-14 1:07am View

Absolutely, couldn't agree more.

CoderPanda 4-Feb-14 0:31am View

Yes, that is the purpose of the sql sync framework. But then it is a project in itself. Unfortunately I don't know enough to provide a short answer here.

CoderPanda 3-Feb-14 23:50pm View

No, but if you can elaborate what you are trying to achieve then folks here may be able to provide a better solution. Just in case...

CoderPanda 3-Feb-14 23:26pm View

Interesting and useful debate though I am afraid it will start another SO vs CP debate. I personally prefer something that is in between these two.

I totally agree with guiding the poster towards the answer than writing code for them, however I did try it few times and promptly got down-voted :)

CoderPanda 3-Feb-14 9:12am View

Can you please elaborate?

CoderPanda 3-Feb-14 6:50am View

Updated the original answer as the reply feature doesn't allow me to put XML in it.

CoderPanda 3-Feb-14 6:00am View

Thanks for the link.
My need is to fetch the last modified time of a website that I do not have any control over. The SO discussion is about providing the last modified time of my own website.

CoderPanda 3-Feb-14 5:11am View

I still doubt that the images array has all the data. If it really does then may be the repeater is supposed to be bound differently.

Try using #Eval(Container.DataItem.ToString()) instead of #Container.DataItem

CoderPanda 3-Feb-14 4:55am View

What is the error?

CoderPanda 3-Feb-14 4:43am View

Okay. So the problem here is src="". It should have the path of an image.

Can you please check if the following lines of code are having any values while debugging? Put a break point on those lines and see if correct paths are being formed.
string imgpath=nodelist[i].InnerText;
and
images.Add(fileInfo[j].Name);

From then on you have to keep going backwards and see where the file name isn't coming into the image array properly.

CoderPanda 3-Feb-14 4:10am View

You shouldn't have to make anything in the design view. I still want to see the HTML that is rendered when you run the app. So far you have only given me the server side code.

When you run the app, go to the browser and get the HTML for the empty repeater. It should be a HTML table.

CoderPanda 3-Feb-14 3:38am View

This is all right. I am more interested in the HTML that is rendered. Can you please do a
'view->source' on the browser where the repeater is displayed and paste the HTML portion for the repeater only?

CoderPanda 31-Jan-14 8:41am View

Since you are not really providing much details I am kind of shooting in the dark here...

Can you see if this link helps?
http://rick.bloggingabout.net/2011/01/05/using-crystal-reports-in-asp-net-on-a-64-bit-machine/

CoderPanda 31-Jan-14 7:19am View

Okay. Which location does your code look for in order to find the dll? Is the dll there? Can you please provide code snippets as well as screen shots of the reference assemblies and the folder structure so that I can investigate?

CoderPanda 31-Jan-14 7:01am View

Hi, I mean log4net comes in its own assembly - log4net.dll. Your code is referencing it. So this has to be deployed along with your code at wherever your application is hosted. Can you confirm that this is the case?

CoderPanda 31-Jan-14 0:58am View

Actually no. If you see this post below, there is no clear solution to this and it seems like a bug with VS. Which is why I suggested creating a brand new solution manually and taking your code files to it project by project. Honestly, this isn't an elegant solution, but then you may end up losing a lot of time researching this anyways.

http://stackoverflow.com/questions/3095901/difference-between-build-solution-rebuild-solution-and-clean-solution-in-visua/17781143#17781143

CoderPanda 31-Jan-14 0:19am View

I do not have full fledged working app for you. However this link should serve as a good starting point. Also please do read a bit about log parser, it is very easy and almost like an industry standard when it comes to log parsing.
http://www.codeproject.com/Articles/13504/Simple-log-parsing-using-MS-Log-Parser-2-2-in-C-NE

If the answers are useful to you or at least provide a starting point in your solution then please up-vote them and encourage participation.

CoderPanda 30-Jan-14 23:37pm View

Thanks for the details. I still maintain my answer. I think for inspiration you can download the log parser lizard tool and see how the functionality works as your requirements are also similar.

Here is how I would do it:
1. List down all possible fields/columns in your log file.
2. Build a C++/C#/whatever app. Inside the app build log parser queries based on the columns and conditions selected by the user on the UI.
3. Execute those queries against the desired files and generate output in form of text or CSV files.
4. Now use the output csv to display whatever report you like to.

Hope it helps.

CoderPanda 8-Dec-13 23:45pm View

Reason for my vote of 3 \n It's all right, but would've preferred a better code sample. Explains the concept well enough though.

Comments by CoderPanda (Top 114 by date)