Comments by Abhipal Singh

Abhipal Singh 29-Jun-17 23:27pm View

We are not here to fix you mistakes.

Debug on your own and figure out.

Abhipal Singh 11-Jun-17 20:03pm View

Checked the Event Viewer? Does it say anything?

Abhipal Singh 8-May-17 7:20am View

Could you share the complete error and the version of nuget you are using with VS 2015 community? It looks like a compatibility issue.

I believe you should do more research on the internet.

Abhipal Singh 28-Apr-17 13:35pm View

Ofcourse it will give error if the username column is PK (primary key), the if clause will be true if the username exists in the database and you try to insert it again by writing insert in if.

Again, what are you trying to achieve?

Abhipal Singh 27-Apr-17 7:42am View

your query does not have signature anywhere try changing query = "/psys:request/signature/";

Abhipal Singh 27-Apr-17 7:16am View

Could you let us know the formula being used for "Total". Also, why don't you sum c13 only?

Abhipal Singh 9-Apr-17 7:22am View

Just a random thought:
doctoprint.PrinterSettings.PrinterName = "EPSON LQ-690 ESC/P2";
Is the hard-coded printer name matches with the network printer name?

Abhipal Singh 19-Jul-16 6:21am View

What are the contents of Query Info.xml?
Why do you need this file?
And, I believe you are willing to display selected column names from the query in list box. Am I right?

Abhipal Singh 19-Jul-16 6:16am View

Your data is unclear to fix the query you provided. However, I am very sure that the SUM() is fine and some data is not correct in your tables.

Abhipal Singh 1-Jun-16 3:21am View

What if its 8:00a.m - 10:00p.m?
how do you want to handle this situation in your intended format?

Abhipal Singh 1-Jun-16 3:10am View

Yes, it is possible to fetch data from db without using entity framework. Infact, before entity framework ADO.NET was used for the same purpose.

If you dont want to use ADO also, then check nHibernate. Check link below:
http://www.dotnetjalps.com/2013/09/asp-net-mvc-nhibernate-crud-getting-started.html

My question to you is, why not Entity Framework or ADO.NET?

Abhipal Singh 19-May-16 10:11am View

Do you get any error? if yes, what is that?

Please elaborate more on the issue you are facing. "but the code doesn't work" is not helping.

Abhipal Singh 5-Apr-16 1:43am View

What does that "" mean.. empty textbox? or a space. Also share the regex that is failing to validate.

Abhipal Singh 5-Apr-16 1:42am View

I think the null checks are not required if you are using try parse :) Just a word or advise.

Abhipal Singh 5-Apr-16 1:40am View

Use try parse to convert string to decimal. It is possible that the input values are not decimals at all!.
Would you mind sharing the input?
P.S. trim() is not required.

Abhipal Singh 30-Mar-16 3:16am View

Can you please elaborate on the issue? Above question is quite unclear. If you know that the characters are illegal then why are you using them?

Abhipal Singh 19-Mar-16 2:59am View

Can you add the entire exception message and stack trace along with your question? without that, there is no way to fix the problem. I don't believe in guessing the issues and providing solutions.

Abhipal Singh 19-Mar-16 2:51am View

You can use PerfMon for that. It will generate .blg file which can be analysed using PAL.

Abhipal Singh 9-Sep-15 13:47pm View

Agree!

Abhipal Singh 9-Sep-15 13:35pm View

Can you explain the problem by providing concrete facts? dumping the code is not helping

Abhipal Singh 9-Sep-15 13:30pm View

Load Balancers are generally separate servers with Load Balancing software installed, that distribute load on its nodes. What type of hosting are you using on nodes? How many nodes do you have, on which you want to balance the load?

Abhipal Singh 9-Sep-15 13:27pm View

When are you getting this error?
While running the code on server or while debugging it from your local machine?
In later case, I hope you are running the remote debug client(msvsmon.exe) on the server.

Abhipal Singh 9-Sep-15 13:18pm View

And, where are you stuck exactly?
are you getting any error?
Can you provide more info on the issue?

Abhipal Singh 9-Sep-15 13:15pm View

Google is your best friend!
I would suggest you to start with YouTube videos, they are pretty interesting and will not bore you and make you read a lot of text.

Abhipal Singh 31-Aug-15 10:37am View

What about a numeric up-down control?

Abhipal Singh 30-Aug-15 9:31am View

System.Web.HttpContext.Current.Response
one of the object in the above statement is null because of which you are getting the error. Debug and see which one is null.

Abhipal Singh 23-Aug-15 14:30pm View

Check the links below to add relationships in edmx
https://msdn.microsoft.com/en-us/data/jj713299.aspx
https://msdn.microsoft.com/en-us/data/jj713564.aspx

Where exactly are you stuck?

Abhipal Singh 8-Aug-15 12:07pm View

Can you please explain the issue you are facing?

Abhipal Singh 3-Aug-15 13:22pm View

Can you provide more information on the issue you are facing?

