How Do I Get The Result From This Stored Procedure Into A Dataset Or A Datatable Instead Of Var? Note: Sp Returns Single Row.

Question

0.00/5 (No votes)

See more:

C#

var userDetails = db.Database.SqlQuery<Login>("exec [spGetUserDetails] @EmailID = {0}", login.EmailID).Select(x => new Login { LoginPassword = x.LoginPassword.ToString(), LoginPasswordSalt = x.LoginPasswordSalt }).ToList()[0];

Posted 11-Jan-16 1:17am

Abrar Kazi

Updated 11-Jan-16 1:18am

v2

Add a Solution

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)

deepankarbhatnagar · Accepted Answer · 2016-01-11T01:23:00

Solution 1

Try this:

C#

DataTable dt = new DataTable();

var userDetails = db.Database.SqlQuery<Login>("exec [spGetUserDetails] @EmailID = {0}", login.EmailID).Select(x => new Login { LoginPassword = x.LoginPassword.ToString(), LoginPasswordSalt = x.LoginPasswordSalt }).ToList()[0];

dt = (DataTable)userDetails;

Posted 11-Jan-16 1:23am

deepankarbhatnagar

Comments

Abrar Kazi 12-Jan-16 1:00am

Thanks for the help but it didnt work. I tried this myself before posting my question, it says :
"Cannot convert type 'WPFL.ViewModel.Login' to 'System.Data.DataTable'"

deepankarbhatnagar 12-Jan-16 1:19am

OK ,try to solve from these helpful links,

http://www.codeproject.com/Tips/70802/Convert-Linq-Query-Result-To-DataTable

http://www.codeproject.com/Questions/465327/Convert-LinQ-var-into-a-DataTable

Abrar Kazi 12-Jan-16 1:21am

Ok sure. Thanks.

Abrar Kazi 13-Jan-16 3:01am

It worked.

DataTable userinfoDataTable = new DataTable();
DataRow dr;

List<login> tuserDetails = db.Database.SqlQuery<login>("exec [spGetUserDetails] @EmailID = {0}", login.EmailID)
.Select(x => new Login { LoginPassword = x.LoginPassword.ToString(), LoginPasswordSalt = x.LoginPasswordSalt, UserID = x.UserID, EmailID = x.EmailID }).ToList();

userinfoDataTable.Columns.Add("UserID", typeof(int));
userinfoDataTable.Columns.Add("EmailID", typeof(string));

foreach (var i in tuserDetails)
{
dr = userinfoDataTable.NewRow();
dr["UserID"] = i.UserID;
dr["EmailID"] = i.EmailID;
userinfoDataTable.Rows.Add(dr);
}

DataTable finaldt = new DataTable();
finaldt = userinfoDataTable.Copy();

To all the coders: if u find a better way than this then do post and help.