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