- Beranda
- Komunitas
- Tech
- Programmer Forum
[Tanya] Cara agar bisa edit datagridview bila tombol diklik
TS
putusaputra
[Tanya] Cara agar bisa edit datagridview bila tombol diklik
Spoiler for gambar:
Spoiler for gambar setelah di zoom:
Met siang gan, ,
ane pingin nanya tentang datagridview ni gan.
sesuai gambar di atas ane bikin tombol hapus n edit untuk mengelola data di datagridview. .
untuk tombol hapusnya ane udah bisa codingnya
untuk tombol edit ane masih bingung gan, ane pinginnya biar datagridviewnya bisa fokus n langsung bisa diedit datanya
mohon bantuannya agan agan sekalian
Spoiler for codingnya 1:
Code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace latihan_datagridview
{
class cuti
{
public string id_cuti
{
get;
set;
}
public string kodePegawai
{
get;
set;
}
public string tgl_mulai
{
get;
set;
}
public string tgl_selesai
{
get;
set;
}
public string keterangan
{
get;
set;
}
public string tgl_input
{
get;
set;
}
public string nomerIdCuti()
{
string ac;
string ad;
string abcde;
string perintah = "select max(id_cuti) from cuti where tanggal_input=#"+this.tgl_input+"#";
OleDbConnection conn = new OleDbConnection(Program.konek);
conn.Open();
OleDbCommand comm = new OleDbCommand(perintah, conn);
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter(comm);
da.Fill(ds,"barucuti");
if (ds.Tables["barucuti"].Rows[0].ItemArray[0].ToString() != "")
{
ac = string.Format("{0:ddMMyy.CT}",DateTime.Now);
ad = ds.Tables["barucuti"].Rows[0].ItemArray[0].ToString().Substring(9, 5);
int ade = int.Parse(ad)+1;
abcde = ac + (ade.ToString());
}
else
{
abcde = string.Format("{0:ddMMyy.CT10001}",DateTime.Now);
}
conn.Close();
return abcde;
}
public void tampildataCuti2(System.Windows.Forms.DataGridView ab)
{
int xyz = 0;
string perintah1 = "select id_cuti, kode_pegawai, tgl_mulai, tgl_selesai, ket from cuti";
string perintah2 = "select count(id_cuti) from cuti";
OleDbConnection conn = new OleDbConnection(Program.konek);
conn.Open();
OleDbCommand comm = new OleDbCommand(perintah2, conn);
int jml = (int)comm.ExecuteScalar();
conn.Close();
ab.Rows.Clear();
if (jml > 0)
{
ab.Rows.Add(jml);
}
OleDbConnection connn = new OleDbConnection(Program.konek);
connn.Open();
OleDbCommand commm = new OleDbCommand(perintah1, connn);
OleDbDataReader rd = commm.ExecuteReader();
while (rd.Read())
{
ab.Rows[xyz].Cells[0].Value = rd[0].ToString();
ab.Rows[xyz].Cells[1].Value = rd[1].ToString();
ab.Rows[xyz].Cells[2].Value = string.Format("{0:dd-MM-yyyy}",rd.GetDateTime(2).Date);
ab.Rows[xyz].Cells[3].Value = string.Format("{0:dd-MM-yyyy}", rd.GetDateTime(3).Date);
ab.Rows[xyz].Cells[4].Value = rd[4].ToString();
xyz += 1;
}
connn.Close();
}
public DataSet tampildataCuti()
{
string perintah = "select id_cuti as [ID Cuti], kode_pegawai as [Kode Pegawai], tgl_mulai as [Tanggal Mulai Cuti], tgl_selesai as [Tanggal Selesai Cuti], ket as [Keterangan] from cuti";
OleDbConnection conn = new OleDbConnection(Program.konek);
conn.Open();
OleDbCommand comm = new OleDbCommand(perintah, conn);
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter(comm);
da.Fill(ds, "tampil");
conn.Close();
return ds;
}
public void simpandataCuti()
{
string perintah = "insert into cuti values('"+this.id_cuti+"','"+this.kodePegawai+"',#"+this.tgl_mulai+"#,#"+this.tgl_selesai+"#,'"+this.keterangan+"',#"+this.tgl_input+"#)";
OleDbConnection conn = new OleDbConnection(Program.konek);
conn.Open();
OleDbCommand comm = new OleDbCommand(perintah, conn);
comm.ExecuteNonQuery();
conn.Close();
System.Windows.Forms.MessageBox.Show("Data cuti berhasil disimpan");
}
public void updatedataCuti()
{
string perintah = "update cuti set kode_pegawai='" + this.kodePegawai + "', tgl_mulai=#" + this.tgl_mulai + "#, tgl_selesai=#" + this.tgl_selesai + "#, ket='" + this.keterangan + "' where id_cuti='" + this.id_cuti + "' ";
OleDbConnection conn = new OleDbConnection(Program.konek);
conn.Open();
OleDbCommand comm = new OleDbCommand(perintah, conn);
comm.ExecuteNonQuery();
conn.Close();
}
public void hapusdataCuti()
{
string perintah = "delete from cuti where id_cuti='" + this.id_cuti + "' ";
OleDbConnection conn = new OleDbConnection(Program.konek);
conn.Open();
OleDbCommand comm = new OleDbCommand(perintah, conn);
comm.ExecuteNonQuery();
conn.Close();
}
}
}
Spoiler for codingnya 2:
Code:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace latihan_datagridview
{
public partial class cutiijinsakit : Form
{
cuti ct;
public cutiijinsakit()
{
InitializeComponent();
}
private void cutiijinsakit_Load(object sender, EventArgs e)
{
ct = new cuti();
ct.tampildataCuti2(dataGridView1);
/*dataGridView1.DataSource = ct.tampildataCuti().Tables["tampil"];
dataGridView1.Columns[2].DefaultCellStyle.Format = "dd-MM-yyyy";
dataGridView1.Columns[3].DefaultCellStyle.Format = "dd-MM-yyyy";*/
ct.tgl_input = string.Format("{0:dd-MM-yyyy}", DateTime.Now);
txtidcuti.Text=ct.nomerIdCuti();
}
private void btnsimpan_Click(object sender, EventArgs e)
{
ct = new cuti();
ct.id_cuti = txtidcuti.Text;
ct.kodePegawai = txtkodepeg.Text;
ct.tgl_mulai = txttglmulai.Text;
ct.tgl_selesai = txttglselesai.Text;
ct.keterangan = txtket.Text;
ct.tgl_input = string.Format("{0:dd-MM-yyyy}",DateTime.Now);
ct.simpandataCuti();
txtidcuti.Text = ct.nomerIdCuti();
ct.tampildataCuti2(dataGridView1);
/*dataGridView1.DataSource = ct.tampildataCuti().Tables["tampil"];
dataGridView1.Columns[2].DefaultCellStyle.Format = "dd-MM-yyyy";
dataGridView1.Columns[3].DefaultCellStyle.Format = "dd-MM-yyyy";*/
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex > -1)
{
if (e.ColumnIndex == dataGridView1.Columns["Column6"].Index)
{
if (MessageBox.Show("Apa anda yakin ingin menghapus data ini ?", "Peringatan", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
ct = new cuti();
ct.id_cuti = dataGridView1[0,e.RowIndex].Value.ToString();
ct.hapusdataCuti();
MessageBox.Show("Berhasil dihapus");
ct.tampildataCuti2(dataGridView1);
/*dataGridView1.DataSource = ct.tampildataCuti().Tables["tampil"];
dataGridView1.Columns[2].DefaultCellStyle.Format = "dd-MM-yyyy";
dataGridView1.Columns[3].DefaultCellStyle.Format = "dd-MM-yyyy";*/
}
}
if (e.ColumnIndex == dataGridView1.Columns["Column7"].Index)
{
Boolean hidup = true;
if (hidup)
{
dataGridView1.Columns["Column7"].HeaderText = "Save";
hidup = false;
}
else
{
ct = new cuti();
ct.id_cuti = dataGridView1[0, e.RowIndex].Value.ToString();
ct.kodePegawai = dataGridView1[1, e.RowIndex].Value.ToString();
ct.tgl_mulai=dataGridView1[2,e.RowIndex].Value.ToString();
ct.tgl_selesai = dataGridView1[3, e.RowIndex].Value.ToString();
ct.keterangan = dataGridView1[4, e.RowIndex].Value.ToString();
MessageBox.Show("Berhasil diupdate");
dataGridView1.Columns["Column7"].HeaderText = "Edit";
hidup = true;
}
}
}
}
}
}
0
4.7K
Kutip
3
Balasan
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Urutan
Terbaru
Terlama
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Komunitas Pilihan