Abhipal Singh 3-Aug-15 13:17pm View

Welcome :)

Abhipal Singh 3-Aug-15 13:16pm View

Can you post your code which is populating the cell contents?

Abhipal Singh 3-Aug-15 12:36pm View

I looks like the objects are not getting instantiated. A missing dll could be the root cause. Can you provide detailed error so that we can help you better?

Abhipal Singh 3-Aug-15 12:32pm View

The link in my answer provides the ways by which you can query the index.
Following link is specific to index querying using SQL syntax:
https://msdn.microsoft.com/en-us/library/windows/desktop/bb231256(v=vs.85).aspx

Abhipal Singh 3-Aug-15 9:12am View

Well, 10000 records in a drop-down is itself a fishy thing(I don't know how user friendly it is), however, as you said there is no issue on the server I take your word.
I have a question, Is this a Development workstation (with hosting server and client on it)?
If yes, would suggest you to check the vitals of your workstation. Like, how much RAM is in use, processor usage and disk usage when you open the webpage. May be, your workstation is not good enough to handle the load of server and client hosted on same machine.

Abhipal Singh 3-Aug-15 8:51am View

What works and what does not?
what is your expectation?
Can you provide more details?

Abhipal Singh 28-Jul-15 11:21am View

Then, my friend, I am afraid I need more info from your side regarding your IIS settings and authentications.

The most common issue I can think of is that you need to enable anonymous auth on your site and there is something which is not allowing that.

Abhipal Singh 26-Jul-15 14:16pm View

And what is the issue you are facing with this code?

I think && should be replaced with || in the return statement below:
return fname.StartsWith(namecheck) &&|| sname.StartsWith(namecheck) &&|| cname.StartsWith(namecheck);

Abhipal Singh 26-Jul-15 3:56am View

You need to provide more information on participating tables.
Also, explain what you are trying to achieve in order for us to help you, you need to help us first :)

Abhipal Singh 25-Jul-15 1:21am View

The execution plan clearly shows that the joins are making the query slow.
Unless, you don't provide some clear information on what you are trying to achieve? it will be very difficult to solve the issue.
Also, provide some insight on the size of the data(no of rows, etc) in the participating tables(on which joins are applied).
May be, creating indexes on those tables will make the query run faster.

You can also try to run the query in pieces to see which join is stalling the query.

Abhipal Singh 24-Jul-15 4:43am View

I just googled your error. There is a solution posted on below link:
http://forums.iis.net/t/1156314.aspx?Problem+when+using+App+pool+account+for+Anonymous+Authentication

See if it helps.

Abhipal Singh 23-Jul-15 15:34pm View

Yes, it will work "string cus = (string)item.Parent.Element("Cusip");" statement will read the Cusip from PositionDetail's parent, which is PositionSummary.

Abhipal Singh 23-Jul-15 13:02pm View

Its a very common thing. You will get a lot of ready made stuff on Google. Just search your way out

Abhipal Singh 23-Jul-15 11:49am View

Can you let us know, what are you trying to achieve by the above query?
Merely saying 'it stuck' is not helping :)

Can you refine your question by providing sample input data and expected output.

Abhipal Singh 23-Jul-15 11:44am View

Apart from the above comments which are really useful. Have you looked at the most common place for errors.. the Event Log?
Also, Did you debugged to see the issue. You can add logging on page load of the failing page to see where it is stuck.

Abhipal Singh 18-Jul-15 5:12am View

Can you please explain a bit more in detail?
What have you tried till now?
Where are you stuck?
Are you writing your own application? If yes, then tell us about that.

Abhipal Singh 17-Jul-15 12:00pm View

Can you elaborate what are you trying to achieve?
Without knowing the intent/requirement it is really tough to figure out the performance bottleneck..

Abhipal Singh 14-Jul-15 12:57pm View

The answer depends on how you have implemented the slide show. Can you provide some insight on that?

Do give you a brief idea... All you need to do is fetch the data from the database and add that data in the 9th(is the number of slides are static) container of the slide image. Basically, your 9th slide/container will be not just image but it will also contain data.

Abhipal Singh 11-Jul-15 10:17am View

Can you explain a bit more?
you can add a gridview inside your place holder tags.. what is the issue you are facing?
Where are you stuck? Do you get any error?

We are yet to develop telepathic abilities.. till then, please provide more information so that we can help you out.

Abhipal Singh 10-Jul-15 8:12am View

Thanks SA! for adding what I missed :)

Abhipal Singh 8-Jul-15 3:25am View

Aren't the question similar to the one below:
http://www.codeproject.com/Questions/1007688/What-are-the-requirements-for-that-application-to?arn=4

Please avoid reposts

Abhipal Singh 8-Jul-15 3:24am View

I am afraid with this little information, we will not be able to help. Can you please explain what your tried till now?
Did you debugged ?

Abhipal Singh 8-Jul-15 3:22am View

Where are you stuck? What is the issue that you are getting?

