Menampilkan angka dengan belakang koma di Asp.Net Core
double CPLPersen= 30.10;
TempData["CPLPersen"] = CPLPersen.ToString("#,##0.00");
berusaha untuk berbagi
Selasa, 16 April 2024 Sunarto 0
double CPLPersen= 30.10;
TempData["CPLPersen"] = CPLPersen.ToString("#,##0.00");
Jumat, 12 April 2024 Sunarto 0
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
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;
}
Kamis, 11 April 2024 Sunarto 0
ALTER TABLE tabel123
ADD NewColumn1 UNIQUEIDENTIFIER
CONSTRAINT DF_T_Account_NewColumn1 DEFAULT (newid()) WITH VALUES
Selasa, 09 April 2024 Sunarto 0
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);