iif dalam MS-SQL

perintah IIF dalam MS-SQL

select iif(praktikum is null,'Kuliah','Praktikum')  as jenisKuliah from kuliah

artinya jika field berisi null maka jenisKuliah berisi kata Kuliah, sebaliknya jika tidak null maka berisi Praktikum

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;

}