将存储过程中的数据写入.dbf文件c#

本文关键字：dbf 文件 数据 存储 存储过程 过程中 | 更新日期: 2023-09-27 17:57:41

如何使用c#从存储的proc中选择数据并将其插入file.dbf？我有一些代码：

OleDbConnection lDbfConnection = new OleDbConnection(connectionString);
        try
        {
            lDbfConnection.Open();
            OleDbParameter lScript = new OleDbParameter(
                "script",
                 @"create table Result (colums parameters)
                 OleDbCommand lOleDbCommand = lDbfConnection.CreateCommand();
                 lOleDbCommand.CommandType = CommandType.StoredProcedure;
                 lOleDbCommand.CommandText = "ExecScript";
                 lOleDbCommand.Parameters.Add(lScript);
                 lOleDbCommand.ExecuteNonQuery();
                 lOleDbCommand = lDbfConnection.CreateCommand();
                 lOleDbCommand.CommandText = "insert into Result(colums)

//我需要的代码

                  SqlConnection lProcConnection = new SqlConnection(lConnect);
                  SqlCommand lCommand = new SqlCommand(lProcName, lProcConnection);
                  lCommand.CommandType = CommandType.StoredProcedure;
                  //input parameters
                  lCommand.Parameters.Add("ParamName", SqlDbType.Type).Value =SomeValue; 
                  lProcConnection.Open();
                  ......

将存储过程中的数据写入.dbf文件c#

您可以使用VfpClient来帮助您。

这里有一个例子：

using(var connection = new SqlConnection("connectionString")) {
    using(var command = connection.CreateCommand()) {
        command.CommandText = "storedProcedure";
        command.CommandType = CommandType.StoredProcedure;
        var data = new DataTable("TableName");
        // This will execute the stored procedure and put the data in a data table.
        var adapter = new SqlDataAdapter(command);
        adapter.Fill(data);
        // This will create a dbc.
        var dbc = @"c:'Data'Data.dbc";
        var dbcCreator = new VfpClient.Utils.DbcCreator.DataTableDbcCreator(dbc);
        // This will create a dbf with the data retrieved from the stored procedure.
        dbcCreator.Add(data);
    }
}
相关文章：