private void button4_Click(object sender, EventArgs e) { if (txtcombo.Text == "Form ID") { label1.Hide(); Global.Open_DataConn("doc", "conData"); OleDbDataAdapter da = new OleDbDataAdapter("SELECT WCDCH.formid, WCDCH.surname, WCDCH.firstname, WCDCH.midname, WCDCH.ttransid FROM WCDCH INNER JOIN bankdata ON WCDCH.formid = bankdata.formid", Global.conData); DataSet ds = new DataSet(); da.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; label2.Show(); label3.Text = dataGridView1.RowCount.ToString(); } else if (txtcombo.Text == "TransactionID") { label2.Hide(); Global.Open_DataConn("doc", "conData"); OleDbDataAdapter da = new OleDbDataAdapter("SELECT WCDCH.formid, WCDCH.surname, WCDCH.firstname, WCDCH.midname, WCDCH.ttransid FROM WCDCH INNER JOIN bankdata ON WCDCH.ttransid = bankdata.ttransid", Global.conData); DataSet ds = new DataSet(); da.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; label1.Show(); label3.Text = dataGridView1.RowCount.ToString(); } else { MessageBox.Show("Please,Select which you want"); } }
int noofRec ds.Tables[0].rows.count;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)