/// <summary> /// 更新特定的一筆資料 /// </summary> /// <param name="MenuTitle"></param> /// <param name="SQLStatement"></param> public void Edit(string Title, string ContentText, string UserID, string Password) { Fill(); DataRow[] drStore = null; if (SqlTabData is SQLStoreDataSet.SQLTableDataTable) { drStore = (SqlTabData as SQLStoreDataSet.SQLTableDataTable).Select(string.Format("SQLCommandName='{0}'", Title)); drStore[0]["SQL"] = ContentText; } else if (SqlTabData is SQLStoreDataSet.SqlConnectionTableDataTable) { SQLStoreDataSet.SqlConnectionTableDataTable tabCnn = SqlTabData as SQLStoreDataSet.SqlConnectionTableDataTable; SetIsDefaultByDataSourceName(tabCnn, Title); drStore = tabCnn.Select(string.Format("ConnName='{0}'", Title)); drStore[0]["InitialCatalogName"] = ContentText; drStore[0]["UserID"] = UserID; drStore[0]["Password"] = Password; } if (drStore == null) { return; } Write(); }
/// <summary> /// 將 DataSourceName 設定為預設的連線. /// </summary> /// <param name="tab"></param> /// <param name="DataSourceName"></param> private void SetIsDefaultByDataSourceName( SQLStoreDataSet.SqlConnectionTableDataTable tab, string DataSourceName) { foreach (DataRow row in tab.Rows) { row["IsDefault"] = false; } DataRow[] drCnn = tab.Select(string.Format("DataSourceName='{0}'", DataSourceName)); foreach (DataRow rowSelect in drCnn) { rowSelect["IsDefault"] = true; } }
private void GetData() { SQLStoreDataSet.SqlConnectionTableDataTable tabConn = ConnStore.GetAllData(); cbServer.DisplayMemberPath = "DataSourceName"; cbServer.SelectedValuePath = "DataSourceName"; cbServer.ItemsSource = tabConn; //帶入上一次的 Default 值. var result = tabConn.Rows.OfType <DataRow>().Where(r => (bool)r["IsDefault"]).FirstOrDefault(); if (result != null) { cbServer.Text = result["DataSourceName"].ToString(); txtPassword.Password = result["Password"].ToString(); txtUserID.Text = result["UserId"].ToString(); } }
private void GetData() { SQLStoreDataSet.SqlConnectionTableDataTable tabConn = ConnStore.GetAllData(); cbServer.DisplayMember = "DataSourceName"; cbServer.ValueMember = "DataSourceName"; cbServer.DataSource = tabConn; //帶入上一次的 Default 值. var result = tabConn.Rows.OfType <DataRow>().Where(r => (bool)r["IsDefault"]).FirstOrDefault(); if (result != null) { cbServer.Text = result["DataSourceName"].ToString(); txtPassword.Text = result["Password"].ToString(); txtUserID.Text = result["UserId"].ToString(); cbInitialCatalog.Text = result["InitialCatalogName"].ToString(); chkSetDefault.Checked = (bool)result["IsDefault"]; chkUseLocalDB.Checked = result["UseLocalDB"] != DBNull.Value ? (bool)result["UseLocalDB"] : false; } }
/// <summary> /// 取得一筆資料 (DataRow) /// </summary> /// <param name="Title">要查詢的條件 (如果是:SqlDataTable 就是SQLCommandName,如果是SqlConnectionTable 就使用DataSourceName)</param> /// <returns></returns> public DataRow GetOne(string Title) { DataRow result = null; if (SqlTabData is SQLStoreDataSet.SqlConnectionTableDataTable) //如果是:SqlConnectionTableDataTable 就是DataSourceName { SQLStoreDataSet.SqlConnectionTableDataTable c = SqlTabData as SQLStoreDataSet.SqlConnectionTableDataTable; DataRow[] dr = c.Select(string.Format("DataSourceName='{0}'", Title)); if (dr.Length > 0) { result = dr[0]; } } else if (SqlTabData is SQLStoreDataSet.SQLTableDataTable) //如果是SQLTableDataTable 就使用SQLCommandName { SQLStoreDataSet.SQLTableDataTable dt = SqlTabData as SQLStoreDataSet.SQLTableDataTable; DataRow[] dr = dt.Select(string.Format("SQLCommandName='{0}'", Title)); if (dr.Length > 0) { result = dr[0]; } } return(result); }