Comments by José Amílcar Casimiro (Top 200 by date)

Do you think it makes sense to sum 'YES' and 'NO'? Additionally you have a problem with group by.

What do you mean by building a web server? Do not those who exist serve you?

Read this: https://docs.mongodb.com/manual/aggregation/

I would like to be a client of your bank, any transaction would make a deposit in my account.

Here is the code?

Show us the code

You cannot connect to the database using xslt. You will have to use entity framework or ado.net for example.

Why don't you return chunks of results? No user can view thousands of records, so paginate the results.

Also check out this article: https://technet.microsoft.com/en-us/library/2007.11.sqlquery.aspx

If you are using firefox or chrome you can download an extension.
That extension will give you the xpath for any given element in the page.

bjita.click(); -> I suppose it is a button!!

Can you add the model database?
It seems to me you have a problem with the data model.

I was looking at the page and do not find the existing xpath in the code. I suggest you go looking for a extension for your browser that give you the xpath based on a given element.

I don't know if is possible, please contact wix support team.

XSL stands for EXtensible Stylesheet Language, and is a style sheet language for XML documents.

The file is in the indicated path? And the file access password is mentioned?

Are you a serious problem. You have no idea what you're doing. Can you open the image by placing the server address and the path to the image in a browser? If yes, just put the address in the html img tag.

What is the bill table schema? dbo?

Does your phone support javascript?

Your question is not clear. What do you want to do?

Yes you can

Your code is garbage, you send out.

Read this: http://www.codeproject.com/Articles/100084/Introduction-to-ISO

Open a project, right-click references in solution window and add view.dll

Split the text by the 'space' char. Implement a word counter.

Add a reference to an external assembly. Point it to view.dll. And that's it.

So, what is the problem?

WTF?

It will not be better to make use of CSS?

You just want to get the text and remove the html tags?

what is your initial approach to solve the problem?

Post your exception output, i want to see the stack trace.

No i will not code for you.
I help you, giving you the way to get there.

You are not using google the right way.

Visit: https://code.msdn.microsoft.com/windowsapps/Uses-the-OCR-Library-to-2a9f5bf4

what?

Great. Good Job.

You have your requirements, what are your difficulties?

Read this article: http://blogs.msdn.com/b/akashb/archive/2008/12/19/how-to-get-details-about-a-exchange-user-in-outlook-2007-outlook-2003.aspx

Not clear. Improve your question.

Must have attention to sql injection.
Can you show the code of the Page_Load event.

5! Good Answer.

Your code presents no problem.
What you should take into account is that the code is written for humans to understand.
The code needs to be maintained over time, and the most effective is that of code solves the problem for which it was created and that can be maintained easily.

The process crashes?

Thanks.

Thanks. I'm more used to writing code in C # than in VB.

5+! Good solution.

This is not a solution.

What?

What?

One of the strangest requirements that I have read in recent times.

Insufficient information.
Do you have another queries running over the same table?
How your code open and closes connections?

I had a hard time understanding the need of the user. Glad that his problem was solved.

Would you like mouse click on the button do change the value of a boolean variable ? Something like this: boolValue = !boolValue ?

How can the mdf and log file crash? Do you mean a physical crash?

In C# the project requires a reference to the Microsoft Internet Controls (SHDocVw) type library.

:)

Sorry for the stupid question, but did you check that you had data in Db, right?

Read: http://www.codeproject.com/Questions/306431/Parsing-CSV-Files-By-Cplusplus

What is the problem?

You have to write some code.

Post your method code.

Write the classes in the model zone, and call them from the controllers.

Are this objects lblnoteName, lblbookValue in the correct letter case?

You need to stop the threads or wait until they are complete and then the process is closed.

I found this article: "Connect to SQL Server Through a Proxy Server".
http://msdn.microsoft.com/en-us/library/ms179448.aspx
Maybe this can help u.

http://www.codeproject.com/Articles/17507/Secure-VNC-Viewer

View this: http://www.slideshare.net/AnushaBabooa/booting-steps-of-a-computer

What's the problem?

Thx

+5

Do you want to know if the file is open by your application, or some other process?

HTTP Basic authentication?

Thx

The requirement set by the user, just wanted to run the stored procedure in a particular date format.
Changing the date format is only valid for the current user session.

I doubt very much that this code works. What you need to do?

Your requirement is not clear. Do you want to manage a dynamic connection string? or use it and make a connection to the database?

;)

Read my answer carefully, and you'll understand why.

Read this article about exception management: http://msdn.microsoft.com/en-us/library/ee658105.aspx#ExceptionManagementSteps

http://www.codeproject.com/Questions/106442/Create-a-setup-for-windows-application-including-D

To understand you better explain the logical organization for implementation.
For example, a client application that is based on windows forms and uses a sql database server as a data repository. Is something like this?

Check this: http://stackoverflow.com/questions/13367818/set-selected-item-of-listview-according-to-a-value

what kind of software? I assume that this is not a web application.

