Comments by Zoltán Zörgő (Top 200 by date)

I suppose no one can give you the answer you hope for. Just an advice: rewrite that procedure. To be able to do that, you need to know exactly what it does (more precisely, what it should do).

This is what you have tried? Really? Dude...
Do you know regualr expressions? It is quite easy with it.

What has this to do with SQL???

Not necessarily. The java (applet) code is interacting with the dom. It can also call JavaScript. See: https://docs.oracle.com/javase/tutorial/deployment/applet/invokingJavaScriptFromApplet.html
But in this case the statement is in the applet's code not in the web page itself. But the JavaScript statement is executed by the browser not by the java runtime. So the message I see is popped by the browser. And I am pretty sure this is my case. So I need the means to trace somehow this interaction between the applet and the browser. But I don't know how to do it.

This is what I tried at first. If you read my post properly you can see that this is not the case. IE developer toolbar's debugger would catch such an error. But there is none. It is for sure not in the source of the web page.

If there is no exact delimiter or any logic in splitting the input on syntactic way, you can't do it with regex. Please consult Noam Chomsky's formal language and grammar types for more theoretical approach. Altrought regexp is more complex than the theoretical regular expression related to type 3 grammars, your example looks belonging to an at leasty type 2 grammar.
See: https://en.wikipedia.org/wiki/Regular_expression

You should porvide a more comprehensive example with the expected result.

This is what I was thinking also. What I was hopeing for is that changing the internal "window" changes the title of the windows window also (or triggers something else on process or system level), and that could be hooked.
Well, I solved my original problem with polling. It is not as elegant as it could have been... :)

I am talking about hooking on external process, not a control in my application.

Yes, this looks like your homework. What should we do about it? If you want to have graduation in some IT related field, you better sit down and learn. Don't expect others to do your work - as they will take your future job too... except that this is what you want.
On the other hand lazy you have't given even the programming language :)

Hello
It would be helpful if you would post the scipted export of your tables (schema and data) so I can test without having to spend time on rewriting your environment. Please remember that I don't have your database.

But I think the update syntax is different if one needs alias. Try this:

UPDATE c
SET Tot_Dst =
(
SELECT SUM(TableA.Dst) FROM TableA a WHERE a.TrpM="OCT" AND a.VehN = c.VehN
)
FROM TableC c
WHERE c.VehN in (SELECT VehN from TableB)

compile
test
debug

You can use subquery in UPDATE statement. And you can use table aliases to link between WHERE clause in UPDATE and subquery. It is quite simple. But your formulation about the exact situation is not quite clear.

Nonsense. You can render html content to any graphical device. Please clarify your concrete needs!

It won't be "silent". Any modern built-in or regular webcam will lit up a tiny led during capture.
Anyway, you are trying to break into private sphere, even is you are trying to protect your own!

Well, than do what I suggested: check them. Yo don't take one or more into consideration.
Is the IIS you are trying to deploy to also on your development PC? If not, you need to prepare the database engine on the target environment too - and change these settings accordingly.

Thank you.
The only statement OP gave is that the database is not created by him/her. It still might be possible to add extra functionality, like a CLR UDF. It is a completely other thing than altering the schema - as that is much likely bound by the application above.

Question text is not related to the title...

visual studio 10 ?????

No wild guess, I have found the same.

As I see you are suing some GPIO class. Where is it from? Could you post a link to it?
On the other hand, you create those controllers without freeing them, I don't think it is wise to do so whatever class you are using.

Are using Windows 10? http://blogs.msdn.com/b/cdndevs/archive/2015/05/08/windows-10-how-to-use-iot-extension-for-raspberry-pi-2-part-1.aspx

Won't work. FileSystemWatcher has no event for "accessing" only for creation, deletion and modification.

You'r right. My fault.

virtual +5

Looks a good catch! +5

Right :)

Look promissing, but does not seem to execute. Try it in my sqlfiddle.

Thank you. I took some time to make it in sqlfiddle. But it is working at least.

Cound you give a sample input xml you are trying to filter?

Ok, so you are using the official ADO.Net driver.
And how exactly do you pass the parameter to the query? Do you get any error?

And what .net driver? Please post the link to the web page you have downloaded the driver from.

Which sqlite .net driver are you using?

You need a development time tool? What kind of "connection" are refering to?

Please note that MAC addresses are of no use in your case. Any MAC can be changed on any client these days. On the other hand, the MAC address works on layer 2. This means that if the client and the server are located on other LAN or VLAN, they do not have any clue about the MAC of the other party.
But IP security is neither a good solution. You might encounter address changes anytime. Just think about DHCP, which is common.
I suggest you investiagte a little bit the possibility of certificate based authentication. See: https://www.iis.net/configreference/system.webserver/security/authentication/clientcertificatemappingauthentication

Create a small and concise project for demonstrating your problem and paste the code here, please.
Sorry but your English is hard to decrypt.

That's the idea. +5

OK.
- what's the problem with IIS IP security?
- why the MAC?

you should be able if you refresh the page... but it looks that there are some bugs now on the page, so I think you will need to try a couple of minutes from now

Than why have you downvoted me?

Than what's the problem?

I don't know your skills and your experience in web development. Thus I can't tell you where you need to start catching up. The article I have linked is quite extensive and it is dealing with both client and server side - the later in PHP as you wanted. Read the article carefully. If you don't understand the code snippets there... than you are far from being able to do what you intend to do.
Here is what you will need to know (learn):
- the basics of how http works
- html classic and html5 specialities
- css
- php
- sql language and probably mysql administration
- some basic web server (probably apache) administration
So, what's your status?

I am pretty sure. Of course, you need some server side coding to pass recorded data between client and server, and to store it. And you need to add a pretty face to your client side. But it can be done.

You are welcome

1) If you look carefully, the result variable will hold all the http response body. You will need to extract the portion you need:
<textarea type="text" name="translatetext" style="width: 600px; height:250px;"/>Da followin procedure raps bout tha steps used ta bust data ta a server n' sh*t. This procedure is commonly used ta post data ta a Web page.translate=Tranzizzle Dis Shiznit</textarea>
If you don't want to parse the DOM, you can simply use RegExp for that. See updated answer.

Right, it is using only the printable subset of ASCII, but the goal with it was to make the message fit into the 7-bit ASCII.

Not really clear. Simply write your test code and try it.
Anyway: static fields are stored once, instance fields are stored per instance.

First answer these:
- ASP.NET Web Forms of MVC, or Web Pages?
- do you have the PDFs already in the database?
- if you want to create the PDFs yourself:
- from what?
- on the fly, or you can have stored version?
- could be good to generate pdf on client side?

can you connect with any client?

Thank you

I think you should close media player object to release media file.

Ok, and if you comment these rows:
axWindowsMediaPlayer1.URL = "C:\\Users\\oguzhan\\Desktop\\ddd.wav";
axWindowsMediaPlayer1.Ctlcontrols.play();
Are you sure, that the media player is releasing the file? You should call Close() after playing.

Yes, to be short.

Of course.
One suggestion: design your application so that the server side is emitting 99% JSON (or raw data, such as resources) and only 1% static xhtml. More precisely: make your php code not to emit any html at all.

All of them are javascript (bootsrap is actually more about styling, than functionality, but still). Bootstrap and angularjs are (can be) complementary. You can use them both, but with care: https://scotch.io/tutorials/how-to-correctly-use-bootstrapjs-and-angularjs-together. But you can write everything from scratch in plain old javascript, or jQuery. But I would

What does it mean "you can't"? What kind of error message do you get?

It depends on the authorization provider you are using. So, which one do you have in mind?

NAudio is complicated??? Wait to see the API...

"the function is called from code" how exactly (from view or from controller)?

