数据库查询问题 [英] database query problem

问题描述

您好我有一个菜鸟问题，我搜索了所有谷歌的答案，但没有找到任何有用的东西。我有这个命令

Hi I am have one noob question, I searched all the google for the answer but didnt find anything useful. I have this command

var name = db.Query("SELECT User FROM UserProfile WHERE UserId= "+row.FromUserId) );

我想变量名包含id的人名，但查询返回某种集合，我无法弄清楚接下来该做什么。谢谢

I want to variable name contain a name of person with id, but query returns some kind of collection and I cant figure out what to do next. Thanks

推荐答案

如果我使用var name = db.QuerySingle（SELECT * FROM UserProfile WHERE UserId = @ 0，row.FromUserID），我已经解决了这个问题。然后它是name.User :)全部谢谢

I have solved it if I use var name = db.QuerySingle("SELECT * FROM UserProfile WHERE UserId= @0",row.FromUserID); then it is name.User :) Thanks all

这篇关于数据库查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！