Torna al Thread
Label lblText1 = new Label();
Label lblText2 = new Label();
Label lblText3 = new Label();
Label lblText4 = new Label();
SqlDataSource SQLDataSourceDataGrid = new SqlDataSource();
GridView DataGridView = new GridView();
CommandField DataGridViewCommandField = new CommandField();
lblText1.Text = string.Format("{0} - ", listTableReference[Int32.Parse(queryStringValue), 2].ToString());
pnlForm2.Controls.Add(lblText1);
SQLStringForCommandDataSource.Append(string.Format("SELECT FieldName, Enabled FROM {0}",listTableReference[Int32.Parse(queryStringValue), 0].ToString()));
SqlDataAdapter sqlda2 = new SqlDataAdapter(SQLStringForCommandDataSource.ToString(),conn);
DataSet sqlds2 = new DataSet();
sqlda2.Fill(sqlds2, "FieldName");
SelectCommandSQLDataSource.Append("SELECT [");
UpdateCommandSQLDataSource.Append(string.Format("UPDATE {0} SET [", listTableReference[Int32.Parse(queryStringValue), 1].ToString()));
foreach (DataRow field in sqlds2.Tables[0].Rows) {
SelectCommandSQLDataSource.Append(string.Format("{0}], [", field["FieldName"].ToString()));
if (Convert.ToInt32(field["Enabled"]) == 1) {
UpdateCommandSQLDataSource.Append(string.Format("{0}] = @{0}, [", field["FieldName"].ToString()));
}
else {
ValueOFIDTable = field["FieldName"].ToString();
}
}
SelectCommandSQLDataSource.Remove(SelectCommandSQLDataSource.ToString().LastIndexOf(','), 3);
UpdateCommandSQLDataSource.Remove(UpdateCommandSQLDataSource.ToString().LastIndexOf(','), 3);
SelectCommandSQLDataSource.Append(string.Format(" FROM {0}", listTableReference[Int32.Parse(queryStringValue), 1].ToString()));
UpdateCommandSQLDataSource.Append(string.Format(" WHERE [{0}] = @{0}", ValueOFIDTable.ToString()));
DeleteCommandSQLDataSource.Append(string.Format("DELETE FROM [{0}] WHERE [{1}] = @{1}", listTableReference[Int32.Parse(queryStringValue), 1].ToString(), ValueOFIDTable.ToString()));
lblText3.Text = UpdateCommandSQLDataSource.ToString();
lblText2.Text = SelectCommandSQLDataSource.ToString();
lblText4.Text = DeleteCommandSQLDataSource.ToString();
pnlForm2.Controls.Add(lblText2);
pnlForm2.Controls.Add(lblText3);
pnlForm2.Controls.Add(lblText4);
SQLDataSourceDataGrid.ConnectionString = ConnString;
SQLDataSourceDataGrid.SelectCommand = SelectCommandSQLDataSource.ToString();
SQLDataSourceDataGrid.UpdateCommand = UpdateCommandSQLDataSource.ToString();
SQLDataSourceDataGrid.DeleteCommand = DeleteCommandSQLDataSource.ToString();
pnlForm2.Controls.Add(SQLDataSourceDataGrid);
DataGridView.AutoGenerateColumns = true;
DataGridView.DataKeyNames = new string[] {string.Format("{0}", ValueOFIDTable.ToString())};
DataGridViewCommandField.ShowEditButton = true;
DataGridViewCommandField.ShowDeleteButton = true;
DataGridView.Columns.Add(DataGridViewCommandField);
foreach (DataRow field in sqlds2.Tables[0].Rows)
{
BoundField DataGridViewBoundField = new BoundField();
DataGridViewBoundField.DataField = string.Format("{0}", field["FieldName"].ToString());
DataGridViewBoundField.HeaderText = string.Format("{0}", field["FieldName"].ToString());
DataGridViewBoundField.InsertVisible = false;
DataGridViewBoundField.ReadOnly = true;
DataGridViewBoundField.SortExpression = string.Format("{0}", field["FieldName"].ToString());
DataGridView.Columns.Add(DataGridViewBoundField);
}
DataGridView.DataSource = "SQLDataSourceGrid";
pnlForm2.Controls.Add(DataGridView);