Câu 3: OleDbConnection con = new OleDbConnection(); OleDbDataAdapter daMh; OleDbDataAdapter daDi; BindingSource bdsMh; BindingSource bdsDi; DataSet dsMhDi; private void F_LuongTrinhDo_Load(object sender, EventArgs e) { OleDbCommandBuilder cmdBuilder; DataTable dtMh, dtDi; DataRelation relation; ClassConnect clscon = new ClassConnect(); con = clscon.getConnection(); con.Open(); OleDbCommand cmd = new OleDbCommand(); daMh = new OleDbDataAdapter(select * from LOP, con); cmdBuilder = new OleDbCommandBuilder(daMh); daDi = new OleDbDataAdapter( Câu lệnh SQL tự làm dùm cái , con); cmdBuilder = new OleDbCommandBuilder(daDi); dsMhDi = new DataSet(dsMhDi); daMh.Fill(dsMhDi, Master); daDi.Fill(dsMhDi, Detail); dtMh = dsMhDi.Tables[Master]; dtDi = dsMhDi.Tables[Detail]; relation = new DataRelation(relMhDi, dtMh.Columns[MALOP], dtDi.Columns[MALOP]); dsMhDi.Relations.Add(relation); bdsMh = new BindingSource(); bdsMh.DataSource = dsMhDi; bdsMh.DataMember = Master; bdsDi = new BindingSource(); bdsDi.DataSource = bdsMh; bdsDi.DataMember = relMhDi; ccbMTD.DataSource = bdsMh; ccbMTD.ValueMember = MALOP; ccbMTD.DisplayMember = Master; ccbTD.DataBindings.Add(new Binding(Text, bdsMh, TENLOP, true)); ccbLN.DataBindings.Add(new Binding(Text, bdsMh, NGANHHOC, true)); dataGridView1.DataSource = bdsDi; } private void dataGridView1_RowStateChanged(object sender, DataGridViewRowStateChangedEventArgs e) { int i, sum = 0; int dong = dataGridView1.RowCount - 1; for (i = 0; i < dataGridView1.RowCount - 1; i++) { sum = sum + Convert.ToInt32(dataGridView1.Rows[i].Cells[6].Value); } label5.Text = sum.ToString(); }
Posted on: Sat, 20 Dec 2014 07:23:07 +0000
Trending Topics
Recently Viewed Topics
© 2015