thanks :)

Have you tried to sniff the http traffic?

I don't know which kind of setup you made, but I am sure it supports not only installing SQL Server Express named or default instance, but also attaching database to it during setup. User instances run like simple out of process components. If your application runs with enough rights, you can attach also from your code with T-SQL or SMO.

Sorry, I won't do your job.

No problem :)

Thank you.

Why do you think that we know what these extensions mean?

And....? What is stopping ypu in doing so? What have you tried so far?
Please improve your question.

You ar welcome. Try it! :)

This is a good documentation for NModbus: http://ftp.icpdas.com/pub/cd/8000cd/napdos/modbus/nmodbus/nmodbus_api_manual_v1.2_en.pdf. As you will see, you can't read input and holding registers in one shot. Simply because they are different functions of the modbus protocol.
Consider something like this too: http://aiona.at/ddoc/datasheet%20ewon-flexy_industrial-m2m-router.pdf

That makes a difference, as you can't guarantee continous access on internet side. You simply can't. Thus you need to add buffering with timestamps. I don't think the digi is enough for that. Those 8MB of RAM would last for a minute or two only (dpending on the number of records you need to take). For that you need something more performant. There are tools you might consider, but they could get more expensiver than the DIGI. Are you interested?

First of all: do you need a snapshot of your sensors at the time when PC is polling, or do you need to record all data with a constant frequency?

If IoT and cloud is in scope I don't suggest you to stich to Modbus/TCP on internet side. A REST API would be much-much better. The digi could handle all the Modbus RTU site, and you could get all data from the DIGI in one shot with a single http(s) call.

I got that.
Technically, yes. This is why you would need your digi to be Modbus/TCP slave, as I mentioned.
Still, you should consider other approaches too. If you give us more details about your environment, your business requirements, we could give you other advices.

Ok. Quite easy. What have you tried?

Show us your connection string

At least tell us which OS are you targeting...

How? By making it.

thank you

For nothing. And where are my 5 points? :)

See update

What RDBMS are you using? Not all implement recursive selection.

Thank you

Yes, but there is no such subexpression! [KNW] is from the first, [A-GI-K] is from the second. But these are two different branches.

A more complex example please. Paste several lines from a real source and highlight (using formatting for example) what you want to extract.

It is not quite clear. Please add some sample to your post before you get some unusable answers.

The expression is [KNW][0-9].*|A[A-GI-K].*|[KNW][A-FI-KM-OQ-Z].*|KP[06-9].*|KG[0-35-9].*|KG4[A-Z]|KG4[A-Z][A-Z][A-Z].
My code will transform it to: ^[KNW][0-9].*$|^A[A-GI-K].*$|^[KNW][A-FI-KM-OQ-Z].*$|^KP[06-9].*$|^KG[0-35-9].*$|^KG4[A-Z]$|^KG4[A-Z][A-Z][A-Z]$
Which means that any of these match:

[KNW][0-9].*
A[A-GI-K].*
[KNW][A-FI-KM-OQ-Z].*
KP[06-9].*
KG[0-35-9].*
KG4[A-Z]
KG4[A-Z][A-Z][A-Z]

We are good.

But NG3Y won't match any of them. A regex is either good or not good. But you can't fix it to match something that it should not.

If teh expression is wrong, that it is wrong. What do you expect from me?

