private void FillMyComboV1() { // kaupungit cbCountries.ItemsSource = DBPlacebo.GetCitiesFromSQLServer(ConnStr, TableName).DefaultView; cbCountries.DisplayMemberPath = "city"; cbCountries.SelectedValuePath = "city"; }
public void btnGet3Students_Click(object sender, EventArgs e) { DataTable dt = DBPlacebo.Get3TestStudents(); gvData.DataSource = dt; gvData.DataBind(); }
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; } }
public void btnGetAllStudents_Click(object sender, EventArgs e) { string connectionString = ConfigurationManager.ConnectionStrings["Students"].ConnectionString; string message = ""; try { DataTable dt = DBPlacebo.GetAllStudentsFromSQLServer(connectionString, "oppilaat", out message); gvData.DataSource = dt; gvData.DataBind(); lblMessages.Text = message; } catch (Exception ex) { lblMessages.Text = 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 btnGetFrom_Click(object sender, RoutedEventArgs e) { //Haetaan asiakastiedot palvelimelta string messu = ""; try { cbCountries.ItemsSource = DBPlacebo.GetCitiesFromSQLServer(ConnStr, TableName).DefaultView; } catch (Exception ex) { messu = ex.Message; } finally { lbMessages.Content = messu; } }
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; } }
private void btnGet3_Click(object sender, RoutedEventArgs e) { dgCustomers.ItemsSource = DBPlacebo.GetTestCustomers().DefaultView; }