Comments by Duncan Edwards Jones (Top 132 by date)

See this Microsoft documentation on the function DrawString that you ar eusing to print:- https://msdn.microsoft.com/en-us/library/21kdfbzs(v=vs.110).aspx

You are using PadRight to align text.
Don't use that.

Use StringAlignment.

So - looks like "both configurable" then.

What user is the windows service running as - and does that user have access to the printer and file system?

Either turn the tweet into one sentence or get the multiple sentiments and perform some rule to decide how to aggregate them.

It seems NLP is splitting the tweet into sentences. What does it give if you replace the full stops with commas?

Ok - there are actually a number of things you need to do so first I suggest reading this article:- http://www.codeproject.com/Articles/27404/An-absolute-beginner-s-guide-to-printing-in-NET

Then you need an "If Currentpage = 0 Then" block that prints the header and footer bit, and also makes the area to print the list in smaller.

"Subscription" is about paying (and setting payment limits) only.

"Administrator" is about creating/deleting etc. - so if you are administrator you can add an application from the portal. Press the [+] on the applications and follow that wizard.

Do you want the header and footer on each page of the print, or just the first one?

I think you might need FILE_SHARE_READ access to read the device serial number?

Are you using the algorithm specified by the target API and the decryption key provided by them?

If you have found the answer, please post it here so others may also find it when they google your question...

Do you have a data contract attribute on the Defination class?

As an analogy - compare a bus (scale up) with many taxis (scale out).

For a given load a bus is cheaper to run but everyone on the bus has to wait for everyone else on the bus.

Taxis are more expensive but everyone gets to their destination as quick as possible irregardless of other people's destinations.

Then consider the difference between adding an extra 10 seats to a bus vs adding an extra 5 taxis. That is where the real reason for scale-out comes from!

Reason for my vote of 5 \n Excellent checklist

Set the printer status to paused until the whole job is in the spooler - there is also a flag in the advanced settings to prevent printing before the entire file is spooled.

In that case - I recommend you use scale out for new build from the start (unless there is a real non-parallel business situation) and use scale up when your architecture is already built around a monolithic design because it is really difficult to parallelise a design that wasn't built to be parrallelised.

is this actually a question? Maybe add some explanation of why you do this and post it up as a tip?

I would second the recommendation to use PrintDocument yourself - that way you get full programmatic control over how the output looks.

Have a look at: http://www.codeproject.com/Articles/27404/An-absolute-beginner-s-guide-to-printing-in-NET to start with.

You need to do a multiple-step process whereby: first you create a copy of the table structure but with the identity field, then you set IDENTITY INSERT ON for the table, then you copy the data from the source table and finally rename source and target tables so you are left with your new table having the identity field.

Why are you using HTML to do the print part for a windows forms application?

There are lots of good examples for printing data grids here that don't use HTML - I think that is a better route to go down?

Thank you - that helped

The VB.NET resulting code is therefore:

Private Shared Function ToReturnStatement(ByVal valueToReturn As IdentityGroupClassification) As CodeStatement

Dim expression As CodeExpression = Nothing
Dim EvaluationResultExpression As CodeExpression = New CodeTypeReferenceExpression("EvaluationResult")
If (valueToReturn = IdentityGroupClassification.Exclude) Then
'EvaluationResult.Exclude
expression = New CodeFieldReferenceExpression(EvaluationResultExpression, "Exclude")
ElseIf (valueToReturn = IdentityGroupClassification.Include) Then
'EvaluationResult.Include
expression = New CodeFieldReferenceExpression(EvaluationResultExpression, "Include")
Else
'EvaluationResult.Unchanged
expression = New CodeFieldReferenceExpression(EvaluationResultExpression, "Unchanged")
End If
If (expression IsNot Nothing) Then
Return New CodeMethodReturnStatement(expression)
Else
Return New CodeMethodReturnStatement()
End If


End Function