Nobody? :(
It looks an issue on my side, as other can connect. Any idea about that? Am I missing a reference or something? I am using VS2013 Community Edition,. but SharpDevelop 5.1 is giving the same.

Test the expression in any regular expression tester.

Unfortunately, local variables can be enumerated but only as type. You would need to inject a debugger into your code.
Still, I am sure you don't really need this. But without knowing your intentions...

1) I can't calculate it for you as I don't know your record schema. Let's suppose you choose SQL Server. Create the database as you imagine it, and than look here
=50 devices*69 sensors*1 314 000 second per year*4 years*record size
+index size which I can't estimate as I don't know the indexes you need
2) Yes, you can theoretically go to the cloud. If the business you intend to support can accept this.
- Calculate the throughput you need. (Don't ask me how - think!)
- Can you guarantee this throughput all the time?
- What about the outages? How can you overcome them? Will you have a buffer?

I don't know your business. I don't know what devices do you intent to monitor. I don't know critical this reading are. I don't know what regulatory constraints you are facing. Thus I can't help you further.

Try it :)
Or read it:
https://msdn.microsoft.com/en-us/library/ff878091.aspx
General Remarks
Sequence numbers are generated outside the scope of the current transaction. They are consumed whether the transaction using the sequence number is committed or rolled back.

Yes, regex is a great tool.

Of course they are increasing capacity, but they have lots of backend and frontend servers - and they have developed their own data store engines for different purposes. And that one is not an RDBMS. See BigTable
But I don't think you should compare yourself with google.

Again: you have to choose the proper tool for your purposes. You might need to forget about what you already know and are used to. Mainstream is not always the good answer.

10GB is the limit for SQL Express only. On a 64bit system, you can have DBs as large as your filesystem supports. Still, on SQL Server 10 years of 1000 sensors with 1/s frequency will cost roughly 25TiB. Bud you can do your calculations yourself.
- Do you have that much space?
- What do you think how long it will take to calculate a MIN/MAX even on a small portion of this? I can tell you: hours, even with indexes... Why? Because an index on a timestamp field that is continuous does not help much...
- You can't ZIP a portion of a 25TiB database.
- How will you achieve data backup? If your extra large storage fails - you will loose everything. Can you afford that?
- But you have to think about the queries you will need to answer... what timespans will those cover?

Too vague.
"Classification" is a wide area. What is "web data" in your case?
Have you done some research on your own?
You can do parallelism in C# and this looks a good opportunity to use it. Still, I think, that CUDA is not for that. First of all because you restrict the usability of your application, and second, as I know CUDA is for numerical calculations - I doubt you will do such kind of classification. Still, look here: ManagedCUDA

The problem is the OR (|). You need to exclude partial match. This will do it:

var cs = from c in xml.Root.Elements("Countries001").Elements("item")
let exp = c.Attribute("PrefixList").Value
let re = new Regex(string.Format("^{0}$", exp.Replace("|","$|^")), RegexOptions.IgnoreCase)
where re.IsMatch("VP8VPC")
select c.Attribute("Country").Value;


You are welcome

Hello. Well, what you described here is a topic cleary for a TsDB, not any kind of RDBMS.
3) In general, inserting 1000 rows at once costs less (in terms of resources) as issuing 1000 individual inserts
4) You need to calculate the raw data size devices*device sensors*readings per year*years*record size. If you add indexes to the table, that will cost you space and performance. Still you will need indexes if you want to issue queries against such a table. SQL Server's transaction log management is an issue you have to deal with. It is not a text file, and it can grow really big.
5) If you choose any RDBMS, you should look for one that supports partitioning, or you need to implement some logic for partitioning on your own. Both SQL Server and MySQLsupports partitioning, but if you can't afford to drop partitions automatically, they won't fit your needs. INSTEAD OF triggers or stored procedures can be used for even more dynamic partitioning.

Still, this google for "Time series database" - and consider Linux for it.

As this looks an industrial application I would also consider using an OPC server like Kepware, with it's historian. It is highly optimized and dynamic especially for this use.

These could be also something to take a look at: TeaFiles, Deedle

That's even simpler.

var xml = XDocument.Load(@"http://www.hrdsoftwarellc.com/hrdxmlcountries/LogbookCountryDataEx.xml");

var cs = from c in xml.Root.Elements("Countries001").Elements("item")
let re = new Regex(string.Format("^{0}$",c.Attribute("PrefixList").Value), RegexOptions.IgnoreCase)
where re.IsMatch("OZ1BV")
select c.Attribute("Country").Value;

