MySQL di ASP.Net Core
Install NuGet
Project - Manage NuGet
MySQL Data (Install)
Test Koneksi
using MySql.Data.MySqlClient;
MySql.Data.MySqlClient.MySqlConnection myConnection;
string myConnectionString;
myConnectionString = "server=server;uid=user;pwd=password;database=database";
try
{
myConnection = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString);
myConnection.Open();
MySqlCommand myCommand = new MySqlCommand();
myCommand.Connection = myConnection;
myCommand.CommandText = @"SELECT * FROM GudangWHERE field = @param;";
myCommand.Parameters.AddWithValue("@param", "123445");
using var myReader = myCommand.ExecuteReader();
{
while (myReader.Read())
{
TempData["Nama"]= myReader.GetString("nama");
}
}
myConnection.Close();
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
TempData["Nama"]= ex.Message;
}
Posting Lebih Baru Posting Lama