Comments by NightWizzard (Top 67 by date)

Thanks Richard - you're right. I confused this with old VB6/VBA - maybe I'm doing this job too much years. For Michel here the link to the .NET datatype summarize:
https://msdn.microsoft.com/en-us/library/s3f49ktz.aspx

Well, I don't know how you came to a total length of 813? If you calculate the byte count in memory, an Integer will take 2 bytes and each double 8 bytes. In your example above this will give a total of 829 bytes in memory: 640 for 80 doubles, 2 for the int and for each string it's length plus 10 bytes overhead. If you're writing a binary file, the record length should be 829. If you're writig a text file, the numeric parameters have to be converted to string - in this case the string length for each numerical value can differ. For example: setting the Integer to 1000 still needs 2 bytes in memory for the Integer but the string will have a length of 4 plus the 10 bytes overhead = 14!!
In VB.NET you also can try to use either the length property:
size = Aliment.Length
or this method:
Marshal.SizeOf(Aliment)
Hope this will help you to solve the problem - good luck!

You'll get a lot of samples how to solve this problem if you google for
sharepoint upload 2Mb

e.g.:
Upload large files sample add-in for SharePoint

I'm glad you've found the answer to solve this problem. Yes, depending on the way the database layer is designed, it may cause those deadlocks. Maybe you should change from SQL Client library to Entity Framework Code First? It's simple to integrate and handles connections automatically. With option
MultipleActiveResultSets=True
within the connection string you may have simultaneous access for multiple concurrent users.

There are several conditions where your code may fail with the mentioned error - e.g. the last char in a token is a & or a =. You should check that each token has a minimum length of 3 and position of the = is not in first or last position before parsing it.

If you bind a grid to a database table (or query result) you can't insert rows directly to the grid - do the neccessary operations direczly at the database table and the grid will update automatically.

Normally a binding doesn't need to be re-binded or refreshed - that's the cause of a binding. After INSERT operation the bound control should update automatically. If not, check the criteria of the SELECT command - maybe you newly inserted data simply doesn't match...?

OK, so it's seems to be clear that there is a deadlock situation if 2 users login at the same time because of the SQL transactions that are started then. As you can read at Microsoft's website, there is no way to avoid deadlocks completely but you can reduce the risk for that by some tipps you can find here:
https://subhrosaha.wordpress.com/2010/06/02/sql-server-avoiding-deadlocks/
or here:
http://stackoverflow.com/questions/40585374/preventing-deadlocks-in-sql-server

There are a lot more matches if you google for
t-sql avoid prevent deadlock
Hope you'll find a solution for your problem - good luck again!

Yes, look at your code: you assign the resut of a LINQ query to t (which contains of 2 fields: ID and Firstname). This NOT(!) a string but you handle it as a string the way you assign it to the Viewbag and how passing it to the editor. To show the Firstname, you should pass only that part of the LINQ result to the viewbag.

That error usually appears when you forgot the parenthesis behind a method e.g.:
object.toString
instead of
object.toString()
Check if you're using correct C# syntax and maybe have a look at the examples here:
http://www.tutorialsteacher.com/mvc/htmlhelper-editor-editorfor

You have to put the header names the same way you put the data into the cells. Have a closer look to your nested loops and try to imagine, which cells are affected in each step - there's the error! If you use my example with the Range object, you may recognize, what is wrong with your code.

Looks as if you are mixing parts of code from different examples or why you declare

MSProject.Project proj = projApp.ActiveProject;

first and later

currProject = MSProjectApp.ActiveProject;

this doesn't make sense because MSProjectApp isn't declared/initialized anywhere while the active project is derived twice from different sources. Think you should have a deeper look at object handling before programming this task.

If you try to replace the column headers A, B, C,....(and so forth): you can't. Put your headers in the first row (A1, B1...) and put your data in the following rows.

I can't see any line of code where MSProjectApp is either assigned to a running instance of MS Project or launched by creating a new instance....??

I'm glad I could help ;-)

Maybe the Windows account, you Webservice is running in has no permission to access the DLL?

