Posts by Gabriel Bernardone • 563 points
27 posts
-
0
votes1
answer274
viewsA: Print text positioned in image
I managed to solve using a plugin for Jquery called printThis Very simple to use and was perfect the page. $('selector').printThis();…
-
1
votes1
answer274
viewsQ: Print text positioned in image
I have a text positioned in the center of an image, the logic is to print a certificate, and this text is generated dynamically, this occurs correctly. The problem is when printing, the text is on…
-
0
votes1
answer51
viewsQ: Continuing task execution even after exception
The method RelatoriosEstaticos.AbrirDataAtual which is within the Task below is returning an exception already dealt with in the method itself, the problem is that the Task continues the execution…
-
1
votes1
answer1369
viewsQ: Fill the formula horizontally but increment the cell references vertically
I need to fill a table with horizontal reference to values that are vertical from another table In the horizontal table I am doing the following ='Tab 3x3'!G10 Only when I drag it to the side it…
-
2
votes1
answer1609
viewsQ: Set the download location and name of each downloaded file - Selenium Webdriver C #
I’m doing an automation using Selenium with Chrome Webdriver. The application has to make a series of downloads that need to be saved with different names (Report Date + Type) and in folders that…
-
0
votes1
answer51
viewsA: Does Linq generate this ID? How to recover?
Unfortunately you will not be able to access this field because the "Findelements" method returns the elements in the form of Iwebelement. Iwebelement does not have a method implemented to get the…
-
0
votes1
answer51
viewsQ: Does Linq generate this ID? How to recover?
I’m doing an automation using Selenium Webdriver and I’m taking all the elements of a Table. I used the code below: var qntd= driver.FindElements(By.XPath("//*[@id='dataTable']/tbody/tr")).Skip(3);…
-
1
votes1
answer109
viewsQ: Dll and Exe with the same name = Problem?
I had a somewhat curious problem now. I created a project (Console Application) named Spotifyapi in Visual Studio 2017 and then downloaded the Spotify API in Nuget. When I went to run the code for…
visual-studioasked Gabriel Bernardone 563 -
4
votes2
answers1350
viewsQ: Add seconds to time - Excel
I have a column with the following values: 945 224 554 487 That would be the seconds I need to add to another column with time, minutes and seconds 12:09:37 23:54:45 10:40:44 11:20:10 I’m doing it…
excelasked Gabriel Bernardone 563 -
2
votes2
answers212
viewsQ: Assign Tuple return in two variables
Has a method that returns a tuple with two strings. The return I want to record in two different variables, only I’m having to call the method twice to pick one item at a time. string retorno1 =…
-
2
votes0
answers121
viewsQ: Keep object in memory after end of method
I need to load two worksheets to generate a dictionary with the worksheet data. I’m a little confused about this.. I created a Lerfile method to not repeat the code, since the process is the same…
c#asked Gabriel Bernardone 563 -
3
votes3
answers1167
viewsA: Epplus row and column last cell - C#
Thank you for your attention. I was able to find the answer using LINQ To line var lastRowCell1 = worksheet.Cells.Last(c => c.Start.Row == 1); Para Coluna var lastColCell1 =…
-
4
votes3
answers1167
viewsQ: Epplus row and column last cell - C#
I want to select a range from the first to the last cell filled in the row or column. In VBA the code is as below using Range(Selection, Selection.End(xlDown)).Select Range(Selection,…
-
0
votes2
answers1736
viewsQ: Partial View does not load Javascript - Asp.Net MVC
I’m switching to a Partial View via a two-parameter controller, music and artist. Already in PV I pass to the function fetchLetra() that is in the file letraAPI.js these parameters for the return of…
-
3
votes1
answer63
viewsQ: Nullreferenceexception using Htmlagilitypack
I wonder how many tags <a> exist within a div, but the Exception NullReferenceException is fired when arriving on Xpath. var baseURL = "AQUI VAI A MINHA URL"; var client = new HtmlWeb(); var…
-
-1
votes1
answer98
viewsA: Add a <div> to each <li> - Htmlgenericcontrol tag
The solution is easier than I thought. I added HtmlGenericControl div = new HtmlGenericControl("div"); noticias.Controls.Add(div); Then at the end div.Controls.Add(li);…
-
1
votes1
answer98
viewsQ: Add a <div> to each <li> - Htmlgenericcontrol tag
I am reading an RSS XML and adding each news to a tag <li> I need every tag <li> stay within a tag <div>, how can I do this through Htmlgenericcontrol? That way <div>…
-
2
votes1
answer501
viewsQ: Location selection depending on browser - Google Maps
I recently started using the Google Maps API, so I know very little about. When entering the site of my project the browser asks if it can obtain the user’s location. Only I realized that the…
-
0
votes2
answers144
viewsA: How a Checkbox can receive a Datagridview Checkboxcell
After researching a little, I managed to solve the problem. editarUsuario.chkAdm_consulta.Checked = Convert.ToBoolean(gridConsultaUsuario.CurrentRow.Cells[5].Value.ToString().ToLower());…
-
0
votes2
answers144
viewsQ: How a Checkbox can receive a Datagridview Checkboxcell
In my Datagridview brings from the Database the user information, among them if he is administrator or not, this cell has a Datagridviewcheckboxcell. I want to pass its value (True/False) to a…
-
1
votes1
answer76
viewsQ: How to make Usercontrol fill all Tabpage
I am placing a Usercontrol inside a Tabpage. When not Maximized, the Usercontrol fills all Tabcontrol However, if I maximize the screen, there is a space on the right. I used usercontrol winforms…
-
11
votes1
answer3531
viewsQ: How to change the Namespace of a C#project
The project was created with the name Windows and I want to change. The problem is that if I just right-click the project and rename it, the project gets full of error. I tried to change Assembly…
-
1
votes1
answer224
viewsQ: Parameters in the Query
When mounting a Query using Addwithvalue. Even if right, the return is not as expected. In the example below the return is Zero var query = "SELECT nome,usuario,email,administrador FROM GSCUsuarios…
-
11
votes1
answer3203
viewsQ: Left Join or Not Exists
I needed to retrieve information that was in a certain table, but were not in another one. Searching found that NOT EXISTS would serve this case, but I saw that Left Join brings the same result: NOT…
-
0
votes1
answer3075
viewsQ: Open Modal Bootstrap from code-Behind
I need to open a modal when the password or user are incorrect, it will be on Else .. but does not open the modal protected void bntLogar_Click(object sender, EventArgs e) { Registrar criptografia =…
-
0
votes0
answers71
viewsQ: The "Generateresource" task failed unexpectedly
I renamed the project name and cause several problems in the project, is giving the error below. I managed to solve all others, except this one. What can it be?…
c#asked Gabriel Bernardone 563 -
3
votes1
answer1368
viewsQ: Customize calendar C#
In the system I’m doing, I need a calendar that has only the weekends of each month enabled to be selected, the rest is deleted.. How can I do this in C# Winforms? I searched on the Internet and…