Executar comando DDL
12/08/2012
0
string path = edtPath.Text;
string tabela = edtTabTemp.Text;
string carrega_csv = LOAD DATA LOCAL INFILE + path + + //D:\\CLS Documentos\\Script\\Base Itau_18.csv +
INTO TABLE temp_baixa_arquivo +
FIELDS TERMINATED BY ; +
LINES TERMINATED BY \n +
(operacao, contrato, dtcontrato);
MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings[conexaoMysql].ConnectionString;
MySqlCommand cmd = new MySqlCommand();
conn.Open();
cmd.Connection = conn;
cmd.CommandText = carrega_csv;
MySqlDataReader dr = cmd.ExecuteReader();
Pjava
Posts
13/08/2012
Pjava
Fatal error encountered during command execution.
private void GeraPlanilha()
{
string path = edtPath.Text;
string carrega_csv = LOAD DATA LOCAL INFILE + path + + //D:\\CLS Documentos\\Script\\Base Itau_18.csv +
IGNORE INTO TABLE temp_baixa_arquivo +
FIELDS TERMINATED BY ; +
LINES TERMINATED BY \n +
(operacao, contrato, dtcontrato);
MySqlConnection conn = new MySqlConnection();
MySqlDataAdapter da = new MySqlDataAdapter();
conn.ConnectionString = ConfigurationManager.ConnectionStrings[conexaoMysql].ConnectionString;
MySqlCommand cmd = new MySqlCommand();
conn.Open();
cmd.Connection = conn;
cmd.CommandText = carrega_csv;
cmd.CommandTimeout = 0;
cmd.ExecuteNonQuery(); }
13/08/2012
Pjava
string carrega_csv = @LOAD DATA LOCAL INFILE D:/CLS Documentos/Script/Base Itau_18 - teste simone.csv +
IGNORE INTO TABLE temp_baixa_arquivo +
FIELDS TERMINATED BY ; +
LINES TERMINATED BY \n +
(operacao, contrato, dtcontrato);
Ou seja, ele não aceita barras invertidas(\\). Isso me gera um problema, pois pelo OpenFileDialog, ele me gera barras invertidas e não barras normais. Tem como alterar isso?
16/08/2012
Joel Rodrigues
Boa sorte.
Clique aqui para fazer login e interagir na Comunidade :)