c00l

If length is bigger than zero.

You should use the condition like this:
if (TextBoxNewEmail.Text.Trim().Length > 0) { //new email } else { // old email }

the question is poorly structured.

cmd.Parameters.AddWithValue("@Password", Pass); Is Pass a variable or an object?

Improved my answer. Check it out.

Check this thread: http://stackoverflow.com/questions/2407002/how-to-control-the-system-volume-using-javascript

http://simpleajaxjsp.blogspot.pt/

Use "Improve question" option and past some code.

Probably the "fldpass" field is a string and is also missing the limiter string.
You must be careful with sql injection.

You're going down a bad road.
First you must address the requirements of what you need to implement.

Sql Injection -> ds = cl.dataset("select * from tblItem where cat_id = "+Request.QueryString["q"]);

Here is the xml file?

Improve your question with table schema.

That is another different problem. Don't forget Griff advice.

Try this "if (dsPwd.Tables[0].Rows.Count > 0)"

It seems that the algorithm sends the email if the user exists in the database. The condition is correct?

if (dsPwd.Tables[0].Rows.Count < 0) is this ok?

:)

maybe there is some argument that shows that I am wrong. I am humble enough to say that I do not know everything. I always learn new things.

JAFC

Repository Architecture in the given article is a design pattern in my point of view. Why do you call it an architecture? Thanks.

The IIS Server runs under an user account. For instance MACHINE\Network Service or other account. This account needs to have permission to raise a process (System.Diagnostics.Process.Start).

And the IIS process have an user account capable of raise a process?

http://stackoverflow.com/questions/251842/asp-net-extended-range-validation

Is the IIS Server in your machine? or is it a server? If it is a server then you're trying to open a process on the server and not on the client.

You can extend the RangeValidator control into a new control for your validation needs.

Extend an existing one.

You have an example in the given link.

I will give you a hint, you need to find the least common denominator.

Are you using client-side script to go from PageB to PageA or server side-script?

Please improve your question. I don't understand what you need.

Google is your friend.

https://sample.website.com/PathToYourWebService.asmx?WSDL

I don't understand your question. It is the same thing.

Google it. ;)

javascript:Tip <- What is the second parameter in this method?

Check this: http://www.asp.net/ajaxlibrary/ajaxcontroltoolkitsamplesite/cascadingdropdown/cascadingdropdown.aspx

You have to profile the website code. If it is a production website you can use performance counters to try to understand here the problem is.
You can also check the iis logs to verify which requests are consuming more time.

System.ComponenetModel.Win32Exception The Network name cannot be found at
System.Diagnostic.Process.StartWithShellExecuteEx(ProcessStartInfo,StartInfo)
at System.Diagnostic.Process.Start(ProcessStartInfo,StartInfo)
at ApplicationShield.Form1.Button1_Click(Object sender,EventArgs e)

Make sure that your windows 7 can read the share, by accessing the share from the command line for example.

Does the website with problems have anything to do with reporting services?

Read this article: http://www.codeproject.com/Tips/543391/HTML5-for-Asp-net-Csharp-Developers

What kind of application are you developing? windows forms? asp.net?
Are the clicked link from your application or are you trying to catch any link in the browser?

Have any significant error in event viewer? If your domain are very slowly in the afternoon you may have a memory leak or some other type of error in the code.
Try recycle your application pool when the site is very slow, if it runs faster after que app pool recycle then your code could be the problem.

Use Improve question option please.

Can you paste here some relevant code?

Make sure that CausesValidation is set to false.

Show us some code. :)

Probably you're leaving your connection object open. Until garbage collection destroys the object you will have the error. I can give you a better response if you show the code.

You should put your question into Discussions > Design and Architecture.
We can discuss your proposal, do you have one?

When you invoke the method send from that class instance you are getting an exception, so probably, the problem is with that object.

RemoteObjects.RemoteSMTP what is this? Your updated code and your question does not match.

What's the title to do with the question?
Explain yourself better, did not understand the problem.

show us the code...

what you intend to achieve? the date is already present.

The problem definition is the most important step to obtain our answer.

wtf?

So...what is your problem? Create a method in your SmartVote.cs to insert the file into the database, that accepts a parameter with the file content (byte array).

Your question makes no sense. What is your problem?

Your question does not make sense. What are you trying to do?

What?

Why do you need to pass a column name into a stored procedure?

It does not seem a good idea to put the Password field with autocomplete option. After all we are talking about authentication and subsequent authorization.

Improve your question please.

I update the solution.

Can you read your code?

I see too button2.

I will help you with c# as soon you make a question.

Call page_load event.

~:-)

It's not possible. The underlying collection cannot be modified while it's being enumerated.

How do you know that your program freezes in that block of code?

What "does not work completely" means?

The way that Mr. Dhaval exposed the problem I got the feeling that he had no information about the problem. If we do not make the effort to solve a problem by ourselves, we need luck.

