All Questions
365 questions
0
votes
0
answers
25
views
populating C# Winform DatagridView from MySQL but the records are per row (transposed) [duplicate]
Description
Code
Debit
Credit
Electricity Expenses
101020220
1,000.00
Rent Expenses
10102030
5,000.00
Fuel and Oil
110201010
2,000.00
Receivables
10301020
8,000.00
Grand Total
8,000.00
8,000.00
I ...
1
vote
1
answer
303
views
C# form with MySQL, DataGridView
There is any way to make this C# form DataGridView with MySQL, setup more simpler? In this example project i 'm using a myDB database person table to fill the DataGridView, and handling CRUD methods.
...
0
votes
0
answers
44
views
Displaying data from my database based on what the user is typing
I am trying to display data from my database based on what the user is typing.
Why doesn't the query return any results even though I'm sure I have at least one matching result?
Here's what I have ...
0
votes
0
answers
21
views
C# Mysql datagridview1.DataSource always throws null reference exception
I am trying to read data from a mysql server. The code works fine when I use an older project. But I created a new one and a null reference is thrown every time I it gets to datagridview1....
3
votes
1
answer
349
views
Highlight specific characters in all Cells of a DataGridView
When I do a character search in the DataGridView, I want only the searched specific characters to be selected (I give it a red box), without selecting all characters in cell. How do I do it?
I wrote ...
-1
votes
1
answer
101
views
c # winform mysql data display
through C # I am creating a program that manages ambulances, I am trying to create a list with the events and active missions, this data must be taken from a mysql database, I have tried to see many &...
0
votes
1
answer
65
views
C# Set Color for 1 Cell in DataGridView
iam looking for a method to set the color specific only for 1 cell by clicking on it.
I build a Canteen Voter, which you can choice between 4 menues each day.
My DataGridView is connected to a ...
-1
votes
1
answer
62
views
Error when editing a datagridview with a connected MySQL database. An error appears when trying to save
When trying to edit the datagridview, an error appears "The CommandText property has not been properly initialized.". I read that some other stored procedure is needed, which as input ...
0
votes
0
answers
88
views
DatagridView image cell click view image in full size in another form
Greetings everyone i want to click an image in my datagridview then it will display it in another form in full size.
the problem is the image it self is populated from mysql table
and i have read ...
-1
votes
1
answer
95
views
C# Populate datagridview with SQL Server and MySQL tables
I'm trying to populate a datagridview with SQL Server and MySQL tables to map data between the two tables. The problem I'm facing is getting the column from MySQL table on the same row as that on SQL ...
0
votes
1
answer
271
views
Why am I getting a syntax error when using the Prepare() method? The problem goes away without the 'addCustCmd.Prepare();'
I am trying to add customers to a MySQL database and then populate a DataGridView with the data. Without the addCustCmd.Prepare(); method everything works fine. The customer is added to the database ...
0
votes
1
answer
86
views
C# hide a row in datagridviewer depending on the user's role that has logged into the application
Greetings i have a feature i want to add to my program which is hiding and displaying rows depending on the user role that logged onto the application
for example
(all user data are in MySql database)
...
0
votes
0
answers
93
views
MySql.Data.MySqlClient.MySqlException: Visual Studio C#
I am really new to coding and I need to resolve an update problem in my project.
I wanted to update data (connected to the database) within datagridview, but it doesn't work and I do get the ...
-1
votes
1
answer
145
views
Updating Database never works on first time, have to do it twice?
I'm trying to update/edit a database using a DataGridView that the user can edit/insert rows/delete rows. Everything appears to work up to clicking on the "Insert" or "Update" link ...
-2
votes
1
answer
55
views
What's wrong with my query? Why every time I click the column button it got an error? [closed]
The yellow one is the menu and the order summary is the pending table, but every time I click the column button I always got an query error