Skip to main content

All Questions

Tagged with
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 ...
Benj Ko's user avatar
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. ...
ThereIsHope's user avatar
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 ...
Mathieu Savage's user avatar
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....
David's user avatar
  • 161
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 ...
Ihdina's user avatar
  • 1,790
-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 &...
sup3r93's user avatar
  • 43
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 ...
Steven Lippert's user avatar
-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 ...
saniya's user avatar
  • 1
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 ...
Omar Fayoumi's user avatar
-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 ...
Kamweti C's user avatar
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 ...
Chap's user avatar
  • 59
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) ...
Omar Fayoumi's user avatar
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 ...
Jana's user avatar
  • 1
-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 ...
Severed I am's user avatar
-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
JCFP's user avatar
  • 5

15 30 50 per page
1
2 3 4 5
25