All Questions
Tagged with mysql-workbench c#
85 questions
-1
votes
1
answer
135
views
MySql.Data ExecuteNonQuery throws NullReferenceException
I installed a MySql.Data NuGet Package to my project
and tried to create table using ExecuteNonQuery.
using (MySqlConnection con = new MySqlConnection(connectionString))
{
con.Open();
...
0
votes
2
answers
1k
views
Connecting Visual Studio to a SSH Tunneled MySQL Server
I was looking for a workaround for configuring my database connection.
I saw that opening 3306 port is dangerous and we should be using SSH Tunnel instead to connect to the database.
I configured my ...
- 77
0
votes
2
answers
1k
views
EditForm Not Showing Blazor
I've made a database with a table called item, im trying to insert some new items with the help of but it wont show on my html page in the browser.
The code looks like this and i have no clue what ...
0
votes
1
answer
571
views
How to re-arrange columns order of MySql database after updated database by modifying only code in C# Web API only?
Currently, I am working to update/modify columns order by modifying code in ef core 6 project only. I have researched and found annotation [Column(order=0)] or [Column(order=1)] ... . But exactly if ...
- 1
5
votes
1
answer
5k
views
Passing a list of int to dapper with mySQL
I have a current working solution that is doing a new db call for each project Id in a list and I am trying to do a single call instead that returns data from multiple projects.
To do this I am trying ...
0
votes
1
answer
1k
views
This MySqlConnection is already in use for .net with MySQL
I have been trying to get data from the table. The code can be found below.
When I test the API I get an error "This MySqlConnection is already in use".
Can anyone tell me what wrong am I ...
0
votes
0
answers
31
views
Parameter 'p_room_types' not found in the collection
I am new to .NET and was trying to work with MySQL and .NET Core.
Below is my stored procedure.
CREATE DEFINER=`root`@`localhost` PROCEDURE `InsertRoomNecessities`(
IN p_room_types longtext,
IN ...
0
votes
1
answer
3k
views
Failed executing DbCommand
I have this problem after trying to update database,using IdentityDbContext
Failed executing DbCommand (8ms)
[Parameters=[], CommandType='Text', CommandTimeout='30']
CREATE TABLE `AspNetUserRoles` (
...
0
votes
0
answers
58
views
How to create a routing connection from client site to pc server?
I am using Mifarecard reader to connect with the website. Mifarecard reader is connect with user laptop/desktop, due to it use USB connection only. Next, IPv6 localhost address is 192.168.71.155, due ...
- 3
0
votes
0
answers
4k
views
System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
I'm new beginner here.... My problem is when I run this code by using VS2019, that's without any error. After published it by using IIS manager, when I clicked browse then causing error.
Next, due to ...
- 3
0
votes
1
answer
228
views
Column 'username' does not belong to table Table
I am trying to do lock user account for Invalid login attempts in Asp.Net C# by using Visual Studio 2019. Database is using MySql Workbench 8.0 CE. But facing the error
C# code shown as below:
using ...
- 3
2
votes
1
answer
89
views
One-to-one relashionship Entity Framework and .NET
I am creating a relationship between my classes using code first. The integration happens with MySql, however, after migrating it consider the relationship as one-to-many when I check my workbench ERD....
-1
votes
1
answer
278
views
How to concatenate two columns from MySQL DataTable in the Datagrid View of Visual Studio 2019?
I'm sorry if my question is quite simple, I am a college student trying to explore database connections in visual studio. I was able to display values from my database table in the datagrid view but I ...
- 3
0
votes
1
answer
1k
views
Mysql database not showing up in mysql workbench when querying all databases
I created a schema in mySQL called ASSIST_DB which is not showing up as a database. I tried connecting mysql to c# in VS 2019, but I believe the database name is the problem, as the connection always ...
0
votes
2
answers
52
views
Display by date not by workweek MYSQL C#
Can anyone help me display my code by date like that not by yearweek
My data is schedule per day and i want to summarize it by week like in table
"SELECT EmployeeName,AssignedArea,SectionName,...
