private void treeView_BeforeSelect(object sender, TreeViewAdvCancelableSelectionEventArgs args) { if (treeView.SelectedNode.Parent != null) { ds.Tables.Clear(); if (!_server.Databases.Contains(treeView.SelectedNode.Parent.Text)) { grid.DataSource = null; MessageBox.Show(@"Baza o podanej nazwie nie istnieje."); } else { var connection = new SqlConnection( string.Format(@"Server=MOBILNY;Database={0};User Id=sa;Password=pass;", treeView.SelectedNode.Parent.Text)); var adapter = new SqlDataAdapter( "Select id, box, nazwa, nr_ident_dostawca, nr_ident_producent, stan_mag, stan_min, kod, dostawca, sekcja, data from " + treeView.SelectedNode.Text, connection); adapter.Fill(ds, treeView.SelectedNode.Text); grid.DataSource = ds.Tables[0]; } } }
private void treeView_BeforeSelect(object sender, TreeViewAdvCancelableSelectionEventArgs args) { if (treeView.SelectedNode.Parent != null) { ds.Tables.Clear(); if (!_server.Databases.Contains(treeView.SelectedNode.Parent.Text)) { grid.DataSource = null; MessageBox.Show(@"Baza o podanej nazwie nie istnieje."); } else { var connection = new SqlConnection( string.Format(@"Server=MOBILNY;Database={0};User Id=sa;Password=pass;", treeView.SelectedNode.Parent.Text)); var adapter = new SqlDataAdapter( "Select id, box, nazwa, nr_ident_dostawca, nr_ident_producent, stan_mag, stan_min, kod, dostawca, sekcja, data from " + treeView.SelectedNode.Text, connection); adapter.Fill(ds, treeView.SelectedNode.Text); grid.DataSource = ds.Tables[0]; } } }