Menampilkan angka dengan belakang koma di Asp.Net Core

double CPLPersen= 30.10;

TempData["CPLPersen"] = CPLPersen.ToString("#,##0.00"); 




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;

}



UNIQUEIDENTIFIER With DEFAULT

 ALTER TABLE tabel123

  ADD NewColumn1 UNIQUEIDENTIFIER

  CONSTRAINT DF_T_Account_NewColumn1 DEFAULT (newid()) WITH VALUES


alter table, primary key, drop index, create index unique

 ALTER TABLE dataIABEE

ALTER COLUMN iabeeID [uniqueidentifier] NOT NULL;


ALTER TABLE dataIABEE

ADD PRIMARY KEY (iabeeID);


drop INDEX dataIABEE.idx_dataIABEE


CREATE UNIQUE INDEX idx_dataIABEE

ON dataIABEE (kode_kul,kelas,semester,fakjur);


Postingan Lebih Baru Postingan Lama