I try Transfer Checked box data in Another DataGridView show a Problem Without Error
Problem is when i Checked only one row From my first DataGridView then in second DataGridView only generate column but data not show , but when i checked second row from First DataGridView then in second DataGridView only Show Second Selected Data not Both
i try
private void LoanData()
{
String connstring = ConfigurationManager.ConnectionStrings["FincorpData"].ConnectionString;
using (OleDbConnection con = new OleDbConnection(connstring))
{
con.Open();
using (OleDbDataAdapter da = new OleDbDataAdapter("select InstallmentNumber, LoanNumber, InstallmentDate, LoanAmount from installment where LoanNumber = @LoanNumber", con))
{
da.SelectCommand.Parameters.AddWithValue("@LoanNumber", txtLoanNumber.Text);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].Width = 50;
dataGridView1.Columns[0].ReadOnly = true;
dataGridView1.Columns[1].Width = 85;
dataGridView1.Columns[1].ReadOnly = true;
dataGridView1.Columns[2].Width = 110;
dataGridView1.Columns[2].ReadOnly = true;
dataGridView1.Columns[3].Width = 80;
dataGridView1.Columns[3].ReadOnly = true;
}
}
DataGridViewCheckBoxColumn chbox = new DataGridViewCheckBoxColumn();
chbox.HeaderText = "";
chbox.Width = 30;
chbox.Name = "checkBoxColumn";
dataGridView1.Columns.Insert(0, chbox);
}
private void btnFind_Click(object sender, EventArgs e)
{
if (IsValidated())
{
try
{
LoanData();
}
catch (ApplicationException ex)
{
MessageBox.Show("Error:" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
What I have tried:
This Code For Data Show in Second DataGridView
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.Add("InstallmentNumber");
dt.Columns.Add("LoanNumber");
dt.Columns.Add("InstallmentDate");
foreach (DataGridViewRow row in dataGridView1.Rows)
{
bool isSelected = Convert.ToBoolean(row.Cells["checkBoxColumn"].Value);
if (isSelected)
{
dt.Rows.Add(row.Cells[1].Value, row.Cells[2].Value, row.Cells[3].Value);
}
}
dataGridView2.DataSource = dt;
}