There is no such specific requirement as far as code is concerned. However, from environment perspective. All you need to make sure is that your database connection string on all the clients is pointing to the centralized DB and the clients are able to reach/connect to the db server.

Abhipal Singh 8-Jul-15 0:34am View

what do you mean by "template in my folder"?
Can you explain you question a bit more?
Also, tell us what have you tried and where you got stuck

Abhipal Singh 8-Jul-15 0:32am View

Can you explain the query a bit more clearly?

Abhipal Singh 7-Jul-15 14:35pm View

Where are you setting the timeout?
What is the unit of timeout (seconds, milliseconds, etc)?
Can you publish the code to explain the problem a bit more clearly.

Abhipal Singh 7-Jul-15 14:29pm View

WMI is meant for Windows OS only..

Abhipal Singh 6-Jul-15 5:42am View

To avoid duplication of data, you can have a primary key for each row. Indexes are not meant for this purpose

Abhipal Singh 3-Jul-15 7:23am View

what is the output of ItemDetails.Compute("SUM(CONVERT(basicamount, 'System.Decimal'))", string.Empty).ToString()?

Also, can you please elaborate what you are trying to do?

Abhipal Singh 3-Jul-15 1:29am View

In my solution I suggested to use parameters to avoid SQL Injection. However, I just gave the easy fix to make him understand where he was failing as far as the SQL query was concerned. :)

Abhipal Singh 3-Jul-15 0:25am View

The question is already answered here:
http://www.codeproject.com/Questions/1005189/How-Do-I-Display-All-Names-Of-Employees-By-Providi

Replace the query with the below:
"select * from table_name where S_ID = '" + txtSearch.Text + "' OR Fellow_name like '%" + txtSearch1.Text + "%'"

Abhipal Singh 2-Jul-15 0:49am View

And what is the problem you are getting now?

As this is a seperate problem, I suggest you to mark this as an answer and write a seperate Question with the details description of the issue/error you are facing now.

Abhipal Singh 1-Jul-15 6:25am View

I believe, oddcast is playing with the tone of the voice to create different effects. However, I still believe they are far away from making there software "sing".

To create something like this, I would suggest you to look for an API which converts text to speech. And write a software on top.

Writting your own speech engine is not an easy task.

Abhipal Singh 1-Jul-15 2:50am View

Is it able to immitate voices of different singers? Also, I just heared the voice in the sample. It is robotic as expected.

Abhipal Singh 30-Jun-15 5:24am View

Try exposing a mex endpoint in your WCF config.

What is the error message?

Abhipal Singh 30-Jun-15 5:22am View

This is a different issue related with db connection. Looks like you have broke something

Abhipal Singh 30-Jun-15 3:02am View

All the names will start from albhabets I believe. That means it is not a filter at all.

The query in Solution will handle this situation. You can keep your textbox as empty and click on search and you will get all the names.

Abhipal Singh 30-Jun-15 2:56am View

We would really appericiate if you could explain your query a bit more clearly.

for now, all I can say is
1) Fetch RPSCRB course batch date
2) Add 1 day to the date obtained in step 1
3) Check if the RAFF course batch date is equal to date obtained in step 2 or not.

Abhipal Singh 30-Jun-15 2:52am View

select * from table_name where S_ID = '" + txtSearch.Text + "' OR Fellow_name like '%A-Z%';

In the above query you have hardcoded A-Z which is incorrect. You need to replace it with txtSearch1.Text as suggested in the solution.

To test the query replace the 'A-Z' with 'da' as given below:
select * from table_name where S_ID = '" + txtSearch.Text + "' OR Fellow_name like '%da%';

Abhipal Singh 30-Jun-15 2:36am View

Can you provide sample data from your database and also, the input you are giving in the textbox.

Abhipal Singh 29-Jun-15 12:55pm View

You can use Microsoft speech for fun to hear a robotic voice!
However you will not be able to replicate an actual song with your code, unless you design an AI in your code (which is going to be really tough and lot more than just a project)

Abhipal Singh 28-Jun-15 1:02am View

To have a cascading control you need to have three different queries in your case. Each of them will return result based on the output of previous query and user input.

Please provide all the information in the question regarding what data the user has selected and what are the outcomes of the queries. May be then we will be able to help you.

Also, try to debug the code, you will be able to find the issue yourself. I am pretty sure it will be an easy fix.

Abhipal Singh 26-Jun-15 1:01am View

What is the issue with the above code snippet?
Are you getting any error?
Where are you stuck?

Abhipal Singh 26-Jun-15 0:57am View

The question your asked is very vague. All I can suggest you is, to implement AJAX search(if you are using ASP.NET).

To help you better, can you please provide more information on:
What presentation (ASP/Windows/WPF..) you are using?
Where you are stuck?
What is the issue you are facing?

Abhipal Singh 26-Jun-15 0:54am View

What do you exactly mean by border of radio button?
Can you please provide xaml of your radio button or WPF page? may be, it will help us understand the problem better?

Abhipal Singh 25-Jun-15 1:39am View

