Posts by Junior Guerreiro • 617 points
69 posts
-
1
votes0
answers67
viewsQ: image and write to the sql database in the image field
Good afternoon. I have a little problem with my code, and I need some help. I am inserting an image in my form in an image field, now I need to take this image and write an image field in a field in…
-
0
votes1
answer167
viewsQ: Error passing information from a datagrid line of a form to the datagrid of another form
I have a following error when passing information of the selected line from a Form1 grid to the form2 grid Follow the code of the Form1 grid private void button1_Click(object sender, EventArgs e) {…
-
0
votes0
answers27
viewsQ: Data from datagridview going from one screen to another
Good afternoon, I have some data that load a datagridview, this data comes from a query in the database in slq, and in that datagrid I have a column with a chekbox, I wanted to know how to do even…
-
0
votes0
answers31
viewsQ: Chekbox column in datagridview
I’m getting an error after I put a chekbox column in the datagridview on my screen, and this screen is loaded by a query, put this chekbox column not in the query but directly in the datagridview.…
-
1
votes1
answer266
viewsQ: Parameters for query in sql server
Good morning.. I have a query in sql server with date and status columns, I need to bring the result by the date typed or by the state typed or by the two, as I can do this right in the query in sql…
sql-serverasked Junior Guerreiro 617 -
0
votes0
answers360
viewsQ: Function that returns Icms St ADVPL
Good morning. I have the function below that returns the ICMS ST value for a field, only the value is returning zeroed. Someone could help me. Thanks. #INCLUDE "protheus.ch" #INCLUDE "rwmake.ch"…
advplasked Junior Guerreiro 617 -
0
votes1
answer223
viewsQ: Create another page in an advpl report
Good morning.. I’m new to advpl, and I created a budget print. But I’m having a problem and I have no idea how to fix it, and it’s a simple thing, but since I’m new to advpl, I don’t even know how…
-
0
votes1
answer172
viewsQ: I have this mistake in advpl
I have the image error when I print the sales order on Totvs. But it only presents this error the third time I make the print, I print once ok right, the second time too, now the third time presents…
advplasked Junior Guerreiro 617 -
1
votes1
answer245
viewsQ: I have a problem loading a field using a function in ADVPL
I need to load the field CK_XLOTE typing the code of the product in the field CK_PRODUTO, I am generating a function to perform this procedure, but it is not returning the lot in the field. Can…
-
1
votes2
answers586
viewsQ: Write checkbox value to sql server database
I have a DataGridView and in it contains a checkbox, I need to save the value in the database, how can I do the Insert of this value in the bank, the field in the bank is as: 0=false e 1=true, Only…
-
0
votes1
answer84
viewsQ: View document in pdf using printdocument
I am making a direct print on the printer using the printdocument, now I need to use this document to generate a pdf, and view using the Windows pdf, how to pass my code to pdf. follow the code I…
c#asked Junior Guerreiro 617 -
-1
votes2
answers273
viewsQ: How to make an if-type validation in a set of options?
I need to make a if where I check a set of options not to do a if within another if to check whether a field is filled or not, I want to do this with a single if. Ex if(valr1, valor2, valor3 != "")…
c#asked Junior Guerreiro 617 -
-1
votes1
answer177
viewsQ: How to work with various parameters in c#
Good afternoon. I need a help, I have a combobox with 3 options, and I need to pass any of the three options as a parameter of a Procedure in sql for a query, but since I’m new in c# I never passed…
c#asked Junior Guerreiro 617 -
0
votes0
answers266
viewsQ: Conflict between tables in sql servre 2012
I have a problem making a relationship between two tables in sql server 2012. How can I resolve this? Table 'tbl_chkrecebimento' saves successfully Table 'tbl_chkitens' - Cannot create relation…
sql-serverasked Junior Guerreiro 617 -
0
votes0
answers48
viewsQ: Field rounding value in sql write with c#
I have a problem to record a decimal field(18,2) in the sql database, I am passing the value of 11.5, and this recording in the database 12,00. I am working in Decimal fields(18,2). How can I solve…
c#asked Junior Guerreiro 617 -
0
votes1
answer54
viewsQ: Import xml data field
I’m making an import of tags from xml to fields of textbox in Windows Form, only that I am not able to import the data fields in the correct format, to a masktextbox in date format.How do I proceed…
c#asked Junior Guerreiro 617 -
0
votes1
answer29
viewsQ: Importing an XML and using columns to calculate
I need a help, I’m importing xml from Nfe, and I’m using the QTDA field to do a calculation, only the quantity field in xml is composed this way, 360.0000 and when I import that field is 3600000…
c#asked Junior Guerreiro 617 -
-2
votes1
answer284
viewsQ: Format numeric field with 2 decimal places in datagridview c#
I need to show a column in the raw weight column datagridview this format 0.00, but I’m not getting, this column is not created in any database, I created the column directly in datagridview, I’ve…
-
0
votes1
answer130
viewsQ: Show xml nfe tag value in datagridview columns
I have a little problem because I am reading the tags of an xml of Nfe, but I am not able to show in the columns of datagridview, my code is reading the correct tags, but do not notice anything in…
c#asked Junior Guerreiro 617 -
1
votes1
answer133
viewsQ: Check/Uncheck button check box
In my program there is a button to mark and the same button to uncheck a checkbox. Example: If I click once, it marks the check box, if I click again on the button it unchecks the check box.…
-
1
votes2
answers102
viewsQ: Select with fields without values
I’m making a SELECT where I join two tables: a stock balance table and another order table. I’m making a comparison between product balance in stock and balance on purchase orders, only the way I’m…
sqlasked Junior Guerreiro 617 -
1
votes1
answer34
viewsQ: Email automatico no sql server 2012
I have a problem at the time of putting the query in the body of the email, this giving me error asking for EXISTS in the query how I can solve it. Follows my code. DECLARE @p_body as nvarchar(max),…
sqlasked Junior Guerreiro 617 -
0
votes1
answer59
viewsQ: Select result feeding other 2 selects
I have the select 1: SELECT DISTINCT SD2.D2_DOC AS NOTA, CONCAT(RTRIM(SD2.D2_CLIENTE), ' - ', SA1.A1_NOME) AS CLIENTE, SD2.D2_COD AS CODPRODUTO, QEK_REVI AS REVISÃO, SD2.D2_LOTECTL AS LOTE,…
-
0
votes1
answer23
viewsQ: Pull Characters from a column in the datagridviwer
I have a little problem, I have a datagridviwer that I fill a table in the database, just before to fill precious take the strokes of the content of the columns. You can use Replace in a…
c#asked Junior Guerreiro 617 -
1
votes3
answers1421
viewsQ: Compare if two date fields are equal in C#
I have a form and in that form I have two date fields, the campodata1 and completed by the user and the campodata2 and filled by the database, now I need a code to compare if these two fields are…
-
-1
votes1
answer140
viewsQ: Validate the contents of a Datagridview cell
I need a help. I’m inserting items into an order using a Datagridview, in that Datagridview got the spine code, description, lot and qtda. I need to validate the column code, making sure that if I…
c#asked Junior Guerreiro 617 -
1
votes1
answer193
viewsQ: Create a Freight Calculation Table in sql server 2012
I have the following question and I need the help of the experts in order to continue my project. I need to create an equal freight table from the image below, only I don’t know if I create a single…
sqlasked Junior Guerreiro 617 -
0
votes1
answer45
viewsQ: Restarting progressibar count c#
I have in my code a progressionBar, which is filled in 60 seconds, how do I so that when I arrive in 60 seconds he start counting again. private void timer_progress_Tick(object sender, EventArgs e)…
c#asked Junior Guerreiro 617 -
2
votes1
answer183
viewsQ: Paging a Datagridview
Good afternoon to you... I have a datagridview that loads several lines, I’ve been searching on the net how I can paginate this datagridview, but I could not perform such procedure, because I have…
c#asked Junior Guerreiro 617 -
1
votes2
answers1003
viewsQ: Report generated with reportview, directly in pdf
I have a form, and in this form, I have a button print out which opens a reportviwer report made with a dataset. What I need to do with this report is automate it, instead of me clicking the print…
c#asked Junior Guerreiro 617 -
0
votes1
answer617
viewsQ: Error converting varchar field to float
I am generating a Query and in this Query I am making a Join between a field varchar and a field float. Being the field SY.YE_MOEDA is varchar and the countryside DA1_A1_MOEDA is float. Follow my…
sqlasked Junior Guerreiro 617 -
1
votes1
answer109
viewsQ: textbox value for another textbo using Tabcontrol and Tabpages
I’m using in a form one TabControl, three-page. In the TabPage1 have a TextBox (seller), I need to take the value of this Textbox to another TextBox who is in the TabPage3. How can I do this between…
-
2
votes2
answers718
viewsQ: Form behind the Windows bar
What is happening and the following, when I set the form in c# visual studio 2015 to maximized, the bottom of the form is behind the windows taskbar, how can I solve the problem. Follows the code:…
-
0
votes1
answer91
viewsQ: How to manipulate data inside pages using tabcontrol
Good Tare. I have a tabcontrol with two pages, I think we can say so, on page 1 I have a datagridview that in column[0] brings numbers of notes, and on page 2 I have a txtbox that I want to be…
c#asked Junior Guerreiro 617 -
2
votes1
answer368
viewsQ: How to pass data from Datagridview to Reportviewer
I need to pass data from DataGridView to the ReportViewer to make impression, but as I am still novice in c# I am not able to pass the datatable to the form of ReportViewer, if anyone can explain me…
c#asked Junior Guerreiro 617 -
2
votes1
answer435
viewsQ: Demonstrate calculator in Stack
I have a problem here and I need a help, I have to do a job for college, and a calculator, so far so good I’ve even made the calculator, only the problem and the next, I need to demonstrate the…
c#asked Junior Guerreiro 617 -
1
votes2
answers102
viewsQ: Compare date field with current date in datagridviwer
I got a field in my datagridiviwer which is called "SCHEDULE" this field receives a date, which comes from the database as varchar or string, I need to compare the date in this field with the…
c#asked Junior Guerreiro 617 -
1
votes1
answer82
viewsQ: How to treat an index band exception?
I’m having an exception problem on my show and I’m not sure how to treat it. Follow the error image in Datagridview. private void DGW_solictacao_CellClick(object sender, DataGridViewCellEventArgs e)…
-
3
votes1
answer542
viewsQ: Date field 7 days after the current date in c#
I have a field in my application call txt_dataemissão in the case and the current date, and I have another field txt_deadline that I need you to show me in this capo the date counted with 7 days…
c#asked Junior Guerreiro 617 -
0
votes2
answers67
viewsQ: Select line in datagridwier and write to the database
I have a datagridviwer populated by a query of the sql database, in this datagrid I have a column with a chekbox, now comes my doubt, as I write to the database when the line has been selected by…
c#asked Junior Guerreiro 617 -
1
votes1
answer459
viewsQ: Datagridview.Cellclick event
How can I use the event DataGridView.CellClick to click a single column? The way I did in my code if I click any part of the datagrid it does the action, and I didn’t want it to be this way I want…
-
1
votes1
answer616
viewsQ: How to perform sum per line on a datagridview in c#
Good afternoon, I need a help, I have a datagridview that contains a Type Coin column and a Total Currency column. In the Currency Type column I can have up to 3 types of currency, euro currency,…
c#asked Junior Guerreiro 617 -
1
votes1
answer2023
viewsQ: Change color line according to cell content in datagridview
I have a Windows Form that carries a DataGridView, in it has a column that contains positive and negative values, need that when the value of this column is negative the row is a different color.…
c#asked Junior Guerreiro 617 -
1
votes1
answer183
viewsQ: Datagridview updating by child form
I have a main form (form1) where I carry a datagridviwer and I need to do this: I have a second form (form2) deleting the selected line in datagridviwer (form1), I just need to do that when I delete…
c#asked Junior Guerreiro 617 -
-2
votes1
answer140
viewsQ: Field write float to sql server with c#
Good morning, I’m doing an update in a float field on sql server, but I’m not getting this from a conversion error, I tried several ways and did not succeed, I keep getting this error return = Error…
-
0
votes1
answer387
viewsQ: How to make a Datagridbview column invisible to the user
Good afternoon. I have a c# theme that contains a datagridviwer, and I am populating this datagridiview directly with a database query, but it has a column that needs to be in select, but I cannot…
c#asked Junior Guerreiro 617 -
1
votes1
answer36
viewsQ: Release of the datagridi dviewr gridi on the change button
Good morning, I have a question, I have a datagridviwer, I unchecked the option to change the fields, and I need to do that when the user clicks the change button I free the grid for change, how can…
-
0
votes1
answer69
viewsQ: Automatic line filling in datagridwier
Good afternoon. I need help, I have a datagridwier and in it I have a column where I type in a product code. Now I need that when the user enters the code of a product in the cell of the code column…
c#asked Junior Guerreiro 617 -
0
votes1
answer70
viewsQ: Foreach or for by invoice item
I need to do one foreach per item in my code only I’m not able to accomplish. Ex.: I have a note that has 2 items, and I need to read the information of the note per item, I read item 01 and then I…
c#asked Junior Guerreiro 617 -
2
votes1
answer836
viewsQ: How to start a textbox with a value of 0 (zero)?
I have a form created with Windows Forms, and in this form I have textbox who will receive numbers. How do I make this textbox, when initializing, is already filled with value 0, that is when I open…