public void dateshow(string title, string value) { OleDbDataAdapter da = new OleDbDataAdapter(); DataSet ds = new DataSet(); DataView dv = new DataView(); try { da = Dbconnect.datareader(title, value); } catch (Exception e) { MessageBox.Show(e.Message); return; } da.Fill(ds); dv = ds.Tables[0].DefaultView; dv.AllowNew = false; this.DATAGRID.DataSource = dv;//表从起始行显示在dataGridView里 this.DATAGRID.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill; DATAGRID.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; DATAGRID.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; this.DATAGRID.ReadOnly = true; for (int i = 0; i < DATAGRID.RowCount; i++) { this.DATAGRID.Rows[i].Cells[0].Value = "False"; } this.DATAGRID.ReadOnly = false; this.DATAGRID.Columns["ID"].Visible = false; for (int a = 0; a < ds.Tables[0].Columns.Count; a++) { this.DATAGRID.Columns[a + 2].ReadOnly = true; } backgroundchange(); }
private void dataFill() { OleDbDataReader data; data = Dbconnect.changereader(ID); nameBox.Text = data["客户姓名"].ToString(); carComboBox.Text = data["车行"].ToString(); bankComboBox.Text = data["经办支行"].ToString(); cardIdBox.Text = data["卡号"].ToString(); managerBox.Text = data["客户经理姓名"].ToString(); examineMoneyBox.Text = data["审批金额"].ToString(); carPriceBox.Text = data["车辆价格"].ToString(); carTypeBox.Text = data["购买车型"].ToString(); if (data["抵押情况"].ToString() == "1") { mortgate.Checked = true; } else { nomortgate.Checked = true; } if (data["系统申请"].ToString() == "1") { newsystem.Checked = true; } else { oldsystem.Checked = true; } MoneyOut.text = data["放款日期"].ToString().Replace("0:00:00", ""); ControlDate.text = data["车辆抵押日期"].ToString().Replace("0:00:00", ""); examineDate.text = data["二级分行审核日期"].ToString().Replace("0:00:00", ""); }
private void toolStripButton2_Click(object sender, EventArgs e) { ArrayList name = new ArrayList(); this.DATAGRID.ReadOnly = true; for (int i = 0; i < DATAGRID.RowCount; i++) { string b; DataGridViewCell checkbox = (DataGridViewCell)this.DATAGRID.Rows[i].Cells[0]; if ((string)checkbox.Value == "True") { b = DATAGRID.Rows[i].Cells[2].Value.ToString(); name.Add(b); } } if (MessageBox.Show("确定删除" + name.Count + "条数据吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK) { Dbconnect dbconnect = new Dbconnect(); foreach (string a in name) { try { dbconnect.deletedata(a, path); } catch (Exception ex) { MessageBox.Show(ex.Message); } } this.DATAGRID.ReadOnly = false; dateshow(); } }
private void droplist() { OleDbDataReader bank, car; bank = Dbconnect.bankcombobox(); while (bank.Read()) { bankComboBox.Items.Add(bank[0].ToString()); //循环读区数据 } car = Dbconnect.carcombobox(); while (car.Read()) { carComboBox.Items.Add(car[0].ToString()); //循环读区数据 } }
private void added() { string name, bank, car, manager, cardid, exampric, carpric, cartype, date, datecontrol, examdate; int Mortgate = 0, system = 0; name = nameBox.Text; car = carComboBox.Text; bank = bankComboBox.Text; cardid = cardIdBox.Text; manager = managerBox.Text; exampric = examineMoneyBox.Text; carpric = carPriceBox.Text; cartype = carTypeBox.Text; if (newsystem.Checked == true) { system = 1; } if (oldsystem.Checked == true) { system = 0; } if (nomortgate.Checked == true) { Mortgate = 0; } if (mortgate.Checked == true) { Mortgate = 1; } date = MoneyOut.Text; datecontrol = ControlDate.Text; examdate = examineDate.text; Dbconnect db = new Dbconnect(); if (name != "" && bank != "" && car != "" && manager != "" && cartype != "" && date != "" && datecontrol != "" && cardid != "" && exampric != "") { try { db.addcarcombobox(car); db.addnewdata(name, bank, car, manager, cardid, exampric, carpric, cartype, Mortgate, date, datecontrol, system, examdate); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } } }