private void GetDataFromSQL() { string message = ""; table = DBPlacebo.GetAllCustomersFromSQLServer(connectionString, tableName, "", out message); view = table.DefaultView; dgCustomers.ItemsSource = table.DefaultView; lbMessages.Content = message; }
private void IniMyStuff() { try { string msg = ""; connStr = Properties.Settings.Default.Tietokanta; lbMessages.Content = connStr; tableName = Properties.Settings.Default.Taulu; dt = DBPlacebo.GetAllCustomersFromSQLServer(connStr, tableName, "", out msg); FillMyCombo(); lbMessages.Content = msg; } catch (Exception ex) { lbMessages.Content = ex.Message; } }
private void SuodataVE1() { string message = ""; string city = ""; try { if (cbCountries.SelectedIndex >= 0) { city = cbCountries.SelectedValue.ToString(); dgCustomers.ItemsSource = DBPlacebo.GetAllCustomersFromSQLServer(ConnStr, TableName, city, out message).DefaultView; } } catch (Exception ex) { message = ex.Message; } finally { lbMessages.Content = message; } }
private void IniMyStuff() { //TODO täytetään combobox asiakkaitten maitten nimillä //esimerkki kuinka App.Configissa oleva connectionstring luetaan string message = ""; try { ConnStr = JAMK.ICT.Properties.Settings.Default.Tietokanta; lbMessages.Content = ConnStr; TableName = JAMK.ICT.Properties.Settings.Default.Taulu; dt = DBPlacebo.GetAllCustomersFromSQLServer(ConnStr, TableName, "", out message); dv = dt.DefaultView; FillMyCombo(); } catch (Exception ex) { lbMessages.Content = ex.Message; } }
private void InitMyStuff() { try { string message = ""; //esimerkki kuinka App.Configissa oleva connectionstring luetaan connStr = Properties.Settings.Default.Tietokanta; lbMessages.Content = connStr; tableName = Properties.Settings.Default.Taulu; dtCustomerData = DBPlacebo.GetAllCustomersFromSQLServer(connStr, tableName, "", out message); // Luodaan DataTablen oletusnäkymästä DataView view = dtCustomerData.DefaultView; FillMyCombo(); lbMessages.Content = message; } catch (Exception ex) { lbMessages.Content = ex.Message; } }
private void SuodataVE1() { //Haetaan asiakastiedot palvelimelta string messu = ""; string kaupunki = ""; try { if (cbCountries.SelectedIndex >= 0) { kaupunki = cbCountries.SelectedValue.ToString(); dgCustomers.ItemsSource = DBPlacebo.GetAllCustomersFromSQLServer(ConnStr, TableName, kaupunki, out messu).DefaultView; } } catch (Exception ex) { messu = ex.Message; } finally { lbMessages.Content = messu; } }