本文介绍了如何在数据库mysql中保存所有数据集表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我无法使用dataadapter将所有数据集的表保存在数据库中。当我试图保存这个时,只有第一张表被保存而其他表没有。



我尝试了什么:



我使用mysql workbrenck中的存储过程从数据库获取数据:



I can't save all dataset's tables in database using dataadapter. When I try to save this, only first table is saved the others not.

What I have tried:

I get data from database using stored procedure in mysql workbrenck:

CREATE DEFINER=`root`@`localhost` PROCEDURE `Tabelas_Materia_Prima`()
BEGIN

	SELECT * FROM materia_prima_ar order by 'DATA';
    SELECT * FROM materia_prima_amido order by 'DATA';
    SELECT * FROM materia_prima_art order by 'DATA';
    SELECT * FROM materia_prima_umidade order by 'DATA';
    SELECT * FROM materia_prima_pol order by 'DATA';
    SELECT * FROM materia_prima_infeccao order by 'DATA';
    SELECT * FROM materia_prima_imp_veg order by 'DATA';
    SELECT * FROM materia_prima_imp_min order by 'DATA';
    SELECT * FROM materia_prima_fosfato order by 'DATA';
    SELECT * FROM materia_prima_fibra order by 'DATA';
    SELECT * FROM materia_prima_dextrana order by 'DATA';

END





所以,我这样做在表数据中修改,然后我尝试在datatable中保存表,但只保存第一个表。 :(。如何在数据库中保存所有数据表?





So, I do modification in tables data, then I try to save tables in datatable, but only first table is saved. :(. How can I save all datatable in database?

public void Salvar_Procedure(DataSet Dados, string Nome_Procedure)
        {
            MySqlConnection Conexao = new MySqlConnection(StringConexao);

            //OdbcConnection Conexao = new OdbcConnection("DSN=YasFashion_Sacoleiro_DB");

            MySqlCommand Comando = new MySqlCommand();
            Comando.Connection = Conexao;
            Comando.CommandType = CommandType.StoredProcedure;
            Comando.CommandText = Nome_Procedure;
            MySqlDataAdapter Meu_Adaptador = new MySqlDataAdapter(Comando);

            //OdbcDataAdapter Meu_Adaptador = new OdbcDataAdapter("SELECT * FROM " + Nome_Tabela, Conexao);

            try
            {
                Conexao.Open();

                MySqlCommandBuilder Comando01 = new MySqlCommandBuilder(Meu_Adaptador);

                //OdbcCommandBuilder Comando = new OdbcCommandBuilder(Meu_Adaptador);

                Meu_Adaptador.Update(Dados);

                Conexao.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Erro de salvamento: \n" + ex);
            }
        }

推荐答案


这篇关于如何在数据库mysql中保存所有数据集表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-20 07:34
查看更多