private void tsDataCompare_Click(object sender, EventArgs e)
{
FrmDataCompare frm = new FrmDataCompare();
frm.MdiParent = this;
frm.Show();
}
private void dgw1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (!btnStart.Enabled)
{
if (e.RowIndex >= 0)
{
//if (e.ColumnIndex == 0)
{
string table = dgw1.Rows[e.RowIndex].Cells[0].FormattedValue.ToString();
lblDetails.Text = "details of table: " + table;
string query = "select * from CHANGETABLE(CHANGES "
+ table
+ ", " + changeVersion.ToString() + ") x ";
using (SqlConnection connection = new SqlConnection(GlobalVar.connString))
{
connection.Open();
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = connection;
sqlCmd.CommandType = CommandType.Text;
sqlCmd.CommandText = query;
SqlDataAdapter sqlDataAdap = new SqlDataAdapter(sqlCmd);
DataTable dtRecord = new DataTable();
sqlDataAdap.Fill(dtRecord);
dgw2.DataSource = dtRecord;
dgw2.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
}
}
if (e.ColumnIndex == 1)
{
string query = " select * from " + dgw1.Rows[e.RowIndex].Cells[0].FormattedValue.ToString();
for (int row = 0; row < dgw2.RowCount; row++)
{
query += (row == 0) ? " where (" : " or (";
for (int col = 5; col < dgw2.ColumnCount; col++)
{
query += (col == 5) ? "" : " and ";
query += dgw2.Columns[col].HeaderText.ToString() + "=";
query += "'" + dgw2.Rows[row].Cells[col].FormattedValue.ToString() + "'";
}
query += ") ";
}
FrmDataCompare frm = new FrmDataCompare();
frm.LoadFromCaller(query);
frm.MdiParent = this.MdiParent;
frm.Show();
}
}
}
}