Posts by Pietro Nunciaroni • 157 points
19 posts
-
1
votes1
answer42
viewsQ: Storing the value of a SELECT Query in a column in MYSQL
I have this SELECT in my BD however I need one of the columns to store the value generated by lucro, I already have a profit column created as DOUBLE but it does not store that information SELECT…
mysqlasked Pietro Nunciaroni 157 -
1
votes1
answer47
viewsQ: Calculation in query in the Database
Guys I have a certain problem if I make an appointment in the comic book, the SELECT makes a calculation of some columns in the database and generates a new field with the name lucro but if there is…
mysqlasked Pietro Nunciaroni 157 -
1
votes1
answer41
viewsQ: Search only one record type in the database and show in Datagrid
How do you do a bank search and show on DataGrid, only that I select a category I’m not sure how to do this kind of search in the bank, when I select in the ComboBox1 the active word, it brings me…
-
0
votes1
answer85
viewsQ: Searching between two dates
I have a C# program that assembles a report and can filter by name, but I want to go further, I wanted to pull all the records between two dates. Good as I do to assemble the WHERE of that filter by…
-
0
votes1
answer56
viewsQ: Error bringing a Log Data to a label
Hi, I’m trying to bring in for a Label a database registration data, for example: when the person selects the product on ComboBox the price of the product on label However, I don’t think I’m getting…
-
0
votes1
answer37
viewsA: Search Using Combo box
Well solved I managed to bring data from DataGrid as follows I changed the comboBox1.SelectedValue for comboBox1.text, now it brings only records with Active or Inactive status follows code below:…
-
0
votes1
answer37
viewsQ: Search Using Combo box
I’m with a ComboBox that when I select Active or Inactive status it empties my DataGrid What I’d like him to do is select one of the two Options and bring all records with Active Status, for an…
-
3
votes2
answers86
viewsQ: Error saving BD change in C#
I have a certain error when making changes to some data registered in the database, picture below the error also follows the code used: private void btnSalvar_Click(object sender, EventArgs e) {…
-
-1
votes1
answer143
viewsQ: Changing Mysql data with C#
I am trying to change data saved in my BD, however by having a certain error, if someone can give a light code I’m using to save the changes: private void btnSalvar_Click(object sender, EventArgs e)…
-
0
votes2
answers82
viewsA: Save changes to the bank
Good people that was how I managed to solve this problem, now already this changing in the bank private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { lblID.Text =…
-
-2
votes1
answer70
viewsQ: How to Change a Data in the BD
I’m trying to change the data registered in the database, for example, when I click on DataGrid He pulls the dice for me textBoxs, but I wish I could save the changes made, but it does not change,…
-
-1
votes1
answer36
viewsQ: How To Make My Save, Change My Database Data
Guys, I’m trying to make a Button that normally Salva, also become a Button that saves the changes made... It’s all the same form and the same Button, for example when I click two DataGrid he brings…
-
3
votes2
answers82
viewsQ: Save changes to the bank
I am trying to change the data saved in the Database, basically when I double click on DataGrid he populates my TextBoxs to make the changes in the bank, but when I click to save it from the…
-
0
votes1
answer278
viewsQ: How to change the function of my save button, to change
I have some data registered in the database, and I wanted to know how to change the function of inserting in the database to change the data, using a Button, I can pull the dice and throw them at us…
-
0
votes1
answer69
viewsA: How to pull data from a cell in the Data Grid?
Problem solved, I used the method private void dataGridView1_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { txtNome.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();…
-
0
votes1
answer69
viewsQ: How to pull data from a cell in the Data Grid?
My database data is showing up on a DataGrid and I wanted to make them go to the TextBoxs as soon as I gave two Clicks in the specific Cell for editing, how can I do it ? Detail, the database was…
-
1
votes1
answer53
viewsQ: How to send the Data Time Picker date to the Mysql database
Speak guys I have a problem that is send my DTPentrar alias DataTimePicker, follows photo of the error and the code, if anyone can give a light thank you. Hugs private void btnSalvar_Click(object…
-
1
votes1
answer58
viewsQ: How to Show a split result on the screen
I am developing a project in which the result of the division of the 5 items always 0, someone can help me to tidy up private void btnCalcu_Click(object sender, EventArgs e) { //convertendo Total =…
-
1
votes0
answers317
viewsQ: How to send the value of a combo box to the database
Man ComboBox brings the ID Primário table Produto to be registered in a new table that is the Pacotes. So far so good, the problem is that if I select another record on ComboBox it saves as if it…