[Shere][C#] Insert update Delete Simple

Beranda

...

Programmer Forum
[Shere][C#] Insert update Delete Simple

assasin404

18-01-2015 17:30

[Shere][C#] Insert update Delete Simple

yups mungkin ini bisa membantu untuk memudahkan Insert, Update, Delete pada C# MYSQL Server

Spoiler for Video:

Spoiler for Code:

Spoiler for Create Database:

Buat Database

Contoh : db_kelas

Spoiler for Project:

Buat Project di C#

Example Project = Example1

Spoiler for Class:

Buat Class Baru dalam Project tersebut dengan name
Contoh : querysql

Spoiler for codenya:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;

namespace example1
{
class querysql
{
public static void query(string q)
{
MySqlConnection c = new MySqlConnection("Server=localhost;Port=3306;Database=db_kelas;Uid=root;Pwd=");//maslah ini di sesuaikan aja sama database agan
c.Open();
MySqlCommand cmd = new MySqlCommand(q, c);
cmd.ExecuteNonQuery();

}

}
}

Spoiler for Button Insert:

string i = "insert into data_kelas values('" + txt_nis.Text + "','" + txt_nama.Text + "','" + cmb_jenisk.Text + "')";
querysql.query(i);

Spoiler for Button Update:

string u = "update data_kelas set nama='" + txt_nama.Text + "', jenis_kelamin='" + cmb_jenisk.Text + "' where nis='" + txt_nis.Text + "'";
querysql.query(u);

Spoiler for Button Delete:

string d = "delete from data_kelas where nis='" + txt_nis.Text + "'";
querysql.query(d);

Mohon Maaf klo masih blepotan maklum First Time emoticon-Ngakak