如何通过提供动态表名从Sql表中获取计数? [英] How Do I Get Count From Sql Table By Giving Dynamic Tablename?
问题描述
大家好,
i希望通过在select语句中给出动态表名来从sql表中获取数。
i尝试如下
y = Session [m] .ToString();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(select *来自'+ y +',o);
da.Fill(dt);
int count = dt.Rows.Count;
但它不起作用。
请给我一些解决方案。
Hi all,
i would like to get count from sql table by giving dynamic table name in select statement.
i tried like below
y = Session[m].ToString();
DataTable dt = new DataTable();
SqlDataAdapter da= new SqlDataAdapter("select * from '"+y+"'",o);
da.Fill(dt);
int count = dt.Rows.Count;
But it is not working.
please gve me some solution.
推荐答案
不需要为表名提供单引号。尝试下面
no need to have single quotes for table name. try below
SqlDataAdapter da= new SqlDataAdapter("select * from "+y,o);
或者你可以使用 ExecuteScalar
下面的方法
or you can use ExecuteScalar
method like below
using(SqlCommand cmd = new SqlCommand("select Count(*) from "+y, o))
{
int count = Convert.ToInt32(cmd.ExecuteScalar());
}
这篇关于如何通过提供动态表名从Sql表中获取计数?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!