edited as above.
(You can't include a table name in an alias...) therefore "As [AD].AdsDesc " is not allowed.

Therefore

SELECT AD.[AdsID],
AD.[Country],
AD.[State],
AD.[City],
AD.[AdsTit],
SUBSTRING([AD.AdsDesc],1,50) as AdsDesc,
AD.[AdsPrice],
AD.[Section],
AD.[Category],
AD.[Img1],
AD.[AdsDate],
IUS.[approv]
FROM [ads] as AD JOIN UserInfo as IUS
ON AD.UID = IUS.UID
WHERE AD.[Country] = @Location
AND IUS.[approv]='Y'
ORDER BY AD.[AdsDate] DESC";

I don't think there is any limit - are you sure there was no error (duplicate key insert, missing mandatory field etc.) when doing the import?

An executable is a PE file ( see http://www.codeproject.com/Articles/4089/Inside-the-executable-an-introduction-to-the-Porta )

I missed braces - try with them..

I don't see where you are setting the current principal for the running thread (although this may be elsewhere in the code)...

See: https://msdn.microsoft.com/en-us/library/system.threading.thread.currentprincipal(v=vs.100).aspx

Does the menu "Build -> Transform All T4 Templates" do any magic for you?

1) Is there any error logged in the event viewer (run "eventvwr.exe" on the server)?

2) Are you closing down your application cleanly or killing it with task manager?

3) What 3rd party tools?

There's probably a good explanation on the reason this happens to do with the window message handler that every UI thread has to have and how it keeps the UI responsive, but the takeaway message is "Don't dig the garden in your dancing shoes" (i.e. Don't do heavy work in the UI thread)

What happens if you use a BackgroundThreadWorker to run it in a non UI thread from the windows form?

You need to set a breakpoint on "Public SnippetsFolder As String = Application.StartupPath & "\Snippets\"" and step through to see what line the code stops on

I would suggest you have a data quality issue if these are in fact the same company?

OK - currently your data in the data grid is there by Data Bindiing - this type of binding can also be done for all other windows controls (text boxes, list etc.) .. see https://msdn.microsoft.com/en-us/library/vstudio/c8aebh9k(v=vs.100).aspx for example.

Windows Forms or WPF (or Silverlight?)

Printed form, or on-screen type of form?

If the type manager can't derive it (like here where you have no explicit parameters of TEntity) you can explicitly state it. e.g. to get a guery result of Customer:-

var test = LINQDynamic<customer>.GetQueryResult();

You should also make the return type of GetQueryResult be TEntity rather than object.

