public static void getCsvFilesList(TreeNodeMouseClickEventArgs e) { e.Node.Nodes.Clear(); string vCurrFolderName = e.Node.Text; FolderProperties vCurrFolder = In2SqlSvcCsv.vFolderList.Find(item => item.FolderName == vCurrFolderName); try { /* e.Node.SelectedImageIndex = 22; * e.Node.Tag = "CSV#"; * TreeNode vNodeTableFolder = new TreeNode("Tables".ToString(), 3, 3); * vNodeTableFolder.Tag = vCurrFolder.FolderName + "_csv"; * e.Node.Nodes.Add(vNodeTableFolder); */ initCsvObjects(ref vCurrFolder); foreach (var vCurrFile in vCurrFolder.Files) { TreeNode vNodeTable = new TreeNode(vCurrFile.Name, 22, 22); vNodeTable.Tag = vCurrFolder.FolderName + "|" + vCurrFile.Name + "|$FILE_CSV$"; e.Node.Nodes.Add(vNodeTable); TreeNode vNodeColumnTbl = new TreeNode(" ".ToString(), 99, 99); vNodeColumnTbl.Tag = vCurrFolder.FolderName + "." + vCurrFile.Name; vNodeTable.Nodes.Add(vNodeColumnTbl); } return; } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "getCsvFilesList 1 "); } }
public static void getCsvHeaders(TreeNodeMouseClickEventArgs e) { try { String vNodeTag = e.Node.Parent.Text + '.' + e.Node.Text; FilesAndProperties vCurrObjProp = In2SqlSvcCsv.vFileObjProp.Find(item => item.ObjName == vNodeTag); if (vCurrObjProp.objColumns == null) { In2SqlSvcCsv.vFileObjProp.AddRange(In2SqlSvcCsv.getCsvFileColumn(e.Node.Parent.Text, e.Node.Text)); vCurrObjProp = In2SqlSvcCsv.vFileObjProp.Find(item => item.ObjName == vNodeTag); } if (vCurrObjProp.objColumns != null) { if (vCurrObjProp.objColumns.Count > 0) { e.Node.Nodes.Clear(); foreach (var vCurrColumn in vCurrObjProp.objColumns) { TreeNode vNodeColumn = new TreeNode(vCurrColumn.ToString(), 14, 14); vNodeColumn.Tag = vNodeTag + '.' + vCurrColumn + "_clm"; e.Node.Nodes.Add(vNodeColumn); } } } } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "getColumnsandIndexes "); } }
public void PopulateOdbcTreeView(int vIsUI = 0) { try { TreeNode rootNode = new TreeNode("ODBC"); rootNode.Tag = "root"; GetODbcRecords(rootNode, vIsUI); treeODBC.Nodes.Add(rootNode); TreeNode rootCloud = new TreeNode("Сloud", 18, 18); rootCloud.Tag = "cloud"; TreeNode tnClickHouse = new TreeNode("ClickHouse", 19, 19); tnClickHouse.Tag = "ClickHouse"; GetCloudRecords(tnClickHouse, "CloudCH"); rootCloud.Nodes.Add(tnClickHouse); treeODBC.Nodes.Add(rootCloud); TreeNode rootCSV = new TreeNode("csv", 20, 20); rootCSV.Tag = "CSV"; GetCSVRecords(rootCSV); treeODBC.Nodes.Add(rootCSV); } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "PopulateOdbcTreeView"); } }
public static IEnumerable <OdbcProperties> getODBCList(RegistryKey rootKey) { RegistryKey regKey = rootKey.OpenSubKey(@"Software\ODBC\ODBC.INI\ODBC Data Sources"); if (regKey != null) { foreach (string name in regKey.GetValueNames()) { OdbcProperties vOdbcProperties = new OdbcProperties(); vOdbcProperties.OdbcName = regKey.GetValue(name, "").ToString(); if (vOdbcProperties.OdbcName.Contains("Microsoft ") == false) { try { vOdbcProperties.OdbcName = name; RegistryKey vCurrRegKey = rootKey.OpenSubKey(@"Software\ODBC\ODBC.INI\" + name); vOdbcProperties.Database = in2SqlRegistry.getLocalRegValue(vCurrRegKey, "Database"); vOdbcProperties.Description = in2SqlRegistry.getLocalRegValue(vCurrRegKey, "Description"); vOdbcProperties.Driver = in2SqlRegistry.getLocalRegValue(vCurrRegKey, "Driver"); vOdbcProperties.LastUser = in2SqlRegistry.getLocalRegValue(vCurrRegKey, "LastUser"); vOdbcProperties.Server = in2SqlRegistry.getLocalRegValue(vCurrRegKey, "Server"); vOdbcProperties.ConnStatus = 0; vCurrRegKey = Registry.CurrentUser.OpenSubKey(@"Software\in2sql"); vOdbcProperties.Login = in2SqlRegistry.getLocalRegValue(vCurrRegKey, name + '.' + "Login"); vOdbcProperties.Password = in2SqlRegistry.getLocalRegValue(vCurrRegKey, name + '.' + "Password"); } catch (Exception e) { In2SqlSvcTool.ExpHandler(e, "ODBCList"); } yield return(vOdbcProperties); } } } }
private void GetODbcRecords(TreeNode nodeToAddTo, int vIsUI = 0) { try { foreach (var vCurrCloudList in in2sqlSvcCloud.vCloudList) { string vv = vCurrCloudList.CloudName; } if (vIsUI == 0) { foreach (var vCurrvODBCList in In2SqlSvcODBC.vODBCList) { in2SqlRightPaneTreeTables.setODBCTreeLineSimple(nodeToAddTo, vCurrvODBCList.OdbcName); } return; } if (vIsUI == 1) { foreach (var vCurrvODBCList in In2SqlSvcODBC.vODBCList) { In2SqlSvcODBC.checkOdbcStatus(vCurrvODBCList.OdbcName); in2SqlRightPaneTreeTables.setODBCTreeLineComplex(nodeToAddTo, vCurrvODBCList.OdbcName, vCurrvODBCList.OdbcName); } return; } } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "GetODbcRecords"); } }
public static void setLocalValue(string vOdbcName, string vParameter, string vValue) { RegistryKey vCurrRegKey = Registry.CurrentUser.OpenSubKey(@"Software\in2sql", true); try { if (vCurrRegKey == null) { vCurrRegKey = Registry.CurrentUser.CreateSubKey(@"SOFTWARE\in2sql"); } if (vParameter.Contains("Password")) { vValue = Encrypt(vValue); } vCurrRegKey.SetValue(vOdbcName + '.' + vParameter, vValue); vCurrRegKey.Close(); } catch (Exception e) { In2SqlSvcTool.ExpHandler(e, "in2SQLRegistry.etLocalValue"); } }
public static string getLocalRegValue(RegistryKey vCurrRegKey, string vValue) { try { string vGetLocalRegValue = null; if (vCurrRegKey == null) { return(null); } if ((vCurrRegKey.GetValue(vValue, null) == null) == false) { vGetLocalRegValue = vCurrRegKey.GetValue(vValue).ToString();; } if (vValue.Contains("Password")) { vGetLocalRegValue = Decrypt(vGetLocalRegValue); } return(vGetLocalRegValue); } catch (Exception e) { In2SqlSvcTool.ExpHandler(e, "in2SQLRegistry.getLocalRegValue"); return(null); } }
/* public static void schedulueDeleteFile(string vFileName ) * { * RegistryKey vCurrRegKey = Registry.LocalMachine.OpenSubKey(@"CurrentControlSet\Control\Session Manager", true); * try * { * if (vCurrRegKey == null) * vCurrRegKey = Registry.CurrentUser.CreateSubKey(@"SOFTWARE\in2sql"); * * if (vParameter.Contains("Password")) * vValue = Encrypt(vValue); * * vCurrRegKey.SetValue(vOdbcName + '.' + vParameter, vValue); * * vCurrRegKey.Close(); * } * catch (Exception e) * { * In2SqlSvcTool.ExpHandler(e, "in2SQLRegistry.etLocalValue"); * } * } */ public static void delLocalValue(string vOdbcName) { RegistryKey vCurrRegKey = Registry.CurrentUser.OpenSubKey(@"Software\in2sql\", true); try { if (vCurrRegKey == null) { return; } vOdbcName = vOdbcName.Replace("#", ""); vOdbcName = vOdbcName.Replace("$", ""); if (vOdbcName.Contains("CloudCH")) { vCurrRegKey.DeleteValue(vOdbcName + ".Login"); vCurrRegKey.DeleteValue(vOdbcName + ".Password"); vCurrRegKey.DeleteValue(vOdbcName + ".Url"); } if (vOdbcName.Contains("Csv")) { vCurrRegKey.DeleteValue(vOdbcName + ".Path"); } vCurrRegKey.Close(); } catch (Exception e) { In2SqlSvcTool.ExpHandler(e, "in2SQLRegistry.etLocalValue"); } }
private void menuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e) { try { } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "treeODBC_AfterSelect"); } }
public static void getCloudTablesAndViews(TreeNodeMouseClickEventArgs e) { e.Node.Nodes.Clear(); string vCurrCloudName = e.Node.Text; CloudProperties vCurrCloud = in2sqlSvcCloud.vCloudList.Find(item => item.CloudName == vCurrCloudName); try { if ((in2sqlSvcCloud.checkCloudState(vCurrCloudName) < 0)) { return; } e.Node.ImageIndex = 2; e.Node.SelectedImageIndex = 2; e.Node.Tag = vCurrCloud.CloudType + '#'; TreeNode vNodeTableFolder = new TreeNode("Tables".ToString(), 3, 3); vNodeTableFolder.Tag = vCurrCloud.CloudName + "_tf"; e.Node.Nodes.Add(vNodeTableFolder); initCloudObjects(ref vCurrCloud); foreach (var vCurrTable in vCurrCloud.Tables) { TreeNode vNodeTable = new TreeNode(vCurrTable.Name, 4, 4); vNodeTable.Tag = vCurrCloud.CloudName + "|" + vCurrTable.Name + "|$TABLE_CLD$"; vNodeTableFolder.Nodes.Add(vNodeTable); TreeNode vNodeColumnTbl = new TreeNode(" ".ToString(), 99, 99); vNodeColumnTbl.Tag = vCurrCloud.CloudName + "." + vCurrTable.Name; vNodeTable.Nodes.Add(vNodeColumnTbl); } TreeNode vNodeViewFolder = new TreeNode("Views".ToString(), 5, 5); vNodeViewFolder.Tag = vCurrCloud.CloudName + "_vf"; e.Node.Nodes.Add(vNodeViewFolder); foreach (var vCurrView in vCurrCloud.Views) { TreeNode vNodeView = new TreeNode(vCurrView.Name, 6, 6); vNodeView.Tag = vCurrCloud.CloudName + "." + vNodeView.Name + "|$VIEW_CLD$"; vNodeViewFolder.Nodes.Add(vNodeView); TreeNode vNodeColumnVw = new TreeNode(" ".ToString(), 99, 99); vNodeColumnVw.Tag = vCurrCloud.CloudName + "." + vNodeView.Name; vNodeView.Nodes.Add(vNodeColumnVw); } return; } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "treeODBC_NodeMouseClick 1 "); } }
public static void ChangeOdbcValue(String vOdbcName, OdbcProperties vNewOdbcValue) { try { int vOdbcIndex = In2SqlSvcODBC.vODBCList.FindIndex(item => item.OdbcName == vOdbcName); vODBCList[vOdbcIndex] = vNewOdbcValue; } catch (Exception e) { In2SqlSvcTool.ExpHandler(e, "ChangeOdbcValue"); } }
private void treeODBC_AfterSelect(object sender, TreeViewEventArgs e) { try { /* string selectedNodeText = e.Node.Text; * DialogResult result = MessageBox.Show(selectedNodeText + " 1"); */ } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "treeODBC_AfterSelect"); } }
public static List <FolderProperties> FolderList() { try { List <FolderProperties> listClooudProperties = new List <FolderProperties>(); listClooudProperties.AddRange(getCsvList()); return(listClooudProperties); } catch (Exception e) { In2SqlSvcTool.ExpHandler(e, "CloudList"); return(null); } }
// var vCurrODBC = In2SqlSvcODBC.vODBCList.Find(item => item.OdbcName == vCurrvODBCList.OdbcName); public static string getODBCProperties(string vODBCName, string vProperties) { try { var vCurrODBC = In2SqlSvcODBC.vODBCList.Find(item => item.OdbcName == vODBCName); string vCurrProp = ""; if (vProperties.Contains("Database")) { vCurrProp = vCurrODBC.Database; } else if (vProperties.Contains("Description")) { vCurrProp = vCurrODBC.Description; } else if (vProperties.Contains("Driver")) { vCurrProp = vCurrODBC.Driver; } else if (vProperties.Contains("LastUser")) { vCurrProp = vCurrODBC.LastUser; } else if (vProperties.Contains("ConnErrMsg")) { vCurrProp = vCurrODBC.ConnErrMsg; } else if (vProperties.Contains("DBType")) { vCurrProp = vCurrODBC.DBType; } else if (vProperties.Contains("Login")) { vCurrProp = vCurrODBC.Login; } else if (vProperties.Contains("Password")) { vCurrProp = vCurrODBC.Password; } else if (vProperties.Contains("DSNStr")) { vCurrProp = vCurrODBC.DSNStr; } return(vCurrProp); } catch (Exception e) { In2SqlSvcTool.ExpHandler(e, "getODBCProperties"); return(null); } }
public static IEnumerable <String> sqlReadQuery(string vOdbcName, string queryString = "") { var vCurrODBC = In2SqlSvcODBC.vODBCList.Find(item => item.OdbcName == vOdbcName); using (OdbcConnection conn = new System.Data.Odbc.OdbcConnection()) { using (OdbcCommand cmnd = new OdbcCommand(queryString, conn)) { try { vCurrODBC.DSNStr = "DSN=" + vOdbcName; if (vCurrODBC.Login != null) { vCurrODBC.DSNStr = vCurrODBC.DSNStr + ";Uid=" + vCurrODBC.Login + ";Pwd=" + vCurrODBC.Password + ";"; } conn.ConnectionString = vCurrODBC.DSNStr; conn.ConnectionTimeout = 5; conn.Open(); } catch (Exception e) { In2SqlSvcTool.ExpHandler(e, "In2SqlSvcODBC.ReadData", queryString); conn.Close(); conn.Dispose(); yield break; } OdbcDataReader rd = cmnd.ExecuteReader(); string strRow = ""; while (rd.Read()) { strRow = ""; for (int i = 0; i < rd.FieldCount; i++) { strRow = strRow + '"' + rd.GetString(i) + '"'; if (i < rd.FieldCount - 1) { strRow += ","; } } yield return(strRow); conn.Close(); conn.Dispose(); } } } }
public static void getColumnsandIndexes(TreeNodeMouseClickEventArgs e) { try { String vNodeTag = e.Node.Parent.Parent.Text + '.' + e.Node.Text; var vCurrObjProp = In2SqlSvcODBC.vObjProp.Find(item => item.ObjName == vNodeTag); if (vCurrObjProp.objColumns == null) { In2SqlSvcODBC.vObjProp.AddRange(In2SqlSvcODBC.getObjectProperties(e.Node.Parent.Parent.Text, e.Node.Text)); vCurrObjProp = In2SqlSvcODBC.vObjProp.Find(item => item.ObjName == vNodeTag); } if (vCurrObjProp.objColumns != null) { if (vCurrObjProp.objColumns.Count > 0) { e.Node.Nodes.Clear(); foreach (var vCurrColumn in vCurrObjProp.objColumns) { TreeNode vNodeColumn = new TreeNode(vCurrColumn.ToString(), 14, 14); vNodeColumn.Tag = vNodeTag + '.' + vCurrColumn + "_clm"; e.Node.Nodes.Add(vNodeColumn); } if (e.Node.Tag.ToString().Contains("$TABLE$")) { e.Node.Tag = vNodeTag + ".TABLE"; TreeNode vNodeIndexFolder = new TreeNode("Indexes".ToString(), 12, 12); vNodeIndexFolder.Tag = vNodeTag + "_idx"; e.Node.Nodes.Add(vNodeIndexFolder); foreach (var vCurrIndx in vCurrObjProp.objIndexes) { TreeNode vNodeIndx = new TreeNode(vCurrIndx.ToString(), 13, 13); vNodeIndx.Tag = vNodeTag + '.' + vCurrIndx + "_idx"; vNodeIndexFolder.Nodes.Add(vNodeIndx); } } else { e.Node.Tag = vNodeTag + ".VIEW"; } } } } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "getColumnsandIndexes "); } }
private static void initSQlObjects(ref In2SqlSvcODBC.OdbcProperties vCurrOdbc) { try { if (vCurrOdbc.Tables == null) { vCurrOdbc.Tables = new List <In2SqlSvcODBC.SqlObjects>(); } if (vCurrOdbc.Views == null) { vCurrOdbc.Views = new List <In2SqlSvcODBC.SqlObjects>(); } if (vCurrOdbc.SQLProgramms == null) { vCurrOdbc.SQLProgramms = new List <In2SqlSvcODBC.SqlObjects>(); } if (vCurrOdbc.SQLFunctions == null) { vCurrOdbc.SQLFunctions = new List <In2SqlSvcODBC.SqlObjects>(); } if (vCurrOdbc.Tables.Count == 0) { vCurrOdbc.Tables.AddRange(In2SqlSvcODBC.getTableList(vCurrOdbc.OdbcName)); } if (vCurrOdbc.Views.Count == 0) { vCurrOdbc.Views.AddRange(In2SqlSvcODBC.getViewList(vCurrOdbc.OdbcName)); } if (vCurrOdbc.SQLProgramms.Count == 0) { vCurrOdbc.SQLProgramms.AddRange(In2SqlSvcODBC.getSQLProgrammsList(vCurrOdbc.OdbcName)); } if (vCurrOdbc.SQLFunctions.Count == 0) { vCurrOdbc.SQLFunctions.AddRange(In2SqlSvcODBC.getSQLFunctionsList(vCurrOdbc.OdbcName)); } } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "initSQlObjects"); } }
public void ExecDropDown(Office.IRibbonControl vControl) { try { /* string caption = "Information message"; * MessageBoxButtons buttons = MessageBoxButtons.YesNo; * DialogResult result; * * result = MessageBox.Show(vControl.Id, caption, buttons);*/ } catch (Exception e) { In2SqlSvcTool.ExpHandler(e, "ExecDropDown"); } }
public static List <OdbcProperties> ODBCList() { try { vIdtbl = 0; List <OdbcProperties> listOdbcProperties = new List <OdbcProperties>(); listOdbcProperties.AddRange(getODBCList(Registry.CurrentUser)); listOdbcProperties.AddRange(getODBCList(Registry.LocalMachine)); return(listOdbcProperties); } catch (Exception e) { In2SqlSvcTool.ExpHandler(e, "ODBCList"); return(null); } }
private void GetCSVRecords(TreeNode nodeToAddTo) { try { In2SqlSvcCsv.vFolderList = In2SqlSvcCsv.FolderList(); foreach (var vCurrFolder in In2SqlSvcCsv.vFolderList) { in2SqlRightPaneTreeTables.setCSVTreeLineSimple(nodeToAddTo, vCurrFolder.FolderName, "CSV$"); } return; } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "GetCloudRecords"); } }
public in2SqlWF03PanelRigtSqlM() { try { InitializeComponent(); PopulateOdbcTreeView(); initParam(); newToolStripButton_Click(null, null); SqlBuild(); // OdbcEditPanel(); CurrSqlPanel = this; } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "in2SqlRightPane"); } }
private static void initCsvObjects(ref In2SqlSvcCsv.FolderProperties vCurrCloudObj) { try { if (vCurrCloudObj.Files == null) { vCurrCloudObj.Files = new List <In2SqlSvcCsv.CloudObjects>(); } if (vCurrCloudObj.Files.Count == 0) { vCurrCloudObj.Files.AddRange(In2SqlSvcCsv.getFileList(vCurrCloudObj.FolderName)); } } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "initCloudObjects"); } }
private void GetCloudRecords(TreeNode nodeToAddTo, string vCloudType) { try { in2sqlSvcCloud.vCloudList = in2sqlSvcCloud.CloudList(); foreach (var vCurrCloudList in in2sqlSvcCloud.vCloudList) { if (vCurrCloudList.CloudType.Contains(vCloudType)) { in2SqlRightPaneTreeTables.setODBCTreeLineSimple(nodeToAddTo, vCurrCloudList.CloudName, vCloudType + '$'); } } return; } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "GetCloudRecords"); } }
public void PopulateExcelTreeView( ) { try { TreeNode rootTable = new TreeNode("Excel".ToString(), 4, 4); rootTable.Tag = "excel"; TreeNode vNodeExcelSheet = new TreeNode(" ".ToString(), 99, 99); rootTable.Nodes.Add(vNodeExcelSheet); treeExcelOtl.Nodes.Add(rootTable); TreeNode rootTask = new TreeNode("Tasks".ToString(), 3, 3); rootTask.Tag = "task"; TreeNode vNodeExcelTask = new TreeNode(" ".ToString(), 99, 99); rootTask.Nodes.Add(vNodeExcelTask); treeExcelOtl.Nodes.Add(rootTask); } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "PopulateOdbcTreeView"); } }
public static string writeSqlToFile(string vOdbcName, string queryString = "") { try { string vFileName = getTmpFileName(); using (StreamWriter vCurrFile = new StreamWriter(vFileName)) { foreach (var str in sqlReadQuery(vOdbcName, queryString)) { vCurrFile.WriteLine(str); } } return(vFileName); } catch (Exception e) { In2SqlSvcTool.ExpHandler(e, "In2SqlSvcTool.writeSqlToFile", vOdbcName + " # " + queryString); return(null); } }
public static string writeHttpToFile(string vHttpUrl) { try { string vFileName = getTmpFileName(); using (StreamWriter vCurrFile = new StreamWriter(vFileName)) { foreach (var str in HttpGetArray(vHttpUrl)) { vCurrFile.WriteLine(str); } } return(vFileName); } catch (Exception e) { In2SqlSvcTool.ExpHandler(e, "In2SqlSvcTool.writeHttpToFile", vHttpUrl); return(null); } }
private static void initCloudObjects(ref in2sqlSvcCloud.CloudProperties vCurrCloudObj) { try { if (vCurrCloudObj.Tables == null) { vCurrCloudObj.Tables = new List <in2sqlSvcCloud.CloudObjects>(); } if (vCurrCloudObj.Views == null) { vCurrCloudObj.Views = new List <in2sqlSvcCloud.CloudObjects>(); } if (vCurrCloudObj.SQLProgramms == null) { vCurrCloudObj.SQLProgramms = new List <in2sqlSvcCloud.CloudObjects>(); } if (vCurrCloudObj.SQLFunctions == null) { vCurrCloudObj.SQLFunctions = new List <in2sqlSvcCloud.CloudObjects>(); } if (vCurrCloudObj.Tables.Count == 0) { vCurrCloudObj.Tables.AddRange(in2sqlSvcCloud.getCloudTableList(vCurrCloudObj.CloudName)); } if (vCurrCloudObj.Views.Count == 0) { vCurrCloudObj.Views.AddRange(in2sqlSvcCloud.getCloudViewList(vCurrCloudObj.CloudName)); } } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "initCloudObjects"); } }
public static IEnumerable <String> SqlReadDataValue(string vOdbcName, string queryString = "") { var vCurrODBC = In2SqlSvcODBC.vODBCList.Find(item => item.OdbcName == vOdbcName); using (OdbcConnection conn = new System.Data.Odbc.OdbcConnection()) { using (OdbcCommand cmnd = new OdbcCommand(queryString, conn)) { try { vCurrODBC.DSNStr = "DSN=" + vOdbcName; if (vCurrODBC.Login != null) { vCurrODBC.DSNStr = vCurrODBC.DSNStr + ";Uid=" + vCurrODBC.Login + ";Pwd=" + vCurrODBC.Password + ";"; } conn.ConnectionString = vCurrODBC.DSNStr; conn.ConnectionTimeout = 5; conn.Open(); } catch (Exception e) { In2SqlSvcTool.ExpHandler(e, "In2SqlSvcODBC.ReadData", queryString); conn.Close(); conn.Dispose(); yield break; } OdbcDataReader rd = cmnd.ExecuteReader(); while (rd.Read()) { yield return(rd["value"].ToString());//.Split(',').ToList(); ; } conn.Close(); conn.Dispose(); } } }
private void treeODBC_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { try { miSelectNode = treeODBC.GetNodeAt(e.X, e.Y); if (e.Node.Tag != null) { if (e.Button == MouseButtons.Left) { expand_action(e); } else { contextMenu(e); } } } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "treeODBC_NodeMouseClick "); } }
public static void setODBCTreeLineComplex(TreeNode nodeToAddTo, string vCurrvListOdbcName, string VCurrOdbcName) { try { var vCurrODBC = In2SqlSvcODBC.vODBCList.Find(item => item.OdbcName == vCurrvListOdbcName); if ((vCurrODBC.ConnStatus == 0)) { setODBCTreeLineSimple(nodeToAddTo, vCurrvListOdbcName); return; } if (vCurrODBC.ConnStatus < 0) { TreeNode vNodeDatabase = new TreeNode(vCurrODBC.OdbcName, 7, 7); nodeToAddTo.Nodes.Add(vNodeDatabase); vNodeDatabase.Tag = "ODBC%"; TreeNode vNodeTable = new TreeNode(vCurrODBC.ConnErrMsg, 99, 99); vNodeDatabase.Nodes.Add(vNodeTable); return; } if ((vCurrODBC.ConnStatus == 1) & vCurrvListOdbcName.Contains(VCurrOdbcName) & vCurrvListOdbcName.Length == VCurrOdbcName.Length) { initSQlObjects(ref vCurrODBC); } if (vCurrODBC.ConnStatus == 1 & (vCurrODBC.Tables.Count == 0 & vCurrODBC.Views.Count == 0)) { TreeNode vNodeDatabase = new TreeNode(vCurrODBC.OdbcName, 2, 2); nodeToAddTo.Nodes.Add(vNodeDatabase); vNodeDatabase.Tag = "ODBC#"; return; } if (vCurrODBC.ConnStatus == 1 & (vCurrODBC.Tables.Count > 0 | vCurrODBC.Views.Count > 0)) { TreeNode vNodeDatabase = new TreeNode(vCurrODBC.OdbcName, 2, 2); nodeToAddTo.Nodes.Add(vNodeDatabase); vNodeDatabase.Tag = "ODBC#"; if (vCurrODBC.Tables.Count > 0) { TreeNode vNodeTableFolder = new TreeNode("Tables".ToString(), 3, 3); vNodeTableFolder.Tag = vCurrODBC.OdbcName + "tf"; vNodeDatabase.Nodes.Add(vNodeTableFolder); foreach (var vCurrTable in vCurrODBC.Tables) { TreeNode vNodeTable = new TreeNode(vCurrTable.Name, 4, 4); // vNodeTable.Tag = vCurrTable.Name; vNodeTableFolder.Nodes.Add(vNodeTable); } } if (vCurrODBC.Views.Count > 0) { TreeNode vNodeViewFolder = new TreeNode("Views".ToString(), 5, 5); vNodeViewFolder.Tag = vCurrODBC.OdbcName + "vf"; vNodeDatabase.Nodes.Add(vNodeViewFolder); foreach (var vCurrView in vCurrODBC.Views) { TreeNode vNodeView = new TreeNode(vCurrView.Name, 6, 6); // vNodeTable.Tag = vCurrTable.Name; vNodeViewFolder.Nodes.Add(vNodeView); } } } } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "setODBCTreeLineComplex"); } }