[ASK] CARA UPDATE DATABASE MYSQL DI C# (visual studio 2010)

[Permenkaret]

AGAN2 sekalian Ada yang tau cara update Database MYSQL di C#(VISUAL STUDIO 2010)



ane udah bisa bikin Insert sama Delete...



Nah ini update nya ane ga tau source kode nya..

ane minta tolong sama agan2 yang tau cara update database.











Ini Source Insert dan Delete ane:


Quote:





using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Data.OleDb;



namespace SparePart_Motor

{

class DataHonda

{

private MySql.Data.MySqlClient.MySqlCommand perintah = null;

string konfigurasi = "Server=localhost;Port=3306;UID=root;PWD=root; Data base=dbsparepart";

MySql.Data.MySqlClient.MySqlConnection koneksi = new MySql.Data.MySqlClient.MySqlConnection();

public DataHonda()

{

koneksi.ConnectionString = konfigurasi;

}

public DataSet getData()

{

DataSet ds = new DataSet();

try

{

koneksi.Open();

perintah = new MySql.Data.MySqlClient.MySqlCommand();

perintah.Connection = koneksi;

perintah.CommandType = CommandType.Text;

perintah.CommandText = "SELECT Kode_Sparepart,Nama_Motor,Nama_Sparepart,Stock,Har ga from thonda";

MySql.Data.MySqlClient.MySqlDataAdapter adap = new

MySql.Data.MySqlClient.MySqlDataAdapter(perintah);

adap.Fill(ds, "thonda");

koneksi.Close();

}

catch (Exception)

{

}

return ds;

}

public bool insertData(Sparepart brg)

{

bool stat = false;

try

{

koneksi.Open();

perintah = new MySql.Data.MySqlClient.MySqlCommand();

perintah.Connection = koneksi;

perintah.CommandType = CommandType.Text;

perintah.CommandText = "INSERT INTO thonda VALUES('" + brg.getKode() + "','" + brg.getMotor() + "','" + brg.getSpare() + "','" + brg.getStock() + "','" + brg.getHarga() + "');";

perintah.ExecuteNonQuery();

stat = true;

koneksi.Close();

}

catch (Exception)

{

} return stat;

}

public bool deleteBarang(string kode)

{

bool stat=false;

try

{

koneksi.Open();

perintah = new MySql.Data.MySqlClient.MySqlCommand();

perintah.Connection = koneksi;

perintah.CommandType = CommandType.Text;

perintah.CommandText="DELETE FROM thonda WHERE Kode_Sparepart='"+kode+"'";

perintah.ExecuteNonQuery();

stat=true;

koneksi.Close();

}

catch(Exception)

{

}

return stat;

}

}







}






:ilov eindonesia

</div>