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();
}
}
