public void Search_DataMatrix()
{
lvDM.Items.Clear();
if (txt_Search.Text != "")
{
madeDbConnection();
string str_Keyword = txt_Search.Text;
MySqlCommand objCommand = objDBCon.CreateCommand();
MySqlDataReader ObjReader;
objCommand.CommandText = "select * from DataMatrix where DM_Experiment = '" + str_Keyword
+ "%' OR DM_Researcher LIKE '%" + str_Keyword
+ "%' OR DM_TubeNumber LIKE '%" + str_Keyword
+ "%' OR DM_RackNumber LIKE '%" + str_Keyword
+ "%' OR DM_Position LIKE '%" + str_Keyword
+ "%' OR DM_Strain LIKE '%" + str_Keyword + "%'";
ObjReader = objCommand.ExecuteReader();
while (ObjReader.Read())
{
string str_DB_Data = "";
for (int i = 0; i < ObjReader.FieldCount; i++)
{
str_DB_Data += ObjReader.GetValue(i).ToString() + ";";
}
loadDBData(str_DB_Data);
}
closeDbConnection();
}
}
public void loadData_fromDB()
{
lvDM.Items.Clear();
madeDbConnection();
MySqlCommand objCommand = objDBCon.CreateCommand();
MySqlDataReader ObjReader;
objCommand.CommandText = "select * from DataMatrix";
ObjReader = objCommand.ExecuteReader();
while (ObjReader.Read())
{
string str_DB_Data = "";
for (int i = 0; i < ObjReader.FieldCount; i++)
{
str_DB_Data += ObjReader.GetValue(i).ToString() + ";";
}
loadDBData(str_DB_Data);
}
closeDbConnection();
}