11使用Vb.net将SQL查询结果发送到一个Excel工作表 [英] 11 SQL Query results to one excel sheet using Vb.net

问题描述

需要帮助!!我不是程序员，但我是自然灾害分析师。我有11平方的查询，当我点击一个按钮时会产生结果。让我解释一下......



我有11个单选按钮，每个单选按钮分配给一个sql查询。我将这些SQL查询的结果存储在数据集中。所以它就像11个单选按钮11个SQL查询和11个数据集。



当用户点击单选按钮（用户可以选择多个按钮）并点击生成报告按钮我希望数据集将带有列名的记录传输到另一个下面的Excel电子表格。



是否可以将所有这些结果一个接一个地放在另一个列中同一个Excel表格中的名称（表1）。我试过基于你之前的所有反馈，但不知何故无法做到。我没有VBA知识，我必须在大约2天内完成。任何

Need help!! I’m not a programmer but I’m a Natural disaster analyst. I have 11 sq. queries which will generate results when I click a button. Let me explain...

I have 11 radio buttons, where each radio button is assigned to one sql query. I’m storing the results of these SQL queries in a dataset. So it is like 11 radio buttons 11 SQL queries and 11 dataset.

When the user click the radio button (user can selected multiple buttons) and click on generate report button I want the dataset to transfer the records with the column names to an excel spreadsheet one below another.

Is it possible to have all these results one below the other with column names in a same excel sheet (sheet 1). I tried based on all your earlier feedback but somehow not able to do it. I have zero VBA knowledge and I have to complete this in about 2 days. Any

推荐答案

这篇关于11使用Vb.net将SQL查询结果发送到一个Excel工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！