public void loadDb_fromSystem()
{
string filepath = Server.MapPath("~/data/");
uint ret = m_IndexSearch.InitEngine();
string szFileName = filepath + "" + db_filename + ".ISDB";
m_IndexSearch.ClearDB();
uint ret_load = NBioAPI.Error.NONE;
ret_load = m_IndexSearch.LoadDBFromFile(szFileName);
if (ret_load != NBioAPI.Error.NONE)
{
Response.Write("File not found ");
return;
}
filepath = Server.MapPath("~/data/");
szFileName = filepath + "" + db_filename + ".FID";
FileStream fs = new FileStream(szFileName, FileMode.Open, FileAccess.Read);
StreamReader fr = new StreamReader(fs);
while (fr.Peek() >= 0)
{
try
{
string szLine = fr.ReadLine();
string[] szSplit = szLine.Split('\t');
newDT = new DataTable();
newDT = dtbl;
DataRow row = newDT.NewRow();
row["UserID"] = szSplit[0];
row["Fp ID"] = szSplit[1];
row["Sample No"] = szSplit[2];
newDT.Rows.Add(row);
newDT.AcceptChanges();
}
catch (Exception erp)
{
Response.Write("Error" + erp);
}
}
fr.Close();
fs.Close();
//GridView1.DataSource = newDT;
//GridView1.DataBind();
DataTable temp_data = newDT;
Session["tempSession"] = temp_data;
Identify_user();
}
private void btnLoadFile_Click(object sender, System.EventArgs e)
{
uint ret = NBioAPI.Error.NONE;
DialogResult dr = MessageBox.Show("If you load database from file, existing memory database will be cleared!\nAre you sure you want to load database?", "IndexSearchDemoCS", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr != DialogResult.Yes)
{
return;
}
OpenFileDialog openFileDialog1 = new System.Windows.Forms.OpenFileDialog();
string szFileName = "";
openFileDialog1.Filter = "ISDB files (*.ISDB)|*.ISDB|All files (*.*)|*.*";
if (openFileDialog1.ShowDialog(this) != DialogResult.OK)
{
return;
}
szFileName = openFileDialog1.FileName;
if (szFileName != "")
{
// Clear ListView of SearchDB
listSearchDB.Items.Clear();
// Clear IndexSearchDB
m_IndexSearch.ClearDB();
// Load SearchDB from File
ret = m_IndexSearch.LoadDBFromFile(szFileName);
if (ret != NBioAPI.Error.NONE)
{
DisplayErrorMsg(ret);
return;
}
listSearchDB.Items.Clear();
// Load list from file
szFileName = Path.ChangeExtension(szFileName, "FID");
FileStream fs = new FileStream(szFileName, FileMode.Open, FileAccess.Read);
StreamReader fr = new StreamReader(fs);
while (fr.Peek() >= 0)
{
try
{
string szLine = fr.ReadLine();
string[] szSplit = szLine.Split('\t');
ListViewItem listItem = new ListViewItem();
listItem.Text = szSplit[0];
listItem.SubItems.Add(szSplit[1]);
listItem.SubItems.Add(szSplit[2]);
listSearchDB.Items.Add(listItem);
}
catch
{
break;
}
}
fr.Close();
fs.Close();
MessageBox.Show("Load SearchDB to file success!");
}
else
{
MessageBox.Show("You must enter filename !", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnLoadFile_Click(object sender, System.EventArgs e)
{
uint ret = NBioAPI.Error.NONE;
string szFileName = "";
//Caminho do arquivo com as digitais
DirectoryInfo Dir = new DirectoryInfo(@"C:\Users\MC114\Desktop\iteva.ISDB");
szFileName = Dir.FullName;
if (szFileName != "")
{
// Clear ListView of SearchDB
listSearchDB.Items.Clear();
// Clear IndexSearchDB
m_IndexSearch.ClearDB();
// Load SearchDB from File
ret = m_IndexSearch.LoadDBFromFile(szFileName);
if (ret != NBioAPI.Error.NONE)
{
DisplayErrorMsg(ret);
return;
}
listSearchDB.Items.Clear();
// Load list from file
szFileName = Path.ChangeExtension(szFileName, "FID");
FileStream fs = new FileStream(szFileName, FileMode.Open, FileAccess.Read);
StreamReader fr = new StreamReader(fs);
while (fr.Peek() >= 0)
{
try
{
String[] nomes = new string[] { };
string szLine = fr.ReadLine();
string[] szSplit = szLine.Split('\t');
String config = "server=localhost; database=lanche; userid=root; password=vertrigo;";
MySqlConnection conexao = new MySqlConnection(config);
string query = "SELECT apelido FROM users where id =" + szSplit[0];
//instância do comando onde passo
//a query e a conexão
MySqlCommand cmd = new MySqlCommand(query, conexao);
//Abro conexão
conexao.Open();
//instância do leitor que recebe
//o comando
MySqlDataReader leitor = cmd.ExecuteReader();
leitor.Read();
//MessageBox.Show("" + leitor["apelido"]);
//]essageBox.Show(i + "");
//nomes[i] = leitor["apelido"].ToString();
// MessageBox.Show(nomes[0]);
//atribuo os valores do bd
//fecho conexão
conexao.Close();
ListViewItem listItem = new ListViewItem();
listItem.Text = szSplit[0];
//listItem.SubItems.Add(leitor["apelido"].ToString());
listItem.SubItems.Add(szSplit[2]);
listItem.SubItems.Add(szSplit[1]);
listSearchDB.Items.Add(listItem);
}
catch
{
break;
}
}
fr.Close();
fs.Close();
}
else
{
MessageBox.Show("Erro ao carregar arquivo !", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
