我也希望在sql查询中使用列名 [英] i want column name also in sql query

问题描述

cmd.CommandText = " Select classes +','+ Studentname " & _
       " from Stu s inner join Matrix m on m.Studentid = s.studentID " & _
 " inner join classes c on m.classesid=c.classesid where seatno=" & seatno & "" & _
             " and roomid=" & roomid & ""

k = cmd.ExecuteScalar

k = cmd.ExecuteScalar

strb.Append("<td>")


strb.Append("<input id=""Text1"" style=""width: 150px; text-align: right;"" class=""txt"" type=""text"" name='value_""1""_txb' value='" & k & "' />")
                               strb.Append("</td>")

它给输出像 -



b.tech，ravi m.tech，rahul



但是我希望输出像 -



班级班级名称

b.tech ravi m.tech rahul



i希望列名也在每个表中

it give the output like-

b.tech,ravi m.tech,rahul

but i want output like-

class name class name
b.tech ravi m.tech rahul

i want column name also in each table

推荐答案

cmd.CommandText = " Select classes +','+ Studentname as 'Your Column name' " & _
       " from Stu s inner join Matrix m on m.Studentid = s.studentID " & _
 " inner join classes c on m.classesid=c.classesid where seatno=" & seatno & "" & _
             " and roomid=" & roomid & ""

这篇关于我也希望在sql查询中使用列名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！