Get data into textbox using store procedure in LINQ

amit varma

10y1.2k

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Praveen Dhatrika10y ago
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 varma10y ago
if the query returns the multiple record and i want to display using next and previous facility than what should the code
Praveen Dhatrika10y ago
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 varma10y ago

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 Dhatrika10y ago
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 varma10y ago
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(day,datediff(day,0,current_timestamp),0)
select a.custid, b.name,b.mobile,b.phone, a.eligibleamt,
a.loanamt
,a.interest,
a.validity

,datediff(day,a.cdate,@today) as No_Of_Days
,round(a.loanamt*a.interest*datediff(day,a.cdate,@today)/36500,2) as SI ,
round(a.loanamt*a.interest*datediff(day,a.cdate,@today)/36500,2) + 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 Dhatrika10y ago
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..