void init_dataset()
{
string strAccessSelect = "SELECT index,bezeichnung,artikelnr,typ FROM katalog order by index";
OleDbConnection cnn = new OleDbConnection(strCnn);
OleDbCommand myCommand = new OleDbCommand(strAccessSelect, cnn);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myCommand);
cnn.Open();
myDataSet = new DataSet();
try
{
myDataAdapter.Fill(myDataSet, "katalog");
myDataTable = myDataSet.Tables["katalog"];
myDataTable.Columns[0].ColumnName = "Index";
myDataTable.Columns[1].ColumnName = "Bezeichnung";
myDataTable.Columns[2].ColumnName = "Artikel-Nr.";
myDataView = new DataView(myDataTable,
"typ = 1", "", DataViewRowState.CurrentRows);
dataGridView1.DataSource = myDataView;
}
catch
{
MessageBox.Show(" Error!!!", "Suchergebniss");
}
finally
{
dataGridView1.Columns[0].Width = 70;
dataGridView1.Columns[1].Width = 400;
dataGridView1.Columns[0].Width = 77;
dataGridView1.Columns[3].Visible = false;
cnn.Close();
}
}
|