private void btn_run_Click(object sender, EventArgs e) { if (cmb_connections.Text == "" || cmb_connections.Text.Length == 0) { MessageBox.Show("No connection Selected. Please Refresh Connection list."); } else { dg.DataSource = null; if (txt.SelectedText.Length == 0) { tbl = sql.Execute_DataTable(txt.Text, Convert.ToInt32(cmb_connections.SelectedValue)); } else { tbl = sql.Execute_DataTable(txt.SelectedText, Convert.ToInt32(cmb_connections.SelectedValue)); } dg.DataSource = tbl; DataRow dr = tbl_res.NewRow(); dr[0] = DateTime.Now; if (txt.SelectedText.Length == 0) { dr[1] = txt.Text; } else { dr[1] = txt.SelectedText; } dr[2] = sql.WorkerResult.Message; tbl_res.Rows.Add(dr); if (sql.WorkerResult.Result) { txt_Status.Text = "SUCCESS"; txt_Status.ForeColor = Color.ForestGreen; tabControl1.SelectedIndex = 0; } else { txt_Status.Text = "ERROR"; txt_Status.ForeColor = Color.IndianRed; tabControl1.SelectedIndex = 1; } } }
private void tv_connections_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { if (e.Button == MouseButtons.Right) { if (e.Node.Name == "PATH") { e.Node.ContextMenuStrip = menu_connect; curr_node = e.Node; //menu_connect.Show(); } else if (e.Node.Name == "CONN") { e.Node.ContextMenuStrip = menu_connection; curr_node = e.Node; } else if (e.Node.Name == "TABLE") { e.Node.ContextMenuStrip = menu_table; curr_node = e.Node; } } txt_status.Text = e.Node.Name; if (e.Node.Name == "TABLE" || e.Node.Name == "VIEW") { var connId = Convert.ToInt32(e.Node.Tag); txt_query.Text = ""; dg_data.DataSource = null; tbl = obj_sql.Execute_DataTable("SELECT sql FROM sqlite_master WHERE tbl_name='" + e.Node.Text + "'", connId); if (tbl.Rows.Count != 0) { txt_query.Text = tbl.Rows[0][0].ToString(); } else { txt_status.Text = obj_sql.WorkerResult.Message; return; } // MessageBox.Show(e.Node.Tag.ToString()); tbl = obj_sql.Execute_DataTable("SELECT * from " + e.Node.Text + " limit 100" , connId); if (tbl.Rows.Count != 0) { dg_data.DataSource = tbl; } else { txt_status.Text = obj_sql.WorkerResult.Message; } using (SQLiteDataReader dr = obj_sql.Execute_DataReader($"SELECT * FROM {e.Node.Text} WHERE 1=2", connId)) { dg_struct.DataSource = dr.GetSchemaTable().AsEnumerable() .Select(x => new { ColumnOrdinal = x.Field <int>("ColumnOrdinal"), ColumnName = x.Field <string>("ColumnName"), DataTypeName = x.Field <string>("DataTypeName"), AllowDBNull = x.Field <bool>("AllowDBNull"), IsKey = x.Field <bool>("IsKey"), IsAutoIncrement = x.Field <bool>("IsAutoIncrement") }).ToList(); } } }