Posts by Felipe Grossi • 119 points
18 posts
-
0
votes3
answers87
viewsA: Put date in American format with substring
Use the Datetime.Parseexact method to convert to datetime. Following example: DateTime dataConvertida = DateTime.ParseExact("22012018", "ddMMyyyy", CultureInfo.InvariantCulture,…
c#answered Felipe Grossi 119 -
0
votes1
answer32
viewsA: Problem when changing backgronud color of expressions of a richTextBox
I couldn’t find the "off" mark flagAt in your code. Try to change this if, want I believe you will succeed. if (text.Length < tam || text.Length == 0) { //se algum caractere foi apagado, reseta…
-
-1
votes1
answer227
viewsA: Select records between two dates with pre-established minute intervals
Insert the following clause into the WHERE: DATEPART(MINUTE,[CAMPO DATA]) % 10 < 5 Explaining what is being done: I am isolating last digit of the minute of your datetime field and checking…
sqlanswered Felipe Grossi 119 -
0
votes1
answer50
viewsA: SQL grouping information
Test the following code: SELECT produto,mat_gestor,uf_produto,max(tipo_campanha),max(dt_campanha) FROM TB_CADPRECO WHERE MAT_GESTOR = 123 AND UF_PRODUTO LIKE 'PR' AND ( (TIPO_CAMPANHA = 5 AND…
-
0
votes2
answers284
viewsA: VS 2015 SOAP does not work, but in Soapui works normal
Try the following steps: Disable all anti-viruses (including Windows Defender) Disable any machine firewall rule Make sure you can reach the web service via browser, otherwise this code will not…
-
1
votes1
answer51
viewsA: How to organise data
I understand that you would have a JOB that would run x in x time to check if it was running a task. What would this interval be? If it’s longer than a minute, without thinking too much, I’ll tell…
-
1
votes1
answer311
viewsA: How to format a field with ASP.NET Webforms C#
You can leave the property in Textbox onkeypress="return isNumberKey(event)" and in your javascript file (or even on screen) the following function: function isNumberKey(evt) { var charCode =…
-
0
votes1
answer152
viewsA: Filesystemwatcher - How to catch the user who modified C#
In the title you say user you changed, but in the question you say the user you accessed. If you want the user you accessed, you won’t be able to by the file properties. You will probably have to…
c#answered Felipe Grossi 119 -
1
votes2
answers674
viewsA: SELECT with repeated field
Complementing the response with group by, you need to indicate in repeated case, which will be the chosen record to be displayed. Can be with MIN (smaller), MAX (larger), SUM (sum), AVG (average),…
sql-serveranswered Felipe Grossi 119 -
1
votes1
answer133
viewsA: Asp . Empty Net Dropdownlist After Form Submit
What happens is that your new item is not in the viewstate control, so when the . net "reassembles" your page it loses value. A good option would be to store this value for example in a hidden field…
-
0
votes1
answer312
viewsA: Assembly.Load error Could not load file or Assembly 'X' or one of its dependencies. The system cannot find the file specified
Verify that the Apppool user has access to this DLL and its dependencies. If you have, check that the DLL path specified in the Load method is correct. One possible error is the versions of the Dlls…
c#answered Felipe Grossi 119 -
1
votes2
answers53
viewsA: Doubt about Querys
rLinhares try as follows: Put in each sub-select’s Where the clause AND ID_Caso = A.ID_Caso to make the filter correctly. For rounding, you can use the FLOOR function (always round down) as follows:…
-
1
votes1
answer637
viewsA: Save to Arduine Memory EEPROM
The question has a while, but I will answer to help anyone who finds this topic. Since the amount of data is less than 1kb (memory limit to be manipulated on the atmega328 chip), you can use the…
arduinoanswered Felipe Grossi 119 -
0
votes1
answer1240
viewsA: IIS - Capture user logged in to the machine without using Windows authentication
If you want to check the Windows user with Forms Authentication, you can use this code: System.Security.Principal.WindowsIdentity.GetCurrent().Name.Tostring() However, it is not safe. Easily the…
-
0
votes2
answers111
viewsA: Increase file upload limit by App.Config C#?
Can be configured on the web.config of the application that will use this DLL. I believe you will not be able to configure the application parameters maxRequestLength, maxAllowedContentLength via…
-
-3
votes2
answers343
viewsA: Gmail notifies that email is usually used to steal information when I use content-type ="text/html; charset=utf-8"
I found this article in stackoverflow.com: https://stackoverflow.com/questions/19870659/gmail-marking-mails-as-spam-from-my-website Apparently customizing the subject of the email and the content of…
-
0
votes2
answers67
viewsA: Trying to search with specific id in a period
Since we don’t know the structure of your database, I can’t tell you exactly the query to be made, but as a rule, just add in the Where of select an "AND" and the Car ID or something, that can…
-
0
votes2
answers546
viewsA: Publish my system to IIS and it is not loading multiple files
Usually this error happens by running locally with a virtual directory other than the server. For example, on your machine the address is http://localhost/ and on the server http://server/filename/…