Do you have a table where you store available timings of doctor?
If yes, are you checking the textbox date with the days in that table?

Abhipal Singh 25-Jun-15 1:19am View

Well, I am trying to understand the intent here. Weekday can be found by c# code, is there any specific reason to use SQL?
Also, the parameter @dayname is added after the query is executed! and the param is not even used in the sql command. Something is fishy here..

Can you please explain what you are trying to do?

Abhipal Singh 24-Jun-15 12:14pm View

Use background worker to run your timer on a separate thread and use your main thread to close the windows form when the charger is plugged.

Currently, in your scenario, the main thread sleeps for the interval specified. When the thread gets active only then it checks if the laptop is charging or discharging, due to which you get lag of 1 minute.

Abhipal Singh 24-Jun-15 12:09pm View

Can you elaborate please?

Abhipal Singh 24-Jun-15 11:40am View

Din't get your query.. Please elaborate..?

Abhipal Singh 24-Jun-15 6:21am View

Please provide more clarity on the issue you are facing

Abhipal Singh 23-Jun-15 6:05am View

When I was in college, I did something similar using the hardware and API provided by Secugen Hamster. The API had sample codes so that one can get acquainted.

Check with your device manufacturer for an API. May be that will help you out.

Abhipal Singh 23-Jun-15 5:59am View

without database, where are you going to apply DML operation? Please explain you question a bit more.

Abhipal Singh 19-Jun-15 3:18am View

HtmlElement class is not an enumerator(like arrays and lists). So you will not be able to iterate it inside a loop.
See HtmlElement class documentation for more details:
https://msdn.microsoft.com/en-us/library/system.windows.forms.htmlelement%28v=vs.110%29.aspx

Can you please explain what you are trying to achieve? May be then we can help you fix this loop.

Abhipal Singh 18-Jun-15 11:53am View

Build action property comes under visual studio .dbproj projects. Basically, it is used to specify if the sql file is to be considered for build or not.

Ignore that for now, if you are not using visual studio's database projects.

If you are using Visual studio projects then you need to omit the IF statement as it will not work there.
.dbproj uses a different strategy to achieve what you are trying to do using IF clause.
Read the link below to see how you can use database project settings:
https://msdn.microsoft.com/en-us/library/aa833291(v=vs.100).aspx

Also, there is an issue with you IF statement. please replace it with the statement below:
IF exists(select * from sys.objects where name='dbo.BuildClientSchema' and [schema_id]=SCHEMA_ID('dbo'))
drop procedure dbo.BuildClientSchema
go

Abhipal Singh 18-Jun-15 7:48am View

Yes, I have used enums, a lot :)

There are somethings called best practices. Enums are used to define static things and not dynamic data loaded from file, It does not make any sense.

Abhipal Singh 18-Jun-15 2:37am View

Julie, can you please explain the problem a bit more?

Just double click on your .bat file... Generally .bat files run on command prompt. (I hope I am getting your question right)

Abhipal Singh 18-Jun-15 2:33am View

I can't figure out the problem you are facing with this little information.
Please can you explain in detail?
What kind of query you are talking about?
What is the kind of software you want to run your query?
What have you tried?
Where you got stuck?

Abhipal Singh 17-Jun-15 12:02pm View

Did not get your concept.. Can you please explain a bit more clearly.
Tell us what you tried and where you got stuck?

Abhipal Singh 17-Jun-15 3:29am View

Please provide your entire webpage code.. The one you gave contains a lot of missing tags

Abhipal Singh 17-Jun-15 3:10am View

Please explain the problem.
Also, try to illustrate with sample data with what is expected and what is actully happening

Abhipal Singh 17-Jun-15 2:29am View

I guess by upgrading your bandwidth by requesting your ISP..!
What is the issue you are facing?

Abhipal Singh 17-Jun-15 2:27am View

Tina, Can you please explain your query a bit more?
We cannot help you without knowing what you are trying to do and where you are stuck
Also, everything is possible.. But there are different ways to do it.

Abhipal Singh 16-Jun-15 23:15pm View

What is wrong/not working in this code?
Did you get any error?

Abhipal Singh 16-Jun-15 5:41am View

Elegant!
5ed..

Abhipal Singh 16-Jun-15 4:59am View

Do you want to host a WCF service for printing...?
If Yes, then who will consume this WCF?
Also, Where will the documents get printer (Peter's question above)?

Abhipal Singh 16-Jun-15 3:12am View

Exactly :)

It was my bad..

Abhipal Singh 16-Jun-15 3:10am View

Also, the question is to read a text file on runtime and search the key from text box. I am afraid that this solution will not work as enum is static and text file data will not be converted to enum on runtime.

Abhipal Singh 16-Jun-15 3:06am View

Thanks for pointing out George!
Actully I meant to do that only, please see the answer description. However, I wrote the column headers wrong.. (copy paste mess) :p

Will update the answer

Abhipal Singh 15-Jun-15 23:20pm View

Can you please explain your question clearly...?

