private void button3_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); databaza_con db = new databaza_con();// making connection con = new SqlConnection(db.Connection()); con.Open(); for (int i = 0; i < dataGridView1.Rows.Count; i++) { DataGridViewRow dr = dataGridView1.Rows[i]; if (dr.Selected == true) { dataGridView1.Rows.RemoveAt(i); try { SqlCommand da = new SqlCommand("delete from tbl_furnitor where id=@id", con); da.Parameters.AddWithValue("@id", id_f.Text); da.ExecuteNonQuery(); dataGridView1.Refresh(); //cmd.ExecuteNonQuery(); pastro(); rifreskoDG(); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } } }
public void rifreskoDG_klient() { SqlConnection con = new SqlConnection(); databaza_con db = new databaza_con();// making connection con = new SqlConnection(db.Connection()); con.Open(); DataTable tbl = new DataTable(); SqlDataAdapter dapt = new SqlDataAdapter("select * from tbl_klient", con); dapt.Fill(tbl); dgw.Rows.Clear(); int i; for (i = 0; i < tbl.Rows.Count; i++) { dgw.Rows.Add(tbl.Rows[i].ItemArray[0].ToString(), tbl.Rows[i].ItemArray[1].ToString(), tbl.Rows[i].ItemArray[2].ToString(), tbl.Rows[i].ItemArray[3].ToString()); } dgw.ClearSelection(); con.Close(); }
private void TextBox6_TextChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); databaza_con db = new databaza_con();// making connection con = new SqlConnection(db.Connection()); con.Open(); DataTable tbl = new DataTable(); SqlDataAdapter dapt = new SqlDataAdapter("select * from tbl_klient where emri like '%" + TextBox6.Text + "%'", con); dapt.Fill(tbl); dgw.Rows.Clear(); int i; for (i = 0; i < tbl.Rows.Count; i++) { dgw.Rows.Add(tbl.Rows[i].ItemArray[0].ToString(), tbl.Rows[i].ItemArray[1].ToString(), tbl.Rows[i].ItemArray[2].ToString(), tbl.Rows[i].ItemArray[3].ToString()); } dgw.ClearSelection(); con.Close(); }
private void shtofurnitor() { if (btn_ruaj.Text == "Ruaj") { SqlConnection con = new SqlConnection(); databaza_con db = new databaza_con();// making connection con = new SqlConnection(db.Connection()); con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO tbl_furnitor(emri,adresa, nr_cel,kompania) VALUES('" + emri_f.Text + "','" + adresa_f.Text + "','" + nr_f.Text + "','" + kompania.Text + "')", con); cmd.ExecuteNonQuery(); dataGridView1.Refresh(); MessageBox.Show("Regjistrimi u krye"); pastro(); rifreskoDG(); con.Close(); } else { SqlConnection con = new SqlConnection(); databaza_con db = new databaza_con();// making connection con = new SqlConnection(db.Connection()); con.Open(); SqlCommand cm = new SqlCommand("update tbl_furnitor SET emri=@k,adresa=@art,nr_cel=@b,kompania=@kp where id=@id", con); cm.Parameters.AddWithValue("@id", id_f.Text); cm.Parameters.AddWithValue("@k", emri_f.Text); cm.Parameters.AddWithValue("@art", adresa_f.Text); cm.Parameters.AddWithValue("@b", nr_f.Text); cm.Parameters.AddWithValue("@kp", kompania.Text); cm.ExecuteNonQuery(); dataGridView1.Refresh(); MessageBox.Show("Perditesimi u krye"); pastro(); rifreskoDG(); con.Close(); } }
private void shtoklient() { if (btnSave.Text == "Ruaj") { SqlConnection con = new SqlConnection(); databaza_con db = new databaza_con();// making connection con = new SqlConnection(db.Connection()); con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO tbl_klient(emri,adresa, nrcel) VALUES('" + txtSupName.Text + "','" + txtSupAddress.Text + "','" + txtSupPhone.Text + "')", con); cmd.ExecuteNonQuery(); dgw.Refresh(); MessageBox.Show("Regjistrimi u krye"); pastro(); rifreskoDG_klient(); con.Close(); } else { SqlConnection con = new SqlConnection(); databaza_con db = new databaza_con();// making connection con = new SqlConnection(db.Connection()); con.Open(); SqlCommand cm = new SqlCommand("update tbl_klient SET emri=@k,adresa=@art,nrcel=@b where id=@id", con); cm.Parameters.AddWithValue("@id", txtSupID.Text); cm.Parameters.AddWithValue("@k", txtSupName.Text); cm.Parameters.AddWithValue("@art", txtSupAddress.Text); cm.Parameters.AddWithValue("@b", txtSupPhone.Text); cm.ExecuteNonQuery(); dgw.Refresh(); MessageBox.Show("Perditesimi u krye"); pastro(); rifreskoDG_klient(); con.Close(); } }