cs.Dump();

I hope you can wrap a class or at least a method around it yourself.
But have you noticed that UniqueCalls001.item elements already have country attribute?

Looks simple: concatenate the two arrays
var z = new int[x.Length + y.Length];
x.CopyTo(z, 0);
y.CopyTo(z, x.Length);

I don't get your problem: these PrefixList attributes contain valid regular expressions. I suppose, you would like to match them against UniqueCalls001.item.Callsign attributes.
Just do it. What you want exactly to achieve? Where are you stuck?

Theres is your answer: http://www.codeproject.com/Questions/1027220/Query-that-ignore-the-spaces?arn=4

Don't ask the same question multiple times - even reformulated!

Not an answer, it is comment to something.
By the way, if you are using .NET as you tagged your question, this comment makes no sense.

Well, if my answer helped you in the right direction, please upvote and accept it formally.

This is your decision.
Again: Tesseract is free. You don't need to pay for it. But it is much more complicated to use.
Of course, you could make your own OCR library, but I doubt you would be able. On the other hand this yould cost you many times the price of a commertial OCR library - as time is money.

So I suggest you estimate your skills and the value of your time. And than decide.

I don' tunderstand this comment. I don't have other idea but OCR.

Neither Tesseract, nor IFilter is.
You can try to do it without OCR - but you will fail if your PDFs are just some PDFs from enywhere. PDF is just for rendering, thus there is no guaranty that a text you see in Acrobat Reader is actually a single object in the internal structure. I have seen many interesting examples. Not speaking about the situation when your text is actually an image.

The only reliable approach is OCR. Are you willing to take this path?

Any progress?

Well... do it!

Are you running this script from command line or over a web server? If you are using a web server you have to consider that the web url will be different from the OS level path.

What is your PHP version?
Are you sure you need basename there?

__DIR__ should equal to dirname(__FILE__) and that is your scripts folder. But whí don't you print it to debug?

Just a question: why do you want to focus the element to read any property of it?

Just a note: I wasn't he one who downvoted you.
Although I can accept the general view of Philippe Mori, that this could let people see what's going on the desktop, this is the goal of it. A screen saver is just a screen saver. As long as it is the decision of the user to disable it or change the the timeout - it can be the decision of the user to have a transparent screensaver. Yes, of course, with a GPO the administrator can stop the user to disable the screensaver or alter the timeout - but can also stop him from changing the screensaver or from adding a new one. And that's the decision of the administrator - and not of Microsoft.
I think that the screen saver itself is not a security tool.

My goal is exactly what's described on the web page of the tool I have linked in my post: the application running on the workstation does not provide the feature to lock only the user interactions - so I need to add this from system side.

Your idea might work. Still it is not viable in my case, as the application is displaying the result of an industrial camera. I might not be able to capture at all or at the desired refresh rate what's on the original desktop. If it is an overlayed image, I would need a mirror driver to do that. But as long as it is not displayed, the mirror driver won't be useful either...

I think I need to abandon this direction...
Thank you trough for your post.

I am afraid you'r right. None of the solutions I have seen so far are implemented as screen savers. Still, I don't really get the security idea behind...

Yes, that might be the other direction. Still, it looks a little bit more complicated than just placing a global hook. The main issue would be Ctrl-Alt-Del. There is an approach for that too, but looks to be a hard way...

Simple and easy. That dialog is for building a connection string. Locate the string and than you will see how you can change it.

See second link:
ASP.NET includes application state primarily for compatibility with classic ASP so that it is easier to migrate existing applications to ASP.NET. It is recommended that you store data in static members of the application class instead of in the Application object. This increases performance because you can access a static variable faster than you can access an item in the Application dictionary.