public class LINQDynamic<tentity> where TEntity: class
{

public static TEntity GetQueryResult(object pkKey,TEntity type, params object[] pkKeys)
{

//TODO
}

Put a breakpoint on the third line. Is PrintDocument1 initialised when it gets there (I think it is not)

Where is "PrintDocument1" declared or initialised?

What is the data type of the field in the database in which you are saving the record - is it a Boolean or a character field?

If there was a way to alter an executable so the AV didn't block it then the virus writers would do that too - so obviously there isn't. You need to configure your AV to allow that file through...

OK - so it can never equal "Nothing". Therefore you need to check if the field is null and only if not then try and set the value. Do what F-ES Sitecore suggested.

Suggest you add that question to the comments article itself so the article author gets it.

Not as far as I can see ( http://www.bing.com/search?q=sql+server+split+string )

Where do you want this image displayed?

Yes - but "foreach" always starts at the first row. You need to use an integer row index (initialised in the _BeginPrint) instead.

No - I obviously needed to clarify my question. I don't want to do anything with IDisposable - I just want to do what it does in the IDE.

When you are in Visual Studio with a VB class open and you type "Implements IDisposable [return]" it pastes in all that stuff above.

if you type in "Implements IDuncansInterfaceThing" it only pastes in the method/property signatures - no comments or other boilerplate.

(Maybe it is not possible for me to do)

Yes - the code snippet that automatically triggers when someone implements my interface. (Like what IDisposable does)

Why are you creating the whole file in memory before writing it? Maybe use a Stream and write it one line at a time to the file...If you want it to be cancellable then you need to use WriteAsync - see https://msdn.microsoft.com/en-us/library/hh137902(v=vs.110).aspx

Ah - I meant Modelling.Diagrams.TextField - https://msdn.microsoft.com/en-us/library/microsoft.visualstudio.modeling.diagrams.textfield.aspx - there doesn't seem to be a NoteField equivalent.

What do you have as the group "keep together" settings on the report definition? (See http://stackoverflow.com/questions/9894676/crystal-reports-keep-together)

This looks like a scenario for Azure Webjobs - see https://azure.microsoft.com/en-us/documentation/articles/web-sites-create-web-jobs/

Does the receiving side of the web request already exist - i.e. is the external server set up and has some URL that you need to send the file to?

Do you mean how to structure code files in a folder structure (and classes in namespaces) or do you mean how to format the code within each file?

The main thing to bear in mind when writing code is: do the thing that makes it easiest for a human to read.

What type of database? (MS SQL Server, Oracle, Access, Sybase??)

Not better than the Java docs themselves:- http://docs.oracle.com/javase/tutorial/java/IandI/index.html

In what context? Do you mean "sounds through a microphone" or "randomness in a data set"?

if your current picture is not the last one, set e.HasMorePages = True

Were you recently in a room where a number of people were facing in one direction writing things whilst one person was facing towards them talking?

That person is probably the one who you should ask for help on this.

Basically (very simplified explanation) the Task syntax explains what you want the program to do whereas the Thread syntax explains how you want it to do it...and also the async/await keywords are part of that.

Do you mean like clippy or that (strange) dog that came with Windows XP?

The Microsoft Agent (http://www.microsoft.com/PRODUCTS/msagent/main.aspx) product is discontinued so really this might not be a good use of your time?

What is the data type of the (in) parameter of the stored procedure - shouldn't it match the column data type that is being returned?

What is the "dmp printer" - does it use a standard windows printer driver?

If you aren't going to show it, why have a form at all - why not just have a method that takes your selected data row and prints it?

Reason for my vote of 4 \n Useful - lets the compiler lend a hand..

Not in the detail - how is scrambling/unscrambling different to encryption/unencryption?

Perhaps you could go one step up and describe what you are trying to achieve and why?

Do you have any existing programming language experience (i.e. how do I convert from language x to c#) or are you looking to start programming from scratch using C#?

1) SQLEXPRESS is (typically) a local database so if you want your application to run from a server then that server will need to have the database installed on it.

2) Using integrated security means that whatever user/account is running the code needs to have access to the database. This will be a system account so you need to give that account access.

1) Can you post the actual text of the error message?

2) Can the remote machine see "MNT-PC\SQLEXPRESS" ?

and does the path exist on the server?

(If not and you intend "request.Method = WebRequestMethods.Ftp.MakeDirectory;" to do that, don't forget you have to issue the request with "FtpWebResponse response = (FtpWebResponse)request.GetResponse();" before you continue...)

Cool - I didn't know that.

The real solution is probably to not hard-code SQL statements in C# but rather use a data access layer...

I think that this is not possible. Can you imagine how bad spam could be if every time you visited a web page it printed something out?

Why are you catching the exception and not doing anything with it? Surely if something goes wrong you want to be told about it?

I've updated my idea a bit - mapReduce is probably overkill

My guess would be that this is probably for research/training purposes, not primary care...

Yes - it is going to need manual oversight/intervention. What sort of volume of records are you talking - 10s, or 1000s?

Why are you storing a date in an NVarchar column - why not use the appropriate data type?

Reason for my vote of 4 \n Tidy explanation

Are you using the above referenced spool file viewer code to view the spool file?

Is the System.Data.Linq DLL listed in the references dialog box?

No indeed - but the event is only raised under certain circumstances and I want to test that - i.e. circumstances not met, no event was raised. Circumstances met, event was raised.

I am testing the class in isolation.

I think you need to compare the fonts used in the SSRS template with the fonts installed on the server - I think it is very unlikely the server itself is deciding to use a different font if the expected font is available on the server...however it is also possible that some settings in the PDF writer are different between the two servers?

I'd imagine the report template uses a font that is not installed on server B and it is falling back on one of the other two fonts?

The performance counter classes (linked above) can be used to read performance counters. I'd suggest you do that, then pass it across to the ASP.NET application to display. If you are using an MVC type of architecture then your model needs to be populated from the performance counters.

Performance data from the web page server or the client?

..but that is the whole point - you can't call the code externally, you have to convince the third party application to call it.

To use a metaphor - your "dll injection" is like you posted a note through your neighbours door. Now for that note to have an effect, you have to convince him/her to read it - you can't read it to him outside the door.

We need a great deal more information:-
1) What did you write the DLL in (is it .NET or C/C++)
2) What is the third party application
3) Does the third party application have any plug-in model

Bottom line is that you can't force your code into another application and convince it to run it if the application was not designed with that in mind - you can probably understand why that is the case?

Check that the property INDEXVALUE is actually being mapped to the field of the same name in your model?

Try stepping through the code in debug mode - does it get to the "WritePrinter" line?

Ah - if you aren't allowed to install an exe (which makes sense, I suppose) then you are probably going to have to add a method to your web server that does the work. You can then trigger that by sending an HTTP command by a scheduled task - from the web panel or from some outside scheduled app.