Sorry Joan, i can not help. Good luck.

Please, improve your question instead of dump code into comments. Thanks.

A root user can do anything in the system.

If you need help with code, you must post your code using "Improve question" link.

Are you referring to "sql server code" as "t-sql"? What tools have you available? most of client tools have options for this.

How is the user profile in your solution?

Justify your text into the right.

Your friends are not able to resolve the address? ask them to resolve the fqn into an ip address.

try using "dd-MM-yyyy" instead of "d/M/yyyy".

what's your question?

what have you tried?

:)

In my country [PT] there is an expression: "use a cannon to kill a fly." :-)

Thanks for the reply. OleDb gets the job done in the case presented by ricardo. On the subject of DataSource I did not understand, because my comment was exactly that.

I agree. Thanks for the clarification.

Hi Sergey, can you give me a bigger picture of your sentence:

Your "as a separate assembly" suggests that you consider boundaries between assemblies too seriously.

Thanks.

Hi Maciej, why it is not possible doing it using OleDb?

You can't add a datatable object into a value inside a cell.
You can bind a datatable into dataGridView.DataSource property.

Look...SqlDataReader class, provides a way of reading a forward-only stream of rows from a SQL Server database. IF it is a requirement to use SqlDataReader, you will need to create your on index, for achieve data control navigation.

Unless this is your homework, i recommend you to change your code design.

count the lines you're reading and change the loop condition to achieve your goal.

Agree. Thx.

Your problem begins in this line: "LocalCart = (DataTable)Session["cart"];"
Do some work now please.

If you add a watch to this statement item.Cells["Status"].Value, what value do you get?

'ListCards' object type ?

+5! beautiful

https://forums.aws.amazon.com/message.jspa?messageID=427239

Are you asking how you can restrict a browser to have only one user session in your application? If so, I do not see how. You will have to code your application so that it does not allow more than one simultaneous session. But that raises other questions.

What do you mean by secure admin page?

You should improve your question, instead of dumping code into comments area.

You should improve your question, instead of dumping code into comments area.

:-)

Hi executed your code ok. I can see the number 13. Cheers.

Binary files could have characters that are not allowed by soap protocol.

But some code must be developed.

Ftp protocol does not implement anything like that.
Http protocol does not also.

1. Save the file to your computer disk from the web.
2. Use an ftp client to upload the file to the remote host.

What do you mean by decrease the performance? Have the UI locked? If so, make an async thread to get the data.

Tomorrow will be sun. Can you show the code?

It makes no sense try to instance a schema file. Why do you want to do this?

To rajendra_patel:

When someone plays you, you can and should not like. If you like enough of software development, you'll transform that energy into learning and knowledge and you will be a better software developer. From my short experience I can share with you that we will never know everything and there will always be a better developer than you. Your will, will dictate how much you'll want to be a great software developer. Already I can hear the background music "eye of the tiger."

:-)

If you go to the server website and use a microphone, the code should work.
It will not work on the client browser from a remote machine.
You will need to review your solution architecture.

Zoltan are telling you a something different:

select distinct MTMRN from (

select a.MTMRN, a.PatName, a.IDX6, a.ServiceDate, a.ExamName, a.Exam,
b.SchedProv, b.SchProvNPI, b.ApptDt, b.ApptDt2, b.ApptTm, b.ApptTm2,
b.VisitType, b.STATUS,
b.PCPNPI, b.Referring, b.RefNPI, b.Deceased,
c.source, c.payer, c.patient, c.dob, c.gender, c.addr1, c.addr2, c.city,
c.state, c.zip, c.phone, c.mbrid, c.pcp,
c.PastProv, c.PastAppt, c.cd, c.FutProv, c.FutAppt
from [DataWarehouse].[dbo].[BHMammColPats2] a
INNER JOIN [dbo].formatIDX_PastAppts b
on SUBSTRING(a.MTMRN, PATINDEX('%[^0 ]%', a.MTMRN + ' '), LEN(a.MTMRN)) =
SUBSTRING(b.MRN , PATINDEX('%[^0 ]%', b.MRN + ' '), LEN(b.MRN))
INNER JOIN [dbo].[Full_roster] c
on SUBSTRING(b.MRN, PATINDEX('%[^0 ]%', b.MRN + ' '), LEN(b.MRN)) =
SUBSTRING(c.MRN , PATINDEX('%[^0 ]%', c.MRN + ' '), LEN(c.MRN))
where a.Exam='COL'
and b.SchedProv='WEINSTEIN M.D.,ROBERT E.'
and b.STATUS='ARR'
and (b.VisitType='OVT' OR b.VisitType='AWV' OR b.VisitType='SWV')
and CAST(b.ApptDt as datetime) > = '2012-01-01 00:00:00.000'
and CAST(b.ApptDt as datetime) < = '2012-12-31 00:00:00.000'
and datediff(year,dob,getdate()) between 50 and 75
and datediff(year,ServiceDate,getdate()) < = 5

)