Not quite correct: the Application instance is not guaranteed to be common, as there can be many instances at any point in time. But the Application class is common. Thus if you use static members, you can communicate between instances, altrought you need to care about thread-safety as you also noted.
see: http://www.codeproject.com/Articles/73728/ASP-NET-Application-and-Page-Life-Cycle and https://support2.microsoft.com/default.aspx?scid=kb;en-us;Q312607.

Still, using this for a chat application is not quite the best approach.

"google is there all our requirement question no there" neither are they here, as you haven't posted any.
Anyway, the answer you have got is not correct...

Yes, it looks like you can use this API.

And where do you pass Samples to the View?
Like return View(Samples);

1) Format your post!!!
2) I doubt that ViewBag.name is an IEnumerable...

1) Why Excel
2) What do you mean exactly by "comparing"... what do you want to see as result?

(LOL)
Please open all your windwos in your room, so that our knowledge accumulated in all those years of hard work can get to you and in your mind in a few seconds! Close your eyes and don't forget to concentrate on the white rabbit!
Sorry, I forgot to mention the red and the blue pill you will have to choose from.
But after that, anything is sooo much simpler. Just ask the operator to upload the handbook of VS... what am I saying... the whole CP in your mind and it's done.
Let's recap:
1) Follow the whitr rabbit
2) Don't be afraid, if your mouth vanishes.
3) Take the red pill
4) Don't forget to run - you'r not the choosen one, that one is Neo
5) Ask the operator to skip all those annoying training lessons, those are for the less talented ones
6) Try to jump over to that other building - you will fail (and fall), but that's no problem at all
7) Don't look after the girl in red - she is not your class
8) Now you are prepared for some higher class lessons in hacking... upload DOS in your operative memory
9) Great. Now ask the operator for Office user level operation guide... '95 will be just fine, that will be enough for ten years or so
10) We's almost there. No, kung-fu won't help - don't ask for that. Just eat that white thing. You will need all the proteines you can get.
11) Yes. Now ask the operator to upload MSDN and CP in your mind.
12) There you are. You know everything now. Happy encounter with Mr. Smith!

Besides the fact that it looks nonsense? :)
1) How does the scramble table structure looks like?
2) What RDBMS do you use?

Well, for wpf input validation you can use this nice approach: http://www.codeproject.com/Articles/15610/Regex-Validation-in-WPF.

well?

Don't you see, that you are negating the result before returning?

public static bool isFloatValue(string text)
{
Regex regex = new Regex(@"^\d*\.?\d?$");
return regex.IsMatch(text);
}

void Main()
{
Console.WriteLine(isFloatValue("12.5"));
Console.WriteLine(isFloatValue("12.5."));
Console.WriteLine(isFloatValue("12"));
Console.WriteLine(isFloatValue(".1"));
Console.WriteLine(isFloatValue("12."));
}

Will yield
True
False
True
True
True
As you wanted.

It is. Show me the code.
[^0-9.]+ means: anything that is not 0123456789.

It is correct, but try this:
@"^\d*\.?\d?$"
You were not using it correctly...

Why is this allowed, it has two decimals?
.12 -------------Allowed decimal in first place

The code you can use to ping them in parallel is on the link I have posted, but you will need to adapt it to get the addresses from a table and to store the result in it.

And no, I won't give you that code. Because this is not how it works here. Try to solve it on your own. And if you get struck, come back and ask for help in that concrete situation - starting a new topic.

Well, you can't do any web these days, and you can't really interact wiht google tools without JavaScript knowledge. Even more, you will need JQuery framework too. But C# and JavaScript can be learned in parallel. But you need to tell apart the common syntactical backend (both have C-based syntax), the OO way of thinking both apply - and the extensive differences between them. They are meant to work in different points in the ecosystem.

API key for what?

And what is the logic behind srno?
Is it this one:
100 for d001
101 for d002
And do you have other Doccodes than the ones that mach "dnnn" pattern?

