Posts by Italo Rodrigo • 4,344 points
275 posts
-
2
votes1
answer375
viewsQ: Update in a table with values from another
How to update the values of a table, using values taken from another table: UPDATE produto -- atualizar a tabela produto SET produto.quant = SUM(entrada.quant) -- produto.quant será igual a soma da…
-
0
votes1
answer492
viewsA: select does not work
Instead of using the codes like this: $bairro->ExecSQL("select * from bairro where bairro_categoria = '$cod'"); I think it should be like this: $bairro->ExecSQL("select * from bairro where…
phpanswered Italo Rodrigo 4,344 -
2
votes1
answer261
views -
0
votes1
answer344
viewsQ: How to convert SQL command to LINQ?
I have two classes: Produção { int id, procedimento int, quant int string competencia } bpi { int id, ini idProducao } How to convert the code below to LINQ? select ((sum(procedimento) + sum(quant))…
-
1
votes3
answers2248
viewsA: Fill string with blank boxes
I was able to do it this way: item.nome.PadRight(30, ' '); Padright completes spaces on the right, and the string on the side (with single quotes instead of doubles) must contain the character that…
-
3
votes3
answers2248
viewsQ: Fill string with blank boxes
I need to format a string so that it contains only 30 characters. If you are less than 30, you should complete it with blanks, and if you have more, you should leave it with only 30. I know you must…
-
1
votes1
answer828
viewsQ: How to change the app.config file at runtime?
how can I change the app.config file at runtime? I want to change the connection string: <add name="WiconEstoqueDataContextConnectionString" connectionString="User…
c#asked Italo Rodrigo 4,344 -
0
votes1
answer82
viewsQ: Pick different records from two tables
I have a table offline: id int descricao string online int chave string And another table online: id int descricao string chave string How do I select the table fields online which do not exist in…
linqasked Italo Rodrigo 4,344 -
1
votes1
answer1190
viewsQ: How do I sync an offline database to an online one?
I have two identical databases, one offline and one online. In every field of a table I have a column called online with values 0 (did not send the data) or 1 (already sent the data). Usually I…
-
3
votes1
answer54
viewsQ: Is it mandatory to rebuild?
Whenever I pressed the Start button to run my program and test, it ran correctly. From time to time, whenever I change something and run the program, it does not update, I need to right click on the…
-
4
votes1
answer2505
viewsQ: How to comment / document a table?
I saw in a Postgresql database that each table and each table field has a comment explaining what each one is for. Following model below: I want to know if in Mysql it is possible to do something…
mysqlasked Italo Rodrigo 4,344 -
1
votes2
answers1660
viewsQ: Select Where in LINQ
How to convert code select below in LINQ? select * from producao where id not in (select idProducao from bpi)
-
3
votes1
answer122
viewsQ: Error formatting string with number
I want to format a string so it has six digits filled with zeros on the left. I’m using the following code: string.Format("{0:000000}", linha.Quant.ToString()); He’s returning the next: 67 = 00067…
-
1
votes1
answer526
viewsQ: Select case in two tables
I have 4 tables: Saida{ id int, idDestino int, idProduto int, tipoDestino int, quant int, data date, solicitante varchar} Paciente{ id int, nome varchar} Unidade{ id int, nome varchar} Produto{ id…
-
1
votes1
answer167
viewsQ: Doubt with Join between two classes
I have the Classes: class Procedimento { public string CodProcedimento { get; set; } public string NomeProcedimento { get; set; } public string TpSexo { get; set; } public int IdadeMinima { get;…
-
4
votes1
answer312
viewsQ: See the values of variables at runtime?
How can I know the values of the variables of an application at runtime? I want to know the value of some variables to know if the program is acting correctly.
-
3
votes1
answer666
viewsQ: How to make Join with more than two lists?
I have three classes: class Cbo { public string ProfId { get; set; } public string Cbo { get; set; } public string Descricao { get; set; } } class Profissional { public string ProfId { get; set; }…
-
2
votes1
answer1176
viewsQ: How to print file without opening?
My system generates a PDF created in iTextSharp and I use the following code to open it: System.Diagnostics.Process.Start(nomeArquivo); nomeArquivo is the address of the PDF file. How do I send the…
-
2
votes1
answer6570
viewsQ: Path access error denied
I am with a program created in Visual Studio / Windows Forms. In it access the following file to get some information: 1st Code (works normal) StreamReader file = new StreamReader(@…
-
1
votes1
answer986
viewsQ: How to join two different lists using LINQ and Where?
I have three classes: class Cid { public string cid { get; set; } //importo esse campo via txt public string descricao { get; set; } //importo esse campo via txt } class Relacionamento { public…
-
7
votes2
answers3355
viewsQ: Search item in a list using LINQ
I have a list and want to search it (as if it were a database). It is possible? Ex: list all names from the list that start with 'JOAO%'
-
2
votes1
answer154
viewsQ: Datetimepicker with custom dates
I am developing a consultation marking system in Windows Forms and had the idea to include a DateTimePicker where only dates with available vacancies must be "clickable" by the user. There’s a way…
-
1
votes0
answers118
viewsQ: Namespace error name 'Linqtodb' could not be found
I downloaded Linq2db.Firebird via Nuget and changed the file as per the tutorial: <#@ template language="C#" debug="True" hostSpecific="True" #> <#@ output extension=".generated.cs" #>…
-
0
votes1
answer122
viewsQ: How to use Linq2db.Firebird?
lowered the Linq2db.Firebird using the following code: Install-Package linq2db.Firebird The installation was performed successfully, but I am not able to find in Visual Studio, nothing related to…
-
4
votes3
answers2170
viewsQ: How to compare two List and delete repeated fields?
How to compare to lista1 and the lista2, excluding the items repeated in one of them?
-
1
votes2
answers85
viewsA: Error while deleting second List item
I managed to sort it out like this: if (e.KeyCode == Keys.Delete) { var remover = listaPedido.SingleOrDefault(r => r.ItemOffline == int.Parse(gridPedido.CurrentRow.Cells[3].Value.ToString())); if…
c#answered Italo Rodrigo 4,344 -
2
votes2
answers85
viewsQ: Error while deleting second List item
I am using the following code to delete items: if (e.KeyCode == Keys.Delete) { var remover = listaPedido.SingleOrDefault(r => r.ItemOffline ==…
c#asked Italo Rodrigo 4,344 -
5
votes1
answer312
viewsA: Error while trying to read excel file C#
Empregados$ must be the name of the spreadsheet within file and not the name of file, ex: In the example file above, you would have to use Planilha1$…
-
3
votes1
answer4168
viewsQ: How to create a variable accessible in all Forms?
In my application you will have a login system. I want to create a variable to store the user id that is logged in, and that it can be accessed in all other forms. I need this because in my…
-
2
votes3
answers1955
viewsQ: How to scan data from an Excel spreadsheet
I have a Mysql database and I want to take the data from an excel spreadsheet and send it to him. I already know how to save the data in the table, just need to know how to scan the spreadsheet and…
-
1
votes1
answer31
viewsQ: Items are not shown in dataGridView
I am using the following code to include items in a list and show them in mine DataGridView: PedidodetalheOffline item = new PedidodetalheOffline(); //crio um novo item item.IdOffline = id; //seto o…
-
6
votes1
answer1213
viewsQ: Install app made in Visual Studio on client machine
I created my first Windows Forms application and will install it on the client’s machine. How should I proceed? Just the .exe and the database?
-
0
votes1
answer754
viewsA: C# - Limit value in Textbox
Suggestion 1 I recommend you use the component NumericUpDown. Include four of them in your form and seven properties minimum for 0 and maximum to 255. The advantage of using this type of component…
-
4
votes1
answer48
viewsQ: Error There are no comments for in the schema
I’m following a tutorial to access database via LINQ. In the video, I saw a function that returns me a list with the database data: public static List<LicitacaoOffline> Buscar() {…
-
4
votes1
answer280
viewsA: How does the Position property work?
There are four values for the property Position: Static, Relative, Fixed e Absolute Static position: Static; not based on properties top, left, bottom ou right, it simply stays in the place where…
-
4
votes1
answer1895
viewsA: Javascript that displays how many months weeks days hours minutes seconds in x hours
I created this function to help you: function calcula(valorInicio){ //primeiro criei constantes para armazenar os valores dos tempos em MINUTOS. altere eles de acordo com sua necessidade const…
javascriptanswered Italo Rodrigo 4,344 -
0
votes0
answers497
viewsQ: Prevent page break in Microsoft Report
I created a report in Visual Studio 2015. Information is displayed correctly: However, when I click to visualize printing, it is cut (see that the information I painted is not appearing): How to…
-
1
votes1
answer71
viewsA: Error sending php message
After chatting with Nathan on Chat, I discovered that the issue is that he was trying to send the email from his local machine without setting up any email server. So I recommended him to look for a…
phpanswered Italo Rodrigo 4,344 -
3
votes1
answer57
viewsA: Doubt with PHP login and access level
1- This is the best way to do this? No, because every time you access the database, you lose time. 2-It would be easier to save the user permissions in the session, to avoid select? Yes, this is the…
phpanswered Italo Rodrigo 4,344 -
2
votes2
answers80
viewsA: How do I use variables within this PHP + Mysqli code?
change this line $sql = "INSERT INTO cadastro (nome, sexo, dia, mes, ano) VALUES ('"$nome"','"$sexo"','"$dia"','"$mes"','"$ano"')"; for $sql = "INSERT INTO cadastro (nome, sexo, dia, mes, ano)…
-
8
votes1
answer665
viewsA: How to check memory usage in Visual Studio?
Visual Studio has a specific diagnostic window called Diagnostic Tools. That among other monitoring functions, shows the amount of memory used by the application. Whenever you run your project by…
visual-studio-2015answered Italo Rodrigo 4,344 -
0
votes2
answers80
viewsA: Error getting photo from facebook friend via PHP SDK
I did some tests in Graphapi Explorer on Facebook and the generated code was: GraphRequest request = GraphRequest.newMeRequest( accessToken, new GraphRequest.GraphJSONObjectCallback() { @Override…
-
1
votes2
answers74
viewsA: ul is not defined at Htmldocument
I believe the problem is here: readyDom(function() { var navbar = document.createElement("style"); ====>>> ul.innerHTML = 'body { margin: 0; } ul.spot-nav { list-style-type: none;…
javascriptanswered Italo Rodrigo 4,344 -
1
votes1
answer32
viewsA: Automatically created grids when others are full
create a RIFA table with the fields: valor //10, 20 ou 30 idComprador //identifica o usuário por um id vindo de outra tabela (para evitar problemas com usuários com nomes iguais) vendida //campo…
-
0
votes1
answer82
viewsQ: Composite Component in C# does not show all attributes
I have a system where I use a dataGridView to list the fields of a table through the property dataSource, and a textBox so that the written text serves as a filter (when I type something in textBox,…
-
2
votes1
answer38
viewsA: Help with Mysql SQL Query
try like this: SELECT * FROM mensagem WHERE (IdUserFrom = $iduserfrom AND IdUserTo = $iduserto) or (IdUserFrom = $iduserto AND IdUserTo = $iduserfrom)
-
-1
votes1
answer71
viewsQ: Visual Studio 1 Solution and 3 Projects, is it possible to separate them later?
I am using Visual Studio 2015. In it I realized that I can have 1 Solution and as many projects as I want (in this case I am creating 3). After ready, I can export the . EXE separately? How to do?…
-
0
votes1
answer245
viewsQ: Azure connection drops constantly
I’m using Visual Studio 2015, C# and database SQL Server Azure and developing a project Windows Forms. Everything works perfectly, only when I spend a certain time without running my application to…
-
2
votes1
answer4068
viewsQ: How to show error message?
I am developing a C# register in Visual Studio and created a method to include a new record in the database. The method is as follows:: public static bool Inserir(Usuario pUsuario) { try {…
-
2
votes1
answer383
viewsQ: Delphi - Join two different database tables
I have a Firebird (F) database with professional data: Nome, Idade, CBO I have a Paradox table (P) with occupation data: CBO, Descrição What I want to do is unite these two tables in a way that…