Get data into textbox using store procedure in LINQ

Question

Hello guys i want Get data into textbox using store procedure var q = objcontext.sploadloandata(comboBox1.Text); txtcustname.Text = what to do here; txtaddress.Text = what to do here; txtmobile.Text = what to do here; txtemailid.Text = what to do here; take this screen shot : https://goo.gl/4U0u2Y

Praveen Dhatrika · Answer

Run a loop like this foreach(var item in q) { txtcustname.Text = item.custname; txtaddress.Text = item.address; txtmobile.Text = item.mobile; txtemailid.Text = item.emailid; }

amit varma · Answer

if the query returns the multiple record and i want to display using next and previous facility than what should the code

Praveen Dhatrika · Answer

yes if you need to find one first value then we use to select.firstordefault() from the collection items the other way is foreach(var item in q) { txtcustname.Text = item.custname; txtaddress.Text = item.address; txtmobile.Text = item.mobile; txtemailid.Text = item.emailid; } But you need to make sure if you want all values... check this as answer if it helped you.. Thanks :)

amit varma · Answer

I find the correct solution... please check this.... First of all replace the query that i had write Old Query : var q = objcontext . sploadloandata ( comboBox1 . Text ); New Query : var q = ( from data1 in objcontext . sploadloandata ( comboBox1 . Text ) select data1 ). FirstOrDefault (); Now i get all the data into the textbox txtcustname . Text = q . name ; txtnetweight . Text = q . weight ; txtmobile . Text = q . mobile ; txtloanamt . Text = q . loanamt ;

Praveen Dhatrika · Answer

You need to see what you are getting stored in variable 'q' that you had.. Use QuickWatch on that variable to see what it says that would be the easiest way I do..

amit varma · Answer

first of all thanks for reply Praveen Dhatrika You getting me in the correct way so what should be the code???? MY SP : alter proc sploadloandata @customerid nvarchar(50) as begin declare @today datetime SET @today = dateadd(daydatediff(day0current_timestamp)0) select a.custid b.nameb.mobileb.phone a.eligibleamt a.loanamt a.interest a.validity datediff(daya.cdate@today) as No_Of_Days round(a.loanamt*a.interest*datediff(daya.cdate@today)/365002) as SI  round(a.loanamt*a.interest*datediff(daya.cdate@today)/365002) + a.loanamt as CHECKsi from tblLoanEntrydetails a tbl_customer b where a.custid=b.cid and b.cid=@customerid order by a.fororderdate desc end

Praveen Dhatrika · Answer

To my understanding I see that you are trying to store the values returning from SP in variable object 'q' So you should make sure that if the variable 'q' hods the values for custname address ... then you can do like this txtcustname.Text = q.custname; txtaddress.Text = q.address; txtmobile.Text = q.mobile; txtemailid.Text = q.emailid; and so..