Try following:
0) You can't do anything as long as it is not attached. You have detached the database.
1) When you log in to SSMS, be sure to have an other database (but not master) as current database when trying to get it back online.
2) If you still don't succeed, restart server instance and log in from command prompt (sqlcmd) so you can issue the set online command. You can use sqlcmd to attach database if you want, but I suppose SSMS will be able to attach.

See: http://www.codeproject.com/Questions/883686/load-xml-sql-server?arn=1

Let's clarify: you want to send SMS trough the Android phone attached to your laptop?

What do you mean by combine? You can simply OR two expressions.

There you have it: "rest of the text is trimmed due to evaluation restriction!" I don't know what exactly are you using but is is quite clear, that it is not properly licensed. What you are using is an evaluation version you will need to buy it.

This is not an answer. This is a comment to an answer. Please use proper widgets and remove this post.

Where did you see Javascript written?

Why not?
You have at least two possibilities depending on the usage of the database:
1) Normalized approach: add a new table for the URLs and add a foreign key reference to your current table. Just add the URLs in an 1:N relation.
2) Not normalized approach: use an nvarchar(MAX) field and put them all in a single field separated by whatever you like.
(and several more)
At the end your upper layer has to deal with it.

Good for you. Go for it!

Why? Do you intend to find all off the dead-code in .net?

What have you tried so far?

HTTP/HTTPS is working over TCP so you actually use TCP sockets. Still, the protocols you have listed are not on the same level of the TCP/IP or ISO/OSI stack, so if filtering is working on different layers, you might not get trough. Usign the yahoo example: the proxy will need to open a socket directly to the server and port after CONNECT. Simplest taken it needs to send everything after line that trough the socket - and it needs to send back what it gets. After that the communication between the server and the client should be transparent. You could also use SslStream.

On the other hand you might find this approach interesting: http://www.codeproject.com/Articles/93301/Implementing-a-Multithreaded-HTTP-HTTPS-Debugging.

Still, in this case the type of the communication can be detected as it will be standard one after leaving the proxy:
USER -> PROXY -> FILTER -> SERVER
In this case it should be more complex and not being standard at all. But to do that, you need an other party outside.
USER -> PROXY/OBFUSCATOR -> FILTER -> DEOBFUSCATOR -> SERVER

Your choice.
You need sockets. At this level, you have to tailor http headers (of course part of the original one is passed), thus you can't rely on any upper level class (HttpClient even less HttpWebRequest).
But if you expect your solution to work, you have to follow the RFC. As browsers will.

I still suggest you to consult the code I have linked. You need to use sockets at this level. But to have a proper knowledge about what exactly you need to take into account you have to read rfc2817.

Well, you don't need to copy paste. But you should understand what you have to do when client send CONNECT. You either read RFC carefully, or you check how others have done this. It is up to you. So far your code is not doing what it should. You can't fix your code as long as you are not aware what it should do. And that is preciselly defined in the RFC.

No, you should not send CONNECT to yahoo. "You" as proxy should tunnel between the client and yahoo server.

This c# proxy implementation might be also interesting for you: http://www.mentalis.org/soft/projects/proxy/

No, because it is intended to be porocessed by the proxy itself. Please read this RFC: https://www.ietf.org/rfc/rfc2817.txt. You need to provide the tunneling with your proxy. So you don't forward the CONNECT to the third party.

Still unclear.
You already have a proxy?
It is made by you or it is a ready made one?
If you use a browser with that proxy, it is working as expected?

I am asking this because CONNECT is a method not meant to be used directly as GET and POST. And PUT, DELETE (used for REST APIs in general) might not be supported or enabled by default on that proxy.

With other words while GET, POST, PUT, DELETE (and others) are meant to pass trough the proxy, CONNECT is meant for the proxy/tunnel itself. On the other hand not all proxies implement CONNECT.

https://social.microsoft.com/Forums/en-US/23fec75f-1dd4-4382-ae42-6e66a1e9d634/com-error-on-sync?forum=synclab... just a little bit of google...

