Hello everyone, I am developing a project for the management of emergency vehicles, as you can see from the structure visible in the image there is a server and five clients, with many accesses to the server, I have now thought to avoid giving the access to the database to dozens of users to use...
I would need some help, I'm creating a program, and through the datagridview function I get the data from the mysql database, but I need to be able to add buttons (with images) on some lines.
at this moment it adds the button on all lines
If the event has associated a...
Good afternoon. I need to make a query that outputs the authors of books sorted by the number of books in decreasing order. You only need to output authors whose number of books is greater than the average number of books by authors. A sample of my table, in which I managed to get only the...
Mysql Delete record query error, if i select record from gridview that record shouls deleted from mysql database
private void button9_Click(object sender, EventArgs e)
if (ID != 0)
//if (textBox6.Text!= "" && textBox7.Text != "" && textBox8.Text != "")
Hello csharpforums community,
I have an issue that insert some data in MySQL Database by C# .NET Core 3.1 with MySql.Data.mysqlclient.dll and having these errors in console:
Could not load file or assembly 'Renci.SshNet, Version=2016.1.0.0, Culture=neutral, PublicKeyToken=1cee9f8bde3db106'. The...
I'm trying to work out the best way to change a columns/cell to local currency on a dynamic data grid populated from MySQL
The current data grid is populated dynamically from a MySQL query, where the headings and data can change.
I would like the code, to check if the Heading of a...
I'm currently exploring options to provide a front end user to query a database tables by selection which items/filters they want. I came across this product EasyQuery which looks promising. My initial though was simply to use a data grid/or traditional report and then have the user...
I have a problem with two dependent Combobox. I want to do the dependent Comboboxes. When selecting an area in combobox1, a free taxi located in this area should be displayed on combobox2. I found this video on YouTube and tried to use the code in this video...
Hi I installed Dapper and Dapper extensions from the NuGet package Manager but I'm not able to use methods like Insert, Delete, etc... Is there something amiss in my project.
I have a model
I have a table in SQL with users, and some forms created with C# form app. My question is: "How can I make some forms invisible for some users(selecting users by username or ID)? In other words, I want do disable for simple users to make changes in a form.(disable authorisation)
I'm new to mysql and currently using c# visual studio 2012.. I need a One to many ralation tutorial.. like for example I made a table called MovieList with 1 column name TitleMovie and now I want to create another table called acc1_MyWatchlist and inside of it was also a TitleMovie..my question...
Hi to All,
I am working on C# Winform application (Visual Studio 2010) with MySql as back-end. Meanwhile I am looking for a suitable solution to a problem about How will I deploy this application along with MySql server. As this will be multiuser application, embedded database is not an...
Dear All Experts
I am new to Sql, and need some guidance to create a Trial Balance via Sql query in MySql. Consider the following scenario:
Accounts Table fields details:
AccNo (PK)(varchar) (5)
I am using Microsoft Visual Studio 2010 Ultimate, C# Winforms & MySql Database.
I am trying to use BCrypt class by Derek Slager for creating and authenticating username and password. A form is use to create new user to save Username and Password to database, but this Password is not...
Microsoft Visual Studio 2010 Ultimate,
Hi, I've create a function in mysql which accept 3 parameter to validate username and password.
DROP FUNCTION IF EXISTS `fLogin_Check`$$
ools: Visual Studio 2010 Ultimate, Language C#, Database MySql
I am searching this a while, but to date didn't find any suitable solution.
I've a form with bound DataGridView with 5 columns, ProductID, ProductName, Qty, Price and Amount. After normal data entry user can click button...
I am on the beginning stage on C# development. Currently I am developing an Voucher based Accounting Software with following:
1- Visual Studio 2010
2- Programming Language: C#
3- Database: MySql 5
At present, Database structure is as follows:
1.accAccounts (For holding...
Problem deploying to my company's domain - "buildproviders"
I encounter a problem copying all of my files (WebApplication) into my company's domain name using FileZilla. When I test my company's domain address, it says "The element 'buildProviders' cannot be defined below the application...
I have a button in my form and on click of that button I am writing this code....
OdbcCommand cmd ;
cmd = new OdbcCommand("abc", cn);
cmd.CommandType = CommandType.StoredProcedure;
I have made a procedure named abc in database which is returning only
one row from...