I am building multi-tier web based application using LINQ TO SQL and I have a problem when trying to assign the data to textboxes in a different tier .
bussniss logic function is :
PublicFunction ReviewApplication(ByVal
application_num AsString)
As IQueryable
Omar.Jabr
Member
2 Points
7 Posts
Return data from linq to sql function into textbox using multi-tier approach
Mar 29, 2012 06:24 AM|LINK
I am building multi-tier web based application using LINQ TO SQL and I have a problem when trying to assign the data to textboxes in a different tier .
bussniss logic function is :
Public Function ReviewApplication(ByVal application_num As String) As IQueryable
Try
Return MobjDataAccess.ApplicationReviewal(application_num)
Catch ex As Exception
Throw ex
End Try
End Function
data access function :
Public Function ApplicationReviewal(ByVal app_num As String) As IQueryable
Try
Dim query = From I In objDataContext.InduvisualInstitutes _
Join e In objDataContext.Emirates On I.InduvisualInstitutes_EmirateID Equals e.Emirate_ID _
Join N In objDataContext.Nationalities On I.InduvisualInstitutes_NationalityID Equals N.Nationality_ID _
Select I.InduvisualInstitutes_ApplicantName, N.Nationality_Name, I.InduvisualInstitutes_OwnerName, _
I.InduvisualInstitutes_OwnerPassport, I.InduvisualInstitutes_EducationLevel, e.Emirate_Name, _
I.InduvisualInstitutes_PostBox, I.InduvisualInstitutes_Phone, I.InduvisualInstitutes_Fax, I.InduvisualInstitutes_Email _
, I.InduvisualInstitutes_AuthorizedToSign, I.InduvisualInstitutes_WorkCardNum, I.InduvisualInstitutes_UniversityDegreeCopy, _
I.InduvisualInstitutes_PassportCopy, I.InduvisualInstitutes_ExperienceCertificate, _
I.InduvisualInstitutes_GoodConductCertificate, I.InduvisualInstitutes_RentContractCopy, _
I.InduvisualInstitutes_signatureForm, I.InduvisualInstitutes_ApplicationNumber
Where InduvisualInstitutes_ApplicationNumber = app_num
Return query
Catch ex As Exception
Throw ex
End Try
End Function
User Interface :
I have a textbox control that I want to be assigned with a specific value returned from the query , how to do that , thanks
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Return data from linq to sql function into textbox using multi-tier approach
Mar 30, 2012 11:42 PM|LINK
Hello：）
If you want to fetch the value from the IQuerable as its result，you should use FirstOrDefault() because one TextBox can only have a single value——
TextBox1.Text = ReviewApplication("1").FirstOrDefault()Omar.Jabr
Member
2 Points
7 Posts
Re: Return data from linq to sql function into textbox using multi-tier approach
Apr 01, 2012 10:23 AM|LINK
Thanks , I know that using "FirstOrDefault()" will solve the issue but I want to use it the UI not in the DAL , in DAL I can do something like :
dim result as string
result =query.FirstOrDefault.InduvisualInstitutes_ApplicantName
but I want to able to do that in the UI , what I should do
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Return data from linq to sql function into textbox using multi-tier approach
Apr 01, 2012 12:57 PM|LINK
You can still use that statement in UI。
Omar.Jabr
Member
2 Points
7 Posts
Re: Return data from linq to sql function into textbox using multi-tier approach
Apr 02, 2012 09:33 AM|LINK
Thanks