Dude, what is XML material for you?

And why should we care what you need?

Approach 1: http://blog.tonercartridgedepot.com/2008/05/08/an-easy-way-to-count-pages-printed/[^]
Approach 2: https://gallery.technet.microsoft.com/scriptcenter/Script-to-generate-print-84bdcf69[^]
Approach 3: Monitor jobs in a printer queue (.NET)[^]
Approach 4: some printers support SNMP that can be used to retrieve print count for example.

You can use OCR for that. Actually only OCR.

Is the number of values in the string fixed?

Most unclear.

In general this is not a matter of coding or Sql Server operation. What connection possibility do you have from your remote locations to your server location?

1) What do you expect to achieve?
2) And what if your application is closed ungracefully (e.g. killed from task manager)?

Unclear

Thank you

Well?

I don't know what you are expericenting. I have copied the code in LinqPad and replaced the url with yours. And it works.

I have a feeling that you are using Include[^] in the wrong way. Do you neally need include?

What was your intention?

I got that part, but what have you tried?

"Not able to" is no error message.

Show me your code.

Why? If you like curl, use curl! Jump here: and see my answer.

Well, no problem, use internal buffer, and gather all those bytes you get. If your buffer ends with "ES ", strip the terminator, and convert the rest to number. Empty the buffer go ahead.

If this answer helped you (most) feel free to accept it formally.

Never ever send username-password in a GET query string!

My Windows has no ToDoList... :(

If you have found my answer of use, feel free to upvote and accept it formally.

No import setting will handle text formatted this way. He will need some regexp, but the requirements are unintelligible.

Sorry, but your english is quite impossible to understand.

Any progress?

Thank you.

Well, than feel free to upvote and accept my answer! :)

Check underlined parts:
CREATE TYPE dbo.dtExcel
AS TABLE
(
nameCustomer NVARCHAR(50),
nameItem NVARCHAR(50)
);
GO

CREATE TABLE Customers
(
nameCustomer NVARCHAR(50),
)
GO

CREATE PROCEDURE dbo.InsertMyDataTable
@dt AS dbo.dtExcel READONLY
AS
BEGIN
SET NOCOUNT ON;

insert into Customers (nameCustomer)
select DISTINCT nameCustomer from @dt as dt where NOT EXISTS (select nameCustomer from Customers where Customers.nameCustomer=dt.nameCustomer)
END
GO

And the error is...?

Well do the check you tried to do

dt is a datatable? What does this mean in your case? In your statement dt looks a regular sql table in the same database as Customers. If it is not, it won't work.

"d" is easy to test, as you can force GC to collect. If if write something to the output in the dispose method, you will see if it is called or not.
This could be useful: https://msdn.microsoft.com/en-us/library/system.object.finalize.aspx

Just to be clear: you can not run LINQ in any SQL Server, LINQ queries run in .NET. If you have C# or VB.NET or watever above, better use that approach. So, again: do you need a pure T-SQL solution or not?

So Maciej Los's LINQ solution is not an option for you. Right?

Well?

Yes, it works in that specific case, but you still need Descendants... so...

And what went wrong? What do you intend to achieve?

Think of GUI. All buttons, dropboxes, input fields, and so on are all controls. A form has only a list of controls, but you add those different objects to the controls list. To be able to do that, all those need to be descendants of control. If you create your special type of button, it will probably be a descendant of button. But it will still be a descendant of control too, thus could be added to the form's control list. The control defines common things like position, size, and of course click event. If you click on a form, the framework will walk trough the control list, and check which of them is affected by that click. And will cascade the event to that one. At that level it is indifferent which kind of control it is - it can be one predefined in the framework, but could be a special one made by you.

In general there is no need for Car myCar=new BMW() styled constructions. But indirectly such a list is made of such references.

What exactly would you like to see after parsing your input?

And what have you tried?