database query problem

Question

1.00/5 (1 vote)

See more:

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) );

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

Posted 2-Aug-13 5:41am

wirec aaht

Add a Solution

Comments

[no name] 2-Aug-13 11:53am

Okay.... what exactly is that you want to do next?

wirec aaht 2-Aug-13 12:05pm

I want to use name of user in chat, but I only have ID. Like in WebSecurity is function GetUserId() I want it reverse. I have Id but I want name of user. :)

woopsydoozy 2-Aug-13 12:28pm

what kind of DB are you hitting (SQLServer, Oracle, other?), and what kind of object are you using to query it (what type is your db variable, and what type does Query return)?

ridoy 2-Aug-13 12:48pm

not clear at all.

wirec aaht 2-Aug-13 13:09pm

I am using SQLServer I will paste here all page.

@{Layout="Layout.cshtml";
var db = Database.Open("test");
var query= "SELECT * FROM Messages WHERE FromUserID='"+WebSecurity.CurrentUserId+"' OR ToUserID='"+WebSecurity.CurrentUserId+"';";

}

<!DOCTYPE html>

<html lang="en">
<head>
<meta charset="utf-8" />
<title>Správy</title>
<link rel="stylesheet" href="http://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css" />
<script src="~/Scripts/jquery-1.9.1.js"></script>
<script src="~/Scripts/jquery-ui.js"></script>
<style>
#accordion-resizer {
padding: 10px;
width: 750px;
height: 350px;
}
</style>
<script>
$(function() {
$( "#accordion" ).accordion({
heightStyle: "fill"

});
});
$(function() {
$( "#accordion" ).accordion({
collapsible: true
});
});
/* $(function() {
$( "#accordion-resizer" ).resizable({
minHeight: 140,
minWidth: 200,
resize: function() {
$( "#accordion" ).accordion( "refresh" );
}
});
});*/
</script>
</head>
<body>
<div id="accordion-resizer" class="ui-widget-content">
<div id="accordion">
@foreach(var row in db.Query(query))
{
var name = db.Query("SELECT User FROM UserProfile WHERE UserId= "+row.FromUserId) );

@name

<div>
<p>
@row.Message v čase @row.CreateDate
</p>
</div>
}

</div>
</div>
</body>
</html>

ZurdoDev 2-Aug-13 14:15pm

Just add a new method to return the value from the database that you want.

wirec aaht 2-Aug-13 18:27pm

That i would do but var name = db.Query("SELECT User FROM UserProfile WHERE UserId= "+row.FromUserId) ); this is some strange format and i cant make var name to contain string :)

ZurdoDev 2-Aug-13 19:04pm

I don't understand what you are saying.

wirec aaht 3-Aug-13 5:12am

var name should contain name of user for example aaa but when I print it out using @name it contain System.Collections.ObjectModel.ReadOnlyCollection`1[System.Object]

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

wirec aaht · Accepted Answer · 2013-08-03T04:25:00

Solution 1

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

Posted 3-Aug-13 4:25am

wirec aaht