private void btn_Update_Click(object sender, EventArgs e) { //string query_Update; //if (radiobtn_ThanhToanDu.Checked) //{ // //query_Update = "UPDATE dbo.ThongTinGiaoDich SET DongXe =" + "N'" + cbBox_DongXe.Text + "'" + // // ",LoaiGiaoDich =" + "N'" + radiobtn_ThanhToanDu.Text + "'" + // // ",ThoiGianGiaoDich =" + "'" + dateTimePicker_GiaoDich.Value.ToString("yyyy/MM/dd") + "'" + // // " WHERE HoTen = N'" + txtBox_HoTen.Text + "';"; // query_Update = string.Format("UPDATE dbo.ThongTinGiaoDich SET DongXe = N'{0}',LoaiGiaoDich = N'{1}',ThoiGianGiaoDich = '{2}' WHERE HoTen = N'{3}'" // , cbBox_DongXe.Text, radiobtn_ThanhToanDu.Text, dateTimePicker_GiaoDich.Value.ToString("yyyy/MM/dd"), txtBox_HoTen.Text); //} //else //{ // query_Update = "UPDATE dbo.ThongTinGiaoDich SET DongXe =" + "N'" + cbBox_DongXe.Text + "'" + // ",LoaiGiaoDich =" + "N'" + radiobtn_TraGop.Text + "'" + // ",ThoiGianGiaoDich =" + "'" + dateTimePicker_GiaoDich.Value.ToString("yyyy/MM/dd") + "'" + // " WHERE HoTen = N'" + txtBox_HoTen.Text + "';"; //} //Dbhelper db = new Dbhelper(s); //db.ExcuteDB(query_Update); //dataGridView_Data.DataSource = db.getTable("select * from dbo.ThongTinGiaoDich"); BLL_KH bll = new BLL_KH(s); bll.Update_BLL(dataGridView_Data); btn_Show_Click(sender, e); }
private void txtBox_Search_TextChanged(object sender, EventArgs e) { BLL_KH bll = new BLL_KH(s); DAL_KH dal = new DAL_KH(s); dataGridView_Data.DataSource = bll.SearchKH_BLL(dal.getListKH_DAL(), txtBox_Search.Text); }
private void btn_Show_Click(object sender, EventArgs e) { //Dbhelper db = new Dbhelper(s); //dataGridView_Data.DataSource = db.getTable("select * from ThongTinGiaoDich"); BLL_KH bll = new BLL_KH(s); bll.Show_BLL(dataGridView_Data); }
private void btn_Sort_Click(object sender, EventArgs e) { if (cbBox_Sort.Text.ToString() == "HoTen") { BLL_KH bll = new BLL_KH(s); dataGridView_Data.DataSource = bll.sortKH_HoTen(); } else if (cbBox_Sort.Text.ToString() == "LoaiGiaoDich") { BLL_KH bll = new BLL_KH(s); dataGridView_Data.DataSource = bll.sortKH_LoaiGiaoDich(); } else if (cbBox_Sort.Text.ToString() == "ThoiGianGiaoDich") { BLL_KH bll = new BLL_KH(s); dataGridView_Data.DataSource = bll.sortKH_ThoiGianGiaoDich(); } }