Posts by Wellington Araujo • 398 points
21 posts
-
1
votes1
answer114
viewsA: Prevent values from some columns from being repeated, Mysql
There is a way to do with "PIVOT Table", I have never done it in Mysql only in SQL, in Mysql is different, if you want to try access the link below. But I still prefer to mount it in the application…
mysqlanswered Wellington Araujo 398 -
0
votes2
answers387
viewsA: Export Database Table to XLSX without Interop
Good morning, you can use the free . NET library called Epplus. Below is a simple tutorial on how to use, I did not put the code here pq is great. http://www.macoratti.net/16/04/vbn_gdvxls.htm…
-
0
votes1
answer167
viewsA: Html & VB net how to download an img with a link inside a tag?
Good morning, below is an example of how to download files. 1º - Create a button in Frontend <asp:Button ID="btnBaixarArq" runat="server" Text="Baixar Arquivo" /> 2º - Refer to Namespace…
-
2
votes1
answer28
viewsA: Ajax, HJS and Mustache
Good afternoon, do it this way <span class='noedit nome'>" + {{ nome }} + "</span>" +.... you have to remove the variables from inside the string and concatenate them into the string....…
-
1
votes1
answer140
viewsA: Enabled false after typing
Good afternoon, follow the example of how you should do function myFunction() { document.getElementById("Campo01").disabled = true; }; function myFunction2() {…
vb.netanswered Wellington Araujo 398 -
0
votes1
answer34
viewsA: VB-NET Click on an element (click on yourself) enabled false, to be enabled true
Good afternoon, you can do this by manipulating via javascript, follow an example below: function troca() { document.getElementById("imagem").style.display = 'none'; } <!DOCTYPE html>…
vb.netanswered Wellington Araujo 398 -
0
votes1
answer165
viewsA: receive date from the datapicker as a Date
Good morning, below is a code that may be what you are looking for. The code besides showing the formatted date in the "datepicker" field in "Alternate" it shows without formatting, leaves original.…
-
0
votes1
answer79
viewsA: Receive date from datapicker
Good afternoon, below is a code that may be what you are looking for. The code besides showing the formatted date in the "datepicker" field in "Alternate" it shows without formatting, leaves…
-
1
votes2
answers143
viewsA: Concatenate the field and group the rest
Good afternoon, I had to use a "while" to do what you need. I used an sql schema called "CURSOR". Follow the example, run there and tell me if it worked: IF OBJECT_ID('TEMPDB..#DadosTeste') IS NOT…
-
1
votes1
answer86
viewsA: Include new table in multiple Mysql databases at once
Good morning, you can use the code below when you want to change database, before running the table creation script. You can do a sequence or a for. USE DB_NomeBanco GO Select * from tabela…
-
0
votes1
answer50
viewsA: Display form according to user response
Good afternoon @Autoit, the way you take the field is like this: grdObjetivo.Rows(e.RowIndex).Cells(2).Value.ToString()
-
3
votes1
answer63
viewsA: Clear label when opening the main page
Note that this code snippet is in the page load even if it is not within an Ispostback treatment (Ex: If Not IsPostBack Then) and if before finishing Load it is not filling the Label again.…
-
1
votes1
answer113
viewsA: 2 filters on Bindingsource in Vb
Good morning Matthew, you will have to create another field to insert the year and in the event that makes the search you use the field of the year to filter. There is an example in the link below…
vb.netanswered Wellington Araujo 398 -
1
votes1
answer46
viewsA: Create an array with the data of an xls
Good afternoon, first you will have to refer to Excel Library in your project, after that you can get the data that is in the xls file. Below is a link that describes how to do this with Vb .net. I…
vb.netanswered Wellington Araujo 398 -
0
votes1
answer79
viewsA: Visual basic -Listview data by tables
Good afternoon, follows example of how you could do using the one Datagridview. Dim sql = "SELECT IdTipoAlimento, NomeTipoAlimento, NomeAlimento, QtdProteina FROM muscle.tb_alimentos" Dim dt As…
vb.netanswered Wellington Araujo 398 -
1
votes1
answer450
viewsA: Compile Visual Studio program with database and move to another PC
Good morning, the database does not compile along with your program. If you want to use the software locally you will have to install the sql client on the client machine, follow a link that will…
-
0
votes1
answer95
viewsA: vertical label in VB
Good afternoon, you can use the "writing-mode" in HTML(HTML5), follow example below: <asp:Label runat="server" ID="teste" Style="writing-mode: vertical-lr;">exemplo de texto</asp:Label>…
vb.netanswered Wellington Araujo 398 -
1
votes1
answer235
viewsA: Fill combobox, and pick up value menber Vb.net and mysql
Good afternoon, you will fill the grid with the example below: Dim sql = "SELECT IdAlimento, IdTipoAlimento, NomeTipoAlimento FROM muscle.tb_alimentos " Dim dt As Object =…
-
2
votes3
answers87
viewsA: How do I make a conditional if by comparing only the last 2 digits?
Good afternoon, use the "Instr" that will work too. Follow example: if InStr("UF052", "52") > 0 then Comando End if or if you want to pick only the last two characters: if InStr(Right("UF052",…
vb.netanswered Wellington Araujo 398 -
0
votes2
answers155
viewsA: Reset Form after Upload
Good morning, if you have only Hiddens javascript reset will not help, you will have to create a function in the backend to clean all Hiddens with this you take advantage and already clean the…
-
2
votes1
answer157
viewsA: Replicate phone mask in various fields
Try to put the mask after the code loads, via "Class" of the HTML. Follow example below: <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Criando…