菜鸟问:如何获取数据行数
本菜鸟想写个取数据行数的代码,但是后变不知道怎么写了(真正的菜鸟),麻烦哪位好心人给看看,怎么写,还有 objCmd.CommandText = "select * from 设备总表 where 行名称=session("depart"),行名称=session("depart"),系统报错,要用session("depart")参数,怎么调用?麻烦好心人写清楚点,最好有文字说明,谢谢了Dim objConn As New Data.SqlClient.SqlConnection
objConn.ConnectionString = "Data Source=HAW\sqlexpress;Initial Catalog=数据库;Integrated Security=True"
objConn.Open()
Dim objCmd As New Data.SqlClient.SqlCommand
Dim aa As String
Dim dt As Integer
aa = Session("depart")
objCmd.Connection = objConn
objCmd.CommandText = "select * from 设备总表 where 行名称='@aa'"“这样写似乎也是有问题的,没实验过”
万分感谢!!!!!
--------------------编程问答-------------------- --------------------编程问答-------------------- [code=C#]
string sql = @"select * from tb where id='"+Session["id"].Tostring()+"' and name='"+Session["name"].Tostring()+"'";code]
--------------------编程问答-------------------- VB不懂 --------------------编程问答--------------------
--------------------编程问答-------------------- VB?~~~跑错论坛了· --------------------编程问答-------------------- objCmd.CommandText = "select * from 设备总表 where 行名称="+session("depart")+" and 行名称="+session("depart")
string sql=@"select * from tb where id='"+Session["id"].Tostring()+"' and name='"+Session["name"].Tostring()+"'";
关于行数..select count(*) from 表名
返回表,取表[0][0]处数值即可
--------------------编程问答--------------------
怎么跑.NET来了 --------------------编程问答-------------------- --------------------编程问答-------------------- 数据行数?
就是数据的数量?
count
如果返回DataTable dt.Rows.Count
补充:.NET技术 , ASP.NET