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];
}
}
}
