public static void ExecuteQuery(string qry)
{
//if (ConnectionStatus() == false || qry == "")
//{
MysqlInterface.close();
MysqlInterface.init();
//}
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandText = qry;
int numRowsUpdated = cmd.ExecuteNonQuery();
cmd.Dispose();
}
private void fmImport_Load(object sender, EventArgs e)
{
DataGridViewTextBoxColumn col = new DataGridViewTextBoxColumn();
string column = "Columns";
col.HeaderText = column;
col.Name = "f" + column;
dgXLTable.Columns.Add(col);
col = new DataGridViewTextBoxColumn();
col.HeaderText = column;
col.Name = "f" + column;
dgXLTransfer.Columns.Add(col);
col = new DataGridViewTextBoxColumn();
col.HeaderText = column;
col.Name = "f" + column;
dgCWTransfer.Columns.Add(col);
col = new DataGridViewTextBoxColumn();
col.HeaderText = column;
col.Name = "f" + column;
dgCWTable.Columns.Add(col);
try
{
MySqlDataReader rdr = null;
string table = "";
rdr = MysqlInterface.DoQuery("SHOW TABLES;");
while (rdr.Read())
{
table = rdr.GetString(0);
cbTable.Items.Add(table);
}
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
MysqlInterface.close();
}
}
//string stm = "SELECT id, description, purchase_price FROM part"
public static MySqlDataReader DoQuery(string qry)
{
try
{
MysqlInterface.close();
MysqlInterface.init();
MySqlDataReader rdr = null;
MySqlCommand cmd = new MySqlCommand(qry, con);
rdr = cmd.ExecuteReader();
cmd.Dispose();
return(rdr);
}
catch (MySqlException err)
{
Console.WriteLine("Error: " + err.ToString());
return(null);
}
}
private void cbTable_SelectedIndexChanged(object sender, EventArgs e)
{
dgCWTable.RowCount = 1;
dgCWTable.Rows.Clear();
dgCWTable.Columns.Clear();
dgCWTable.AutoGenerateColumns = false;
try
{
MySqlDataReader rdr = null;
string table = cbTable.Text;
string column = "";
rdr = MysqlInterface.DoQuery("SHOW COLUMNS FROM " + table + ";");
DataGridViewTextBoxColumn col = new DataGridViewTextBoxColumn();
column = "Columns";
col.HeaderText = column;
col.Name = "f" + column;
dgCWTable.Columns.Add(col);
while (rdr.Read())
{
column = rdr.GetString(0);
string[] row = { column };
dgCWTable.Rows.Add(row);
}
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
MysqlInterface.close();
}
}