private void btnSave_Click_1(object sender, EventArgs e)
{
try
{
DialogResult dialog = MessageBox.Show("Are you sure to save the changes in Database ",
"Yes", MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
for (int i = 0; i < grdList.Rows.Count; i++)
{
if (grdList.Rows[i].Cells["ColumnValue"].Value.ToString().Length > 0)
{
////grdList.Rows[i].Cells["ColumnValue"].Value =
//// grdList.Rows[i].Cells["ColumnValue"].Value.ToString().Replace
//// (txtToSearch.Text, txtToReplace.Text);
SchemaItemsDB.updateValueinDB(grdList.Rows[i].Cells["TableName"].Value.ToString(),
grdList.Rows[i].Cells["ColumnName"].Value.ToString(),
grdList.Rows[i].Cells["ColumnValue"].Value.ToString());
}
}
grdList.CurrentCell = grdList.Rows[0].Cells[0];
}
}
catch (Exception ex)
{
}
}
private void ListTableColumns()
{
try
{
string query = "";
string cType = "";
string[] comparisonList = { "char", "varchar" };
grdList.Rows.Clear();
SchemaItemsDB schemaitemsdb = new SchemaItemsDB();
List <ColumnDetail> Columns = SchemaItemsDB.getColumnDetail();
foreach (ColumnDetail cd in Columns)
{
////cType= cd.columnType;
if (!comparisonList.Contains(cd.columnType))
{
continue;
}
string cvalues = SchemaItemsDB.getColumnValues(cd.tableName, cd.columnName, txtToSearch.Text.Trim());
////query = "SELECT STUFF( (SELECT ';~!@#' + CONVERT(varchar(10),RowID) + '~!@#' " +
//// cd.columnName +
//// " FROM " + cd.tableName +
//// " where "+ cd.columnName +
//// " like '%"+txtToSearch.Text.Trim()+"%' FOR XML PATH('')),1, 1, '')";
grdList.Rows.Add();
grdList.Rows[grdList.RowCount - 1].Cells["TableName"].Value = cd.tableName;
grdList.Rows[grdList.RowCount - 1].Cells["ColumnName"].Value = cd.columnName;
grdList.Rows[grdList.RowCount - 1].Cells["ColumnType"].Value = cd.columnType;
grdList.Rows[grdList.RowCount - 1].Cells["ColumnValue"].Value = cvalues;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
enableBottomButtons();
pnlSearchResult.Visible = true;
}
