private void searchData(string keywords, string category, string expansion)
{
bool added = false;
string SQL = "SELECT ID, Name, Category, Expansion FROM Models WHERE ";
if (keywords != null)
{
//Special thingy for Keywords
string[] newKeys = keywords.Split(Convert.ToChar(" "));
SQL += " (";
for (int i = 0; i < newKeys.Length; i++)
{
if (i == 0) SQL += " Name LIKE '%" + newKeys[i] + "%'";
else SQL += " AND Name LIKE '%" + newKeys[i] + "%'";
}
SQL += ") ";
added = true;
}
if (category != null)
{
if (added == true) SQL += " AND Category = '" + category + "' ";
else
{
added = true;
SQL += " Category = '" + category + "' ";
}
}
if (expansion != null)
{
if (added == true) SQL += " AND Expansion = '" + expansion + "' ";
else
{
added = true;
SQL += " Expansion = '" + expansion + "' ";
}
}
//MessageBox.Show(SQL);
XmlDbConnection connect = null;
try
{
connect = new XmlDbConnection(xmlfile);
IDbDataAdapter adapter = new XmlDbDataAdapter(new XmlDbCommand(SQL, connect));
itemModels.Tables["Models"].Clear();
adapter.Fill(itemModels);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
if (connect != null) connect.Close();
}
}
private void searchData(string keywords, string category, string expansion)
{
bool added = false;
string SQL = "SELECT ID, Name, Category, Expansion FROM Models WHERE ";
if (keywords != null)
{
//Special thingy for Keywords
string[] newKeys = keywords.Split(Convert.ToChar(" "));
SQL += " (";
for (int i = 0; i < newKeys.Length; i++)
{
if (i == 0)
{
SQL += " Name LIKE '%" + newKeys[i] + "%'";
}
else
{
SQL += " AND Name LIKE '%" + newKeys[i] + "%'";
}
}
SQL += ") ";
added = true;
}
if (category != null)
{
if (added == true)
{
SQL += " AND Category = '" + category + "' ";
}
else
{
added = true;
SQL += " Category = '" + category + "' ";
}
}
if (expansion != null)
{
if (added == true)
{
SQL += " AND Expansion = '" + expansion + "' ";
}
else
{
added = true;
SQL += " Expansion = '" + expansion + "' ";
}
}
//MessageBox.Show(SQL);
XmlDbConnection connect = null;
try
{
connect = new XmlDbConnection(xmlfile);
IDbDataAdapter adapter = new XmlDbDataAdapter(new XmlDbCommand(SQL, connect));
itemModels.Tables["Models"].Clear();
adapter.Fill(itemModels);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
if (connect != null)
{
connect.Close();
}
}
}