As mentioned below you also need to find out if you can send emails from the shared server.

Are you allowed to install scheduled tasks on the shared server?

Reason for my vote of 5 \n Smart - I like it...

It does support Win7 - that's what I use.
See http://msdn.microsoft.com/en-us/library/windows/desktop/dd145082(v=vs.85).aspx

Make sure in pPrinter you are passing the new status value, not a pointer to the new status value...

So - when your printer has printed a line you want the paper to move back so the next line will go over the top of the current line?

1) How are you doing the printing at the moment - by .NET PrintDocument or by direct printer commands? Please put some code for us to see.

2) What is the make and model of the printer?

It is free but restrictions exist on "high volume" services. You can't use this to just cycle through all the words that exist to see if they are registered, for example. Other "whois" servers also exist - each national top level domain registrar has them.

object obj;

This object never gets assigned to anything. It is like you have got a fresh sheet of paper from the notepad and handed it to someone to read - but they can't because you have not written anything on it.

Are you passing bmpData.Scan0 by value, not by reference? (i.e. the address held in Scan0, not the address of the variable Scan0)?

But a date is not a varchar - if you have a date and the parameter type on the table/database is a date don't convert it back and forth through a string.

Have you copied your batch file (C:\New.bat) onto the server(s) that this process is running on?

Excellent thanks - I had completely forgotten the new() constraint.. many minds make code work :-)

* What kind of form is this - a PDF or something internal to your own application?
* How are save and print triggered - is it menu items you have coded?

Do you want this header and footer to appear on the form itself (on screen) or on a printed document that comes from the form?

This loop :-

While True
Dim client As New ClientConnection(TCPListener.AcceptTcpClient)
End While

Doesn't seem to do anything with the received client connection. Is there something in the constructor that does or..?

It does if you set it to true - see updated code sample.

is it that the form's mouse methods are not fired when you are over the picture box?

Reason for my vote of 4 \n Nice tip - thanks

In that case it is looking good. I tend to specify the type of the record key as well as the record type rather than passing an object (e.g. http://www.codeproject.com/Reference/731015/The-repository-pattern-in-VB-Net ) .. but this is a personal style thing.

GetDescription() only ever returns the description of the first item in the repository - is this what you intend?

Wow - never heard of that - what is your subscription/billing status? (i.e. your account hasn't expired?)

What does the status say on the Windows Azure console?

Is the CPU being read from _within_ that process?
If so, maybe it can only be read when that process has (some of the) the CPU and so it will therefore not reflect the true reading...?

Is your display on the performance monitor application set to "Current" or "Average" and does the CounterType of your code performance counter match that?

Can you post your API declaration code - CreateFile is definitely a member of the Kernel32 exports.. http://msdn.microsoft.com/en-us/library/windows/desktop/aa363858(v=vs.85).aspx

yeah - WCF it is... corrected.

That would be extremely useful - it is to go in this:- http://www.codeproject.com/Articles/714742/CQRS-on-Windows-Azure-Event-sourcing - so that my events getting saved don't have to be Serializable()...

No - encryption and compression not going to be needed.
Speed of access might be... but I'm not going to read (or look for) just the one property so the name-value part doesn't need to be indexed.

Aha - maybe BinaryFormatter is what I'm looking for, yes.

Looking to store these as a set of name-value pairs in a database table...

Ah - I didn't explain myself very well.
I want to serialise to/from a dictionary instead of to/from XML.
The class being serialized doesn't have any dictionaries in it.

Yes - neither this class nor the inherited class have a constructor without parameters.

<pre lang="vb">
Public Sub New(ByVal currencyFrom As AggregateIdentity.CurrencyAggregateIdentity.ISO_3Digit_Currency,
ByVal currencyTo As AggregateIdentity.CurrencyAggregateIdentity.ISO_3Digit_Currency,
ByVal fxRate As Decimal,
ByVal rateDate As Date,
ByVal derived As Boolean)
' Set the FX rate aggregate identifier
MyBase.New(currencyFrom, currencyTo)
' and set the other properties
m_rate = fxRate
m_pricedate = rateDate
m_derived = derived
End Sub
</pre>

Currently I am saving it to XML then reading the XML into the name/value dictionary and vice versa but it is very clumsy...

Basically yes - the System.Runtime.Serialization DataContractSerializer can take the above and turn it to XML and then recreate it from that XML.

..but how does it create the object it is deserializing given no public constructor it can use??