public ActionResult GetAllTables(string sDBname) { var ret = new QueryResult(); ret.retCode = false; SqlConnUtil connInfo = Session[KEY_LOGINFO] as SqlConnUtil; if (connInfo == null) { return(Json(ret)); } //取数据库的所有用户表 using ( var dbConn = new NativeDBHelper(connInfo.DBHost, connInfo.DBUser, connInfo.DBPassword, sDBname) ) { var lsTabs = dbConn.GetTables(); var jss = new JavaScriptSerializer(); ret.sData = jss.Serialize(lsTabs); ret.retCode = true; } return(Json(ret)); }
private void btnQuery_Click(object sender, EventArgs e) { string strSql = this.tboxSql.Text.Trim(); if (string.IsNullOrEmpty(strSql)) { return; } if (!CheckValid(strSql)) { FrmMain.PromptError(MyRes.Err_QueryInvalid); return; } Cursor.Current = System.Windows.Forms.Cursors.AppStarting; using ( var dbConn = new NativeDBHelper(m_connector.DBHost, m_connector.DBUser, m_connector.DBPassword, m_connector.CurDBName) ) { var dt = dbConn.Execute(strSql); ShowData(null, dt); } Cursor.Current = System.Windows.Forms.Cursors.Default; }
public ActionResult GetTabData(string sDBname, string sTable) { var tinfo = new TableInfo(); SqlConnUtil connInfo = Session[KEY_LOGINFO] as SqlConnUtil; if (null == connInfo) { return(View(tinfo)); } //取数据库的所有用户表 using ( var dbConn = new NativeDBHelper(connInfo.DBHost, connInfo.DBUser, connInfo.DBPassword, sDBname) ) { var dt = dbConn.GetDataFromTableTopN(sTable, TableInfo.QUERY_LIMIT_LINE); if (null == dt) { return(View(tinfo)); } tinfo.FillBy(dt); } return(View(tinfo)); }
private Tuple <string, DataTable> LeftTree_QueryDataByNode(int nLimit = -1) { var curNode = this.treeObj.SelectedNode; var sDBName = LeftTree_GetDBNameFromPath(curNode.FullPath); Tuple <string, DataTable> retQuery = new Tuple <string, DataTable>(null, null); m_connector.CurDBName = sDBName; var sTabName = curNode.Text; using ( var dbConn = new NativeDBHelper(m_connector.DBHost, m_connector.DBUser, m_connector.DBPassword, sDBName) ) { StringBuilder sb = new StringBuilder(); if (nLimit < 0) { sb.AppendFormat("select * from {0}", sTabName); } else { sb.AppendFormat("select top {0} * from {1}", nLimit, sTabName); } var sSql = sb.ToString(); var dt = dbConn.Execute(sb.ToString()); retQuery = new Tuple <string, DataTable>(sSql, dt); return(retQuery); //return (nLimit < 0) ? dbConn.GetDataFromTable(sTabName) : dbConn.GetDataFromTableTopN(sTabName, 100); } }
/// <summary> /// 取表的所有列信息 /// </summary> /// <param name="clkNode"></param> private void LeftTree_FillNodeCols(TreeNode clkNode) { Cursor.Current = System.Windows.Forms.Cursors.AppStarting; clkNode.Nodes.Clear(); var dbNode = clkNode.Parent; var sTabName = dbNode.Text; var sDBName = LeftTree_GetDBNameFromPath(clkNode.FullPath); m_connector.CurDBName = sDBName; using ( var dbConn = new NativeDBHelper(m_connector.DBHost, m_connector.DBUser, m_connector.DBPassword, sDBName) ) { //var lsCols = dbConn.GetColumnsEx(sTabName); var lsCols = dbConn.GetColumns(sTabName); StringBuilder sb = new StringBuilder(100); foreach (var sCol in lsCols) { sb.AppendFormat("{0},{1},{2}", sCol.Item1.ToString(), sCol.Item2.ToString(), sCol.Item3.ToUpper()); var nodeTab = clkNode.Nodes.Add(sb.ToString()); nodeTab.ImageIndex = IMG_IND_COL; nodeTab.SelectedImageIndex = IMG_IND_CUR; sb.Clear(); } } clkNode.Expand(); Cursor.Current = System.Windows.Forms.Cursors.Default; }
private void LeftTree_FillNodeTables(TreeNode clkNode) { Cursor.Current = System.Windows.Forms.Cursors.AppStarting; clkNode.Nodes.Clear(); var dbNode = clkNode.Parent; var sDBName = dbNode.Text; m_connector.CurDBName = sDBName; using ( var dbConn = new NativeDBHelper(m_connector.DBHost, m_connector.DBUser, m_connector.DBPassword, sDBName) ) { var lsTabs = dbConn.GetTables(); foreach (var sTab in lsTabs) { var nodeTab = clkNode.Nodes.Add(sTab); nodeTab.ImageIndex = IMG_IND_TAB; nodeTab.SelectedImageIndex = IMG_IND_CUR; var nodeCol = nodeTab.Nodes.Add(MyRes.TXT_ALL_COL); nodeCol.ImageIndex = IMG_IND_COL; nodeCol.SelectedImageIndex = IMG_IND_CUR; nodeCol.Nodes.Add(STR_QUERYING); // } } clkNode.Expand(); Cursor.Current = System.Windows.Forms.Cursors.Default; }
public void DisConnect() { if (null != m_nativeDBHelper) { m_nativeDBHelper.Dispose(); m_nativeDBHelper = null; } if (null != fnClearTree) { fnClearTree(); } }
/// <summary> /// 尝试连接 /// </summary> /// <returns>是否成功</returns> public bool TryConnect() { if (string.IsNullOrEmpty(DBHost) || string.IsNullOrEmpty(DBUser)) { return(false); } m_nativeDBHelper = new NativeDBHelper(DBHost, DBUser, DBPassword); bool bConn = m_nativeDBHelper.IsConnected(); if (bConn && (null != fnRefreshTree)) { //var databases = m_nativeDBHelper.GetAllDatabases(); var databases = m_nativeDBHelper.GetAllDatabases2(); //test var userDBs = from x in databases where !IsSysDatabase(x) select x; fnRefreshTree(userDBs.ToList()); } return(bConn); }