protected override void ApplyCommand(Session session, QueryJson query) { session.WriteLog("Select command: " + query.Message); DataTableJson buf = DataBaseOperations.ExecuteDataTable(query); buf.Dependence = DataTableDependeces.GetTableDependence(query.TableName); session.Dialog.SendMessage(buf); }
public void PrintListTables(string tableName, DataTableJson dt) { ListBox_Tables.Items.Clear(); DataTable dataTable = DataTableJson.Deserialize(tableName, dt); foreach (DataRow row in dataTable.Rows) { ListBox_Tables.Items.Add(row[0].ToString()); } }
public void PrintDataGridViewDataTable(DataTableJson data) { CurrentTable.Dependences = data.Dependence; DataSet dataSet = new DataSet(); StringReader xmlreader = new StringReader(data.DataTable); dataSet.ReadXml(xmlreader); CurrentTable.CurTable = dataSet.Tables[CurrentTable.Name]; Binding.DataSource = CurrentTable.CurTable; DataGridView_MainView.AutoResizeColumns( DataGridViewAutoSizeColumnsMode.AllCells); foreach (DataGridViewColumn c in DataGridView_MainView.Columns) { c.SortMode = DataGridViewColumnSortMode.NotSortable; } }
public static DataTableJson ExecuteDataTable(QueryJson command) { SqlDataAdapter adapter = new SqlDataAdapter(command.Message, Connection); DataTable dataTable = new DataTable(command.TableName); adapter.Fill(dataTable); StringBuilder xmlString = new StringBuilder(); var xmlWriter = XmlWriter.Create(xmlString); dataTable.WriteXml(xmlWriter); DataTableJson dataTableJson = new DataTableJson() { Code = OperationCode.AnswerOK, DataTable = xmlString.ToString(), }; return(dataTableJson); }