Posts by Paulo Balbino • 674 points
25 posts
-
1
votes1
answer123
viewsQ: Manipulation of records (regedit)
I have an application developed in windows Forms that handles some records in the following way: "HKLM SOFTWARE MINHAEMPRESA etc...". This application was run as an administrator and I never had a…
-
0
votes0
answers445
viewsQ: View with filters and grid in Asp.Net MVC
I am new to Asp.Net MVC and need to create a View similar to the following image: In the "Filters" frame the user will select the filters to be used in the query and click on the "Filter" button to…
-
1
votes0
answers76
viewsQ: Center Textboxfor with column icon
I’m trying to create a centralized login form, but with the code below the input text is aligned to the left and the icon to the right: <div class="form-group"> <div class="row"> <div…
-
1
votes1
answer480
viewsQ: Get error message in Httpclient Post
I have a WCF Service on a server whose service is also configured as Webinvoke: [WebInvoke( Method = "POST", UriTemplate = "/work", BodyStyle = WebMessageBodyStyle.WrappedResponse, ResponseFormat =…
-
3
votes1
answer691
viewsQ: ASP.NET Webforms, MVC or Webapi?
First I would like to point out that my knowledge in web development is very small, so my question will be directed on what to use and not how to use, because the goal is to study first and then…
-
0
votes1
answer88
viewsQ: Pass sequence of steps (methods) to window (wpf)
Greetings...I currently have a screen similar to the one presented below: This screen uses Backgroundworker to perform a sequence of steps and inform the user through the messages in the textblock a…
-
9
votes3
answers382
viewsQ: Design Standard for Filters
First, filter in my current context is a list of objects to be used in Combobox type controls so that the user can choose from among the options. My scenario is this: Screen 1 - Has filters of…
-
5
votes1
answer197
viewsQ: Fire Asynctask class exception
The class below is responsible for obtaining data from a WCF Rest service: public class MyAsyncTaskGeneric<T> extends AsyncTask<String, Void, T>{ private final Class<T>…
-
1
votes1
answer339
viewsA: Send an object using Gson
Change the Bodystyle property of the Webinvoke attribute of the Postrequest method in the contract to: BodyStyle = WebMessageBodyStyle.WrappedResponse
-
4
votes1
answer180
viewsQ: Update Controls in Custom Toolbox Control
I created a project "Windows Forms Toolbox Control" and customized some controls: I created a custom gallery so that all programmers in the company can install Toolbox and make use of the controls:…
-
1
votes3
answers11806
viewsA: Copy from a filtered sheet in excel vba
See if this way is faster with the amount of data you have: (this section should replace the part of your code that copies, use it after applying the filter) Call Plan1.AutoFilter.Range.Copy Call…
-
1
votes2
answers1065
viewsA: VBA Control of hours/employees
This is also possible using matrix formulae, see below: Formula: =MAXIMUM(SE(Plan2! $A$2:$A$100=Plan1! $A3;SE(Plan2! $B$2:$B$100=Plan1! C$2;Plan2! $C$2:$C$100))) - MINIMUM(SE(Plan2!…
-
0
votes1
answer46
viewsA: Change Preview text (Xtrareport)
XtraReport1 relatorio = new XtraReport1(); relatorio.CreateDocument(); PrintPreviewFormEx printPreviewFormEx = new PrintPreviewFormEx(); printPreviewFormEx.Text = "Título do Relatório";…
-
1
votes2
answers555
viewsA: Security Message on Activex control
I created an example here (excel 2013, windows 8), and in a form I put the same control "Windowsmediaplayer" and changed the record according to the third answer of this example and the message no…
-
3
votes1
answer758
viewsQ: Pass Type parameter for generic Runtime method
I have a method I use to deserialize data: public static class CustomJson<T> where T: class, new() { public static T Deserialize(string data) { try { return string.IsNullOrEmpty(data) ?…
-
1
votes1
answer1226
viewsA: Problem when exporting data from c# datagridview to excel spreadsheet
I made the example: for (j = 0; j <= dataGridView1.ColumnCount - 1; j++) { DataGridViewCell cell = dataGridView1[j, i]; if (j == 2) { WorkSheet.Cells[i + 1, j + 1].NumberFormat = "@"; }…
-
2
votes1
answer746
viewsA: Insert excel column in a table in Mysql
I believe there will be no major differences from Sql to the Mysql, for the example I created in SQL. Well, in the example imagine that the Table matches the table you already imported, the Table…
-
3
votes1
answer1822
viewsA: Concatenate address in VBA Excel Range Object
Public Sub Teste() Dim Valor As Integer Valor = 3000 Range("A1").Formula = "=SUM(D1:D" & Valor & ")" End Sub
-
1
votes1
answer805
viewsA: VBA does not recognize values
Public Sub Teste() Dim MinDate As Date Dim MaxDate As Date MinDate = WorksheetFunction.Min(Sheets("Plan1").Range("A1:A100")) MaxDate = WorksheetFunction.Max(Sheets("Plan1").Range("A1:A100"))…
-
1
votes2
answers1236
viewsA: VBA for directory search and concatenating filenames
I made an example based on yours (without reference to the library I mentioned): Sub GetJPGandPNGandJPEG() Dim Path As String Dim FileName As String Dim LastDot As Long Dim FileNameAux As String Dim…
-
1
votes2
answers1236
viewsA: VBA for directory search and concatenating filenames
You can refer to the Micrsoft Scripting Runtime library to make use of File System Object (FSO) objects, for example here. This way will work with all the files that are in the directory, from the…
-
1
votes2
answers439
viewsA: Store modified class properties
Following the advice mentioned in Maniero’s reply, I used the interface INotifyPropertyChanged in class Funcionario, through the event PropertyChangedEventHandler get the changed properties and…
-
2
votes2
answers439
viewsQ: Store modified class properties
I need to have stored in the class itself a list with (name and value) of the changed properties. However, I don’t know if the form I am using is feasible. I have the class Employee below: public…
-
1
votes1
answer138
viewsQ: Identify WCF Service client (intranet or internet)
I wonder if it is possible to identify the call if a WCF Service on the server, if it was called by a client inside the network (intranet) or outside the network (internet). I am implementing a data…
-
0
votes2
answers234
viewsQ: A way to unify calls in WCF Service?
Greetings to you all. Currently I have a WCF Service Application running on IIS with many services, to each new service created I need a new update and a new reference on the client side. As I am…