OK, I didn't assume that the occuring values may lead to same results from differing values. In this case you have to use any other numeric trick that leads to identically results where the order of the values in col1 and col2 does no matter. You may use a calculated column that concatenates the 2 values into a varchar, beginning with the lower value, convert the resulting string back to int as the result. In this case, the value order does no matter and you have a unique value for each combination that can be used for a DISTINCT query. Example for the formula of the calculated column:
CAST(CASE WHEN (col1 < col2) THEN CAST(col1 AS varchar)) + CAST(col2 AS varchar)) ELSE CAST(col2 AS varchar)) + CAST(col1 AS varchar)) AS int

Maybe one of your parameter values contains a comma and the resulting SQL will lead to something that looks like an additional parameter? In this case ensure, that decimal points in numerical parameters are represented by a point instead of comma.

Think I understand your problem now. In this case and because you can't put the min and max aggregates into a single SELECT statement I would use a stored procedure (or table function) that exepcts the table name and the name of the column containing the age as parameters and uses sp_executesql function to create a dynamic sql statement as shown in my solution above to return the required data. Here you can find all informations how to use sp_executesql: https://msdn.microsoft.com/de-de/library/ms188001.aspx

Sorry, but from your improvement I can't understand from which tables you want to read, what age columns they contain and how the listview event will be provided with the data.

I don't know your datamodel, so it's difficult to push you to the right direction. If that means, that you have to gather the min and max age from more than one table you might make use of the UNION statement to concatenate the table sources. If it means that you have to get the min max ages for changing tables from their individually related tables you should create the SQL commands dynamically with the use of variables. Hope that helps...? Otherwise it would be a good idea to improve your question with a description of all tables you want to access.

Time is a part of a datetime that you have to extract. Sorry, but if you are not able to adapt the samples, you shouldn't deal with programming. I won't do the job for you.

The samples demonstrate how to access all single parts (incl. hours, minutes and seconds) from the datetime string. Simply extract the ones you're needing.

Looks as if you tried to access Outlook (which is COM = unmanged code) from managed code without the use of an interop...?

Oops...you're right! Typed it quick and dirty :O)

Although all subqueries will return at least 1 record if executed separately there might no be a record that fullfills the main where clause in conjunction with all 3 subqueries. Did you check your data for this?
BTW: if you replace SELECT * with SELECT 1 in your subqueries your query will need less memory to execute and it will produce the same result.

You won't learn anything if someone else does your job. Look here for more about UNION: https://msdn.microsoft.com/de-de/library/ms180026.aspx

Sorry, the link didn't work - here again the details for DATEPART:
https://msdn.microsoft.com/de-de/library/ms174420.aspx

Did you allow mailing with SP_CONFIGURE and GRANTed user TESTPROFILE to send mails?

