如何根据SQL中特定表的列显示数据？ [英] How to show data based on columns for a particular table in SQL?

问题描述

我想基于Sql中特定报告的列显示数据。列（例如名称，年龄等）和要获取的表是根据报告从DataBase中获取的。我需要在选择查询中获取这些列（比如姓名，年龄等）。



我尝试了什么：



尝试现在需要动态的静态查询。

I want to show data based on columns for a particular report in Sql. The columns (say name,age etc) and table to fetch are taken from DataBase based upon the report. i need to fetch these columns(say name,age etc) in select query.

What I have tried:

Tried static query which needs to be dynamic now.

推荐答案

List<string> list=new List<string>; //fill this list with the columns you want
string cmdtxt="SELECT "; 
for(int i=0;i<=list.length;i++)
{
cmdtxt += list[i] + ",";
}
cmdtxt=cmdtxt.Remove(cmdtxt.Length-1);
cmd.commandtext= cmdtxt + "FROM mytbl"; //ur query here
cmd.executenonquery();

希望这有帮助



编辑： 添加到代码块

这篇关于如何根据SQL中特定表的列显示数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！