Abhipal Singh 14-Jun-15 0:53am View

The code you posted looks fine.. Can you tell on which '(' the error is thrown in your query?

Abhipal Singh 13-Jun-15 13:54pm View

Check the link below to solve COM reference issue:
https://social.msdn.microsoft.com/Forums/en-US/83156d3a-dba5-46b6-a474-a9f7235f3ccf/im-trying-to-run-my-program-but-i-get-a-weird-error-please-help?forum=vblanguage

On the reference - look at the properties and there is one called embed interop - set it to false

Abhipal Singh 13-Jun-15 13:50pm View

what is 'it' in your question?
What do you want to bind to tree view?
What do you mean by non-recursive binding?
What do the code you posted do?

Abhipal Singh 13-Jun-15 13:13pm View

You can serialize your requests and responses to get the XMLs... Did you faced any challenge?
What have you tried?

Abhipal Singh 12-Jun-15 14:10pm View

Looks like your client machine does not have WPF specific dlls and hence, instead of executing it in browser, the xbap is getting downloaded on your client.

Which version of .NET framework is installed on your client?
Which OS is installed?

Abhipal Singh 12-Jun-15 4:25am View

Without sample data.. We cannot figure out what is wrong in the query..

Abhipal Singh 12-Jun-15 2:42am View

By analysing your data.
I believe below line
string date1 = rds["From_date"].ToString();
should be replaced with
string date1 = rds["LeaveType"].ToString();

Abhipal Singh 11-Jun-15 13:31pm View

Thanks! SA

Abhipal Singh 10-Jun-15 12:55pm View

I dint get what exactly you are trying to achieve.

However, if you just want to change the numbers written on button, then you can set the bt.Text property on runtime by swapping it with the other button's number. By doing this you are not actually swapping the entire button but only the text written on it.

Abhipal Singh 10-Jun-15 5:28am View

Peter has a good point! If you optimize your cache store then you will automatically get the desired performance out of your linq query.

Also, If you have a linq statement and its result is same most of the time and is not changing very frequently, then you can consider caching your linq result set. (Because it will not make any sense if you cache the result set and then it changes for every call and you end up rebuilding your cache)

Also, you need to decide a strategy, when you want to refresh your cache and what effect will this cache refresh have on already running stuff.

Also, keep in mind that linq evaluation is lazy. Unless you don't iterate the IEnumerable, it(linq) will not actully evaluate anyting.

Abhipal Singh 10-Jun-15 4:34am View

Well, I know what caching is... And I know how it is implemented using MemoryCache class in System.Runtime.Caching namespace.

What do you want to achieve in Linq using it? what do you want to cache? Linq result set?

Abhipal Singh 10-Jun-15 4:11am View

Chill60 is right, try that and you will figure out why it is not working.

Also, a word of advice, dynamic queries are performance killers and error prone. Try to avoid them if possible.

Abhipal Singh 10-Jun-15 4:06am View

Can you explain a bit more?

Abhipal Singh 10-Jun-15 4:04am View

I did not get you. What do you exactly mean by swaping? and swap button with what? can you explain the requirement a bit more clearly.

Abhipal Singh 10-Jun-15 4:00am View

It depends on the column type in your table. If it is bigint then you can type cast your varchar. Check updated solution above to see how.

Abhipal Singh 10-Jun-15 1:42am View

Did you Googled?

Abhipal Singh 8-Jun-15 6:29am View

Large dynamic queries are usually performance killers.. Try to eliminate them..

Abhipal Singh 8-Jun-15 6:26am View

Nice code.. Is there a problem with it?

If yes, please explain :)

Abhipal Singh 8-Jun-15 6:24am View

Can you explain a bit more?
How are you trying to send email? SMTP server, C#code, etc...

It looks like you have forgot to provide credentials while sending email.

Abhipal Singh 8-Jun-15 6:19am View

Which line of code is throwing this error?
What is the "text" in your text box?

Abhipal Singh 8-Jun-15 0:39am View

Which presentation are you using? ASP, Winforms, WPF....

Abhipal Singh 6-Jun-15 2:48am View

see updated answer, it looks like you are inserting address instead of phone in your SqlParam @phone.
The error you posted will not occur after you make the changes suggested.

Abhipal Singh 6-Jun-15 2:40am View

5ed! Nice explaination of a real world problem:)

Abhipal Singh 5-Jun-15 13:43pm View

Have you published the web application on IIS? or you are running it from Visual Studio?

your folder path inetpub/root/appdata made me curious :)

Abhipal Singh 3-Jun-15 2:18am View

you will not be able to find your html controls in default.aspx.cs.

The only way you can call your default.aspx.cs functions from default.aspx is by using javascript.

Follow the link in the solution. All you need to do is define a javascript function (say foo()) that calls default.aspx.cs function(server side code) and call this javascript function (foo()) on onclick event of your html button.

Your function call will go this way.
html--->foo()--->default.aspx.cs

Basically you are using javascript function as a proxy to call server side code.

Abhipal Singh 2-Jun-15 12:50pm View

Can you please explain..? Your question and code both are unclear..

Abhipal Singh 2-Jun-15 1:57am View

There can be a lot of reasons. One of them is bad monitor (or bad code:p). Can you please explain the problem, what exactly the issue is?

Abhipal Singh 1-Jun-15 12:55pm View

Open your file in notepad++ to see the newline characters as -SA suggested {CR}{LF}.

Hint: You will need to do a string.Split('your new paragraph char')[0] or string.Split('your new paragraph char').[1]

Abhipal Singh 31-May-15 13:58pm View

Yes you can do it without ajax if you want your entire page to reload on star button click.
More detail required on what you have tried and where you are stuck..?

Abhipal Singh 31-May-15 8:44am View

Check the link below to actually find out if you have any version of .NET framework installed or not:
https://msdn.microsoft.com/en-us/library/hh925568(v=vs.110).aspx

Abhipal Singh 31-May-15 8:40am View

Can you please include "database update" code in your question as well?

Abhipal Singh 31-May-15 8:33am View

5ed.. Elegant :)

Abhipal Singh 31-May-15 8:31am View

Can you explain your question?

Abhipal Singh 30-May-15 3:46am View

Your comment says that the file name is "CardBack_Red.png"

However, you are hardcoding file name as "CardBackRed.png" in your question.

Can you check that as well.

Abhipal Singh 30-May-15 3:29am View

Did you checked the values in variables, by attaching a break point in visual studio?

Also, the "." is missing in "\\Images\\Cards\\CardBack_Red.png"
it should be ".\\Images\\Cards\\CardBack_Red.png"

Abhipal Singh 30-May-15 3:02am View

Did you debugged the code?
What are the values of input parameters subfolderName and imageName when you debug?
Most importantly, What is the value assigned to fileSpec?

below line looks perfect..
string fileSpec = string.Format(@".\Images\{0}\{1}.png", subfolderName, imageName);

Abhipal Singh 29-May-15 13:56pm View

I don't think file size will lead to this type of issue

Abhipal Singh 29-May-15 4:52am View

Can you explain what you want to achieve?

Abhipal Singh 29-May-15 3:43am View

I guess by using parameters.. :)

However, you need to be more specific in your question. Can you please explain what exactly you are stuck with...? I have not developed telepathic abilities till date.. :-p

Abhipal Singh 29-May-15 3:31am View

On which UI control this issue is occuring?
what is your presentation system (windows, WPF, ASP, etc)?
Or are you using console to display this string?

Abhipal Singh 29-May-15 2:35am View

This is not clear as well. Can you please elaborate your example.

Abhipal Singh 28-May-15 5:07am View

Do you want to remove the entire question line? or you just want to remove "?" character?
Asking this question because the some solutions posted below does not align with the question.

Can you post a sample in your question of what is there in the file and what do you expect it to be?

Abhipal Singh 28-May-15 3:31am View

Too much confusion. Can you please explain your problem a bit more clearly?

what does this line mean? "and another one not to change first as second page.while refreshing. "

Abhipal Singh 28-May-15 2:30am View

Can you post your Update query?
and some code as well.

Abhipal Singh 28-May-15 2:29am View

Did you tried to debug your code?
Is the value of Request object not null?

Abhipal Singh 27-May-15 23:41pm View

Can you please elaborate the problem you are facing...

Abhipal Singh 27-May-15 22:21pm View

I assumed that 'novon' was getting used outside the for loop. (Actually I was trying to generate that error subconsciously :p and hence gave the solution which turned out to be unclear.. :(.. )

Thanks for your input SA.!!! I appericiate your feedback :)

I will not assume anything and I will ask the inquirer to be specific.

@Inquirer: Please post a complete piece of code which can individually run so that people (like me and you) can help better

Abhipal Singh 27-May-15 15:02pm View

Rating (1-5 stars) is perfectly fine. However we can only rate a 'Solution'.

I am looking for a "Like" button that will work just for comments.
So that we can Like an individual's comment. For ex: if I like _duDE_'s comment "The words of wisdom :) +5" there is no way I can tell him except writing reply to him.

Abhipal Singh 27-May-15 13:21pm View

5ed. Good solution!

Can we have like button on comments in Code Project :)

Abhipal Singh 27-May-15 10:42am View

Possibly the default constructor is being called because of which the value is not being set.
Also, you need to make sure if the parameterize constructor is being called then UserManager should not be passed as null.

Debugging you code by attaching breakpoints is the key to solve your problem.

Abhipal Singh 27-May-15 4:23am View

I would suggest you to read about Restful services if you want to work on URL based parameters.

Abhipal Singh 27-May-15 4:19am View

5ed! Agree

Abhipal Singh 27-May-15 1:49am View

There is a binding mismatch between the client and the server.
Check the modified Solution for new bindings.
Also, turn on Anonymous authentication for now..

Abhipal Singh 26-May-15 13:08pm View