Think there may be some bottlenecks. First of all: did you take in account that all of your concurrent requests are using the same network/internet connection that have to transport all the incoming answers? There may be package collisions at Ethernet protcol level which leads to package lost and therfore to timeouts. Second: internet connections and answer times depend on several conditions (how busy is the server you're sending a request to, how stable is the current connection route that will include some other servers that may be busy and how fast is your own current internet connection). This all may lead into a timeout for any single server connection you established. The Ping uses a different protocol layer and may return immediately while the SQL request will take more time.

Maybe the problem isn't the data type but invalid or empty values within your import data?

Did you try a simple
$name = $_POST['name'];
var_dump will display a structure and can't be used to assign it's output to a variable.

You call the PHP script via AJAX PUT or GET method - google for examples, there are a lot showing how to do this. One example will be found here: https://www.quora.com/How-do-I-get-variables-from-PHP-through-AJAX

An Outlook Addin will be loaded and will run within the session of a runnning Outlook instance. It needs to be installed as Addin and you can't start it from another application without Outlook.

Please have a look here:
https://msdn.microsoft.com/de-de/library/9k985bc9%28v=vs.110%29.aspx
Actually you can turn on and off each method like (pause, continue, etc.) via class properties instead of removing the interfaces from code. All about creating services can be found at:
https://msdn.microsoft.com/de-de/library/zt39148a%28v=vs.110%29.aspx

It has nothing to do with the CSV file - you have to convert each array member of $emapData separately instead of passing the whole array at once.

There is no option to grey out the dropdown - you have to remove or disable each method separetely - look at the class that represents the service interface. The VS template provides empty procedures for each of the 4 methods.

I think the line
$emapData = mb_convert_encoding($emapData, "EUC-JP", "auto");
is the problem. You pass $emapData as the first parameter which is an array, but the function expects a single string as first parameter! So the result will be undefined and can't be filled into the SQL query string.

Each windows service have to implement a standard interface with the default methods (Visual Studio provides a template - have a look there). If you don't want to provide a certain method, you can either remove it there or don't enter code to these procedures.

See microsoft documentation for T-SQL, for example:
https://technet.microsoft.com/en-us/library/aa214485%28v=sql.80%29.aspx
or the codeprojecr article:
http://www.codeproject.com/Articles/167399/Using-Table-Valued-Functions-in-SQL-Server

Error 400 tells you, that your request doesn't match the expected format. Without knowing the interface specification nobody can tell you what's wrong with your code. Use WDSL call to enlist the webservice interface and check if you have provided the correct parameters for the called function and that it really expects data in json format.

How should anybody answer your question without knowing which database you're using?

I guess the simple reason is, that you assigned the Button2_Click procedure tho the button click event without any parameters but the procedure itself expects sender and EventArgs objects (like a desktop application) which are not passed to it. Remove the parameters from your CS procedure and it will work.

The column names you use when reading contents to the textboxes doesn't match with the column names of the table. Change UpStreamLevel to UpLevel and TotalDischarge to Discharge and it should work.

I agree with CHill60: can't find any code where datFile array is changed. Calling the method SaveDat would fetch the changed lines from datagridview, concatenate them to a string and write this content to a file - but it's called nowhere..??

Think you'll need a dBase library to do that - but I'm afraid you won't find any that can be used with today's technologies. It's too old and no longer supported.

You can do a reverse loop through all directories and their files using the file system objects and read the content of each file into a string variable in one step (read all bytes). Then use the IndexOf method to check for the searched string.

The macro recorder is already part of each ms office program and produces exactly the code sample you need. Have a look to the available menus.

You can use the macro recorder while doing it manually to see, how Microsoft would solve the problem :-)

You can use the macro recorder while doing it manually to see, how Microsoft would nsolve the problem :-)

Sorry, no more suggestions except to read the documentation carefully as recommended within the error message (http://go.microsoft.com/fwlink/?LinkId=65455).

Not a webpage but a webservice. If you want the UWP app to be used from anywhere, this is neccessary and PHP would be more simple and quicker, but if your UWP is for personal/local use only, it would be more simple to use the VS webservice and IIS than to install PHP and get it running.

Now you're mentioned it...right: VS doesn't provide db libraries for UWP. So there's only one way left: you have to create a web service to access the database. You may create one with VS (it provides solution templates for this) or you can do it with PHP very simply.

Hope the solution below helps. Otherwise it would be difficult to help you if you even don't know what you're doing and what library you're using. Maybe best idea is to use the server dialog of Visual Studio to create the connection.

To get an answer you have to be more specific. Please explain what exactly your problem is: do you get any error or don't you know how to connect from UWP? Where is your SQL server located: somewhere in the web or local host? Which library do you use: ADO.NET, Entity Framework, Linq?

Same way as before - print command is sent by code. The only difference is that the IE window is at a location outside the screen's display area (and therefore invisible to the user).

Maybe localhost is the problem? I would prefer to set the corect url of the server where the service is executed and the schema is located.

No idea why IE is shown only for non-admins but how about moving the IE window out of the display area of the screen instead of setting visible property to false?

Sorry, I don't understand what your problem is or what you want to do...?? And why you first add results to a combo and then from combo to Richtextbox? Why don't put the results directly to the Richtextbox?

Yeah, seems to be a bit uncomfortable on first sight, but works fine. You can access nearly all informations about mails and other items, that aren't provided by high-level API. I started with an Outlook addin some years ago and made use of PA's for several infos like SMTP formated addresses of all mail recipients and so on. MS API's sometimes appear worse but wait until you face API's of other software (e.g. Tobit) and you'll praise it! :-)

Thanks Sergey, you're right and that's what I meant but couldn't find the right word that moment.

look here: http://stackoverflow.com/questions/13802587/how-convert-string-hhmmss-181902-to-javascript-date-object