如何通过VB.net对数据库进行查询 [英] how to make a query to database by VB.net

问题描述

你好朋友..
我有一个可以连接SQl SErver并能够将数据从SQL Serverr导出到Excel工作表的应用程序. 现在我的查询是
对于每一次我不想将整个数据导出到Excel.
我希望通过查询作为选择日期或任何字段，以便我可以过滤数据并且可以仅导出与该查询有关的数据..
请帮助我如何在我选择表格的代码中进行查询...

Hello Frnds..
I have an application which i can connect the SQl SErver and able to Export data from SQL serverr to Excel sheet..
now my query is
for each and every time i don''t want to export the entire data to Excel.
i am looking to pass query as selecting date or any field so that i can filter data and i can export data for only related to that query ..
please help me how to make a query in the code where i am slecting the table...

推荐答案

这是一篇有关该主题的很好的综合文章
http://www.w3schools.com/sql/sql_quickref.asp [通过C#访问SQL Server的入门指南 [ ^ ]
尽情享受，并记住好问题会给出好的答案.

Here is a good comprehensive article on the subject
http://www.w3schools.com/sql/sql_quickref.asp[^]

OK, bear in mind that your question very unclear - and it doesn''t seem like you''ve gone through the effort of actually looking on this site for possible answers to your query.
Here is a link to a more useful place for learning with your slightly expanded explanation about your problem:

how to pass query by date SQL Server in C# coding
Beginners guide to accessing SQL Server through C#[^]
Enjoy, and remember good questions gives good answers.

这篇关于如何通过VB.net对数据库进行查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！