public static SqlCeDataAdapter GetAdaperForProcessInfosViewForDate(PTDate date) { SqlCeDataAdapter adapter = null; SqlCeConnection connection = null; try { connection = Connection(); connection.Open(); var command = connection.CreateCommand(); command.CommandText = "SELECT Name, ActiveTime FROM ProcessInfos WHERE DateIdx=@dateIdx"; command.Parameters.Add("@dateIdx", SqlDbType.Int).Value = date.index; command.ExecuteNonQuery(); adapter = new SqlCeDataAdapter(command); Console.WriteLine(adapter.ToString()); } finally { connection.Close(); } return(adapter); }
private void FindData() { if (author.Length > 0) { _adapter = new SqlCeDataAdapter("SELECT isbn AS ISBN, title AS Title, author AS Author, year AS Year, publisher AS Publisher, binding AS Binding, pagenumber AS \"Page number\" FROM books WHERE author='" + author + "'", _connection); MessageBox.Show(_adapter.ToString()); /* * DataTable table = new DataTable(); * _adapter.Fill(table); * dataGridView.DataSource = table; * RemoveDataFromTextFields(); */ } else if (title.Length > 0) { _adapter = new SqlCeDataAdapter("SELECT isbn AS ISBN, title AS Title, author AS Author, year AS Year, publisher AS Publisher, binding AS Binding, pagenumber AS \"Page number\" FROM books WHERE title='" + title + "'", _connection); DataTable table = new DataTable(); _adapter.Fill(table); dataGridView.DataSource = table; RemoveDataFromTextFields(); } else if (isbn.Length > 0) { _adapter = new SqlCeDataAdapter("SELECT isbn AS ISBN, title AS Title, author AS Author, year AS Year, publisher AS Publisher, binding AS Binding, pagenumber AS \"Page number\" FROM books WHERE isbn='" + isbn + "'", _connection); DataTable table = new DataTable(); _adapter.Fill(table); dataGridView.DataSource = table; RemoveDataFromTextFields(); } else if (yearOi.Length > 0) { _adapter = new SqlCeDataAdapter("SELECT isbn AS ISBN, title AS Title, author AS Author, year AS Year, publisher AS Publisher, binding AS Binding, pagenumber AS \"Page number\" FROM books WHERE year='" + yearOi + "'", _connection); DataTable table = new DataTable(); _adapter.Fill(table); dataGridView.DataSource = table; RemoveDataFromTextFields(); } else if (publisher.Length > 0) { _adapter = new SqlCeDataAdapter("SELECT isbn AS ISBN, title AS Title, author AS Author, year AS Year, publisher AS Publisher, binding AS Binding, pagenumber AS \"Page number\" FROM books WHERE publisher='" + publisher + "'", _connection); DataTable table = new DataTable(); _adapter.Fill(table); dataGridView.DataSource = table; RemoveDataFromTextFields(); } else if (binding.Length > 0) { _adapter = new SqlCeDataAdapter("SELECT isbn AS ISBN, title AS Title, author AS Author, year AS Year, publisher AS Publisher, binding AS Binding, pagenumber AS \"Page number\" FROM books WHERE binding='" + binding + "'", _connection); DataTable table = new DataTable(); _adapter.Fill(table); dataGridView.DataSource = table; RemoveDataFromTextFields(); } else if (nmbrOfPgs.Length > 0) { _adapter = new SqlCeDataAdapter("SELECT isbn AS ISBN, title AS Title, author AS Author, year AS Year, publisher AS Publisher, binding AS Binding, pagenumber AS \"Page number\" FROM books WHERE pagenumber='" + nmbrOfPgs + "'", _connection); DataTable table = new DataTable(); _adapter.Fill(table); dataGridView.DataSource = table; RemoveDataFromTextFields(); } else { UpdateTable(); } }