Ohh! I misunderstood..:p I will check and let you know... lets see what else we can do. :)

Abhipal Singh 26-May-15 12:20pm View

Nice! Congrats!!!

and You are welcome Andy!

Please mark the solution as accepted and rate accordingly to show your appreciation :)

Abhipal Singh 26-May-15 12:13pm View

Glad you figured it out :)

Abhipal Singh 26-May-15 7:58am View

Oops :(
Can you update the latest config files in your question again plz.

Abhipal Singh 26-May-15 7:56am View

Have you updated the username and password in App Pool. Also, are you using the same Username and password in App Pool which you tested from SSMS?

Abhipal Singh 26-May-15 7:06am View

umm.. Add the "system.net" in setting your client config. (check updated answer)

Abhipal Singh 26-May-15 7:00am View

Great!

Add that certificate into your certificate store. Once you do that, the warning will disappear. After that it should work fine from your client..

Abhipal Singh 26-May-15 6:55am View

Yeah!
It looks like the security thing we implemented worked :p

Did you tried to browse the service in IE?
Was it browseable? or you are getting 403 there as well?

Abhipal Singh 26-May-15 6:43am View

Try the solution 1 and let me know if it works :S

Also, Generate your client binding by using the binding in solution 1 as your server binding and see what difference it creates..

Abhipal Singh 26-May-15 6:16am View

May be you can try the one below and see if it works :|...
I always find it hard to make a config work.. I can understand your pain.. :)

PS: pasting the config in solution 1.. I dont know why it is not getting pasted correctly in comments..

Abhipal Singh 26-May-15 6:06am View

Your Web.Config is the server config I believe (config file of your website)?

It does not have a secure endpoint defined. However, you are trying to access a secure endpoint from your Application/Unit test (App.config)

Abhipal Singh 26-May-15 5:02am View

I dint get you... It looks like you are following a new approach..?

It would help if you could summerize everything and explain your new approach(the way you are using SPs and stuff)...

Abhipal Singh 26-May-15 2:18am View

See, it works this way, to help you.. you need to help us by giving elaborate answers to questions. one liners are not descriptive and they dont help.
By the above statement it seems that nothing is constant. If that is the case then where are you saving formula of "Rest"?

I would suggest you do provide clear and descriptive answers if you expect solutions.

Abhipal Singh 26-May-15 2:15am View

You need to debug the GetAppliedLeaveBalance() because you are passing different parameters this time in case of LWP.

Hint: Use immidiate window to check the parameter values you are passing to this method.

Abhipal Singh 26-May-15 2:00am View

One table for each user!!!
I just hope you have very few users and you know which table will correspond to which user.

I have an answer to your question, however, before I post it, can you answer the below questions which I asked earlier..

Are all the strings CA, Rs, IN, Rest, Basic, Total, HRA, SA constant or will they change as well?
Is the calculation of "Rest" constant?
What will be the final output?

Abhipal Singh 26-May-15 1:56am View

Did you tried to debug GetAppliedLeaveBalance() in LeaveManagement class?

Abhipal Singh 26-May-15 1:46am View

every user is going to have its own formula?
If yes, then are you keeping a seperate table for every user??!!!
what type of table are you using to save this formula? SQL, in memory, etc?
Also, answer my previous question.. :)

Abhipal Singh 26-May-15 1:40am View

I understand that your numeric values and formulas will change.
However, are all the strings CA, Rs, IN, Rest, Basic, Total, HRA, SA constant or will they change as well?
Also, is the calculation of "Rest" constant?
What will be the user input.. Just "Total" I suppose?
What will be the final output?

Abhipal Singh 26-May-15 1:34am View

What does this entire code do? On which line you are getting this error?

Abhipal Singh 26-May-15 1:30am View

I can understand your calculations. However, the million dollar question is.. where are you stuck?

Please answer SA's comment

Abhipal Singh 25-May-15 11:26am View

What more exactly do you want to achieve using SSRS?

Abhipal Singh 25-May-15 11:20am View

Well, the commands I gave work fine when I use them :)
why not you just try iisreset from batch file as see what happens?(Of course do "Run as Administrator")

Abhipal Singh 25-May-15 11:19am View

The error is quite clear. The user "HW_Logging" does not have login rights on your SQL server. If you have changed the password, then update the new password everywhere else.

Abhipal Singh 25-May-15 6:54am View

Well, I think that is what I wrote in my solution.

Check the App Pool being used by you website, then check the Username on which that app pool is running.

Once you get the user name, check if that user name have rights on your SQL server database to login and execute commands.

Also, on production I am pretty sure your Website App Pool user have rights on your production database.

Abhipal Singh 25-May-15 6:47am View

Did you run your command prompt by using "Run as Administrator"?

Abhipal Singh 25-May-15 6:10am View

I think Freelancer.com is a better place for you.. :)

If you have any specific problem, then we can help you solve it.

Abhipal Singh 25-May-15 5:53am View

