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);
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5