How are you getting those file paths?
I believe by using a custom component.. If Yes, Then have you tried to debug the custom control you are using to fetch the Directory and its files? What are the results?

Abhipal Singh 25-May-15 5:39am View

Is there any issue if you could split multiple words into multiple columns?
for ex:
"let stay" in one cell will be changed to "let" and "stay" in two different cells.

Abhipal Singh 25-May-15 3:45am View

Then it looks like you are on the right track buddy :)

Let me check what I can do for you to have a cascading combo box.

Also, it will help if you can state the cascading requirements a bit more clearly in your question around how you want to use FirstActivity and SecondActivity.

Abhipal Singh 25-May-15 3:27am View

Well, that will depend on the SDK that you finger print scanner provided. Check the SDK documentation to get your answer.

Abhipal Singh 25-May-15 3:05am View

I believe you added "Me.Second.Add(_selectedFirst.SecondActivity)" line in the auto generated file. I suggest not to do that because it will get erased when you regenerate your entities in future. Also, the intent to add this line is unclear.

Secondly, As you just have to populate your combo box. All you need to do is, get your ObjectResult of the stored procedure and iterate it for SecondActivity to fill a list. Finally bind that list.Distinct() to your combobox. To have a cascading effect, write your code to work on the ObjectResult and not inside the auto generated class.

Let me know if you face issues in this approach :)

Abhipal Singh 25-May-15 2:27am View

It looks like you are Adding a string value _selectedFirst.SecondActivity to CustomObservableCollection. Since, both the types are different they are conflicting.

Also, what do you mean by "add column name to the property of my stored procedure"?
Is this column not added when you generated your edmx?

Abhipal Singh 25-May-15 2:24am View

5ed. Agree :)

Abhipal Singh 25-May-15 1:13am View

Also, can you please provide code for Me.Second Property as well.

I am looking for types here which not getting matched

Abhipal Singh 25-May-15 1:10am View

And what do you expect from this "Generic Algorithm" to do with your binary string "1011"?
OR
What all mofications will this Generic Algorithm do on your binary string?

Abhipal Singh 25-May-15 1:05am View

Can you provide your SecondActivity property's code as well?

Abhipal Singh 25-May-15 0:12am View

Well, I am yet to develop telepathic abilities.. Till then, can you please (write) let me know, what is the issue/error/problem you are facing...

Abhipal Singh 25-May-15 0:07am View

Well, I am yet to develop telepathic abilities.. Till then, can you please (write) let me know, what is the issue you are facing!!!

Abhipal Singh 24-May-15 2:45am View

:)

Abhipal Singh 24-May-15 2:44am View

Wolaa!!!
You need to reconsider your database design.. it looks flawed

However, what you said is possible.. Do your homework and you will get to know how to create columns programmatically..
Hint: you just have to run a DDL command using c# SqlCommand.

Abhipal Singh 23-May-15 4:49am View

Well, I am yet to develop telepathic abilities.. Till then, can you please be more specific and explain your issue a bit more?

Abhipal Singh 23-May-15 4:41am View

What are the IE versions on your dev and QA environment machines?
Just trying to figure out differences here...

Abhipal Singh 23-May-15 3:44am View

The code I gave is just an algorithm on how you can deal with current problem and it is not the actual bulletproof code! We are here to help people when they are stuck somewhere.

I am pretty sure you din't even tried to resolve this error!!! Which is not a good attitude when you want to learn something. If you have tried something then at least let us know what you have tried and where you got stuck. Trust me, we will be more than happy to help.

Check the modified solution. I have added a Convert.ToInt32() call which will do the job in your case.

Note: The above code is not bulletproof and I am leaving it as an activity for you to make it bulletproof! :)
The code will still break when you type a non numeric value in your txtNoOfMonths textbox.

Hint: see use of Int.TryParse(), Numeric drop downs, validations, etc

Abhipal Singh 22-May-15 13:59pm View

Can you publish your WCF binding file here?

Abhipal Singh 21-May-15 13:52pm View

Nice!

Did you checked the memory growth on Perfmon counters..?
If you see it as a growing trend and the memory is not getting reclaimed even after your processing is complete. Then it is definatly Memory Leak.

Do let us know the root cause of the issue when you find it :)

Abhipal Singh 21-May-15 10:04am View

Deleted

AJAX is the key to your solution

Abhipal Singh 21-May-15 9:41am View

I can understand you are reading it line by line..
However, I am asking if you are 'writing' your output file line by line or not?

Also, have you checked for memory leaks?

Abhipal Singh 21-May-15 9:18am View

Haha. Nice! and thanks for explaining things clearly:)

Even if you have that much RAM, I don't think the .NET framework will be able to use it efficiently. However, that is a different story.

I am trying to understand where are you getting the bottleneck. The code you gave should work fine as you are reading lines and not the entire file in one go.

However, I think you are not writing the files in line-by-line fashion, which will ultimatly create the dreaded bottleneck.

Correct me if I am understanding the issue wrong?

Comments by Abhipal Singh (Top 200 by date)