Help with listview
-
hi i have listview in which i have folowing dataitem Name Address CountryID StateID my problem is i have GetCountryName() and GetStateName() methods in my DAL layer and i want to dislplay country name and state name insted of CountryId and StateId field i have googled it and looked everywhere can anyone help please to solve this problem its a bit urgent...thanx in adavance
appu
-
hi i have listview in which i have folowing dataitem Name Address CountryID StateID my problem is i have GetCountryName() and GetStateName() methods in my DAL layer and i want to dislplay country name and state name insted of CountryId and StateId field i have googled it and looked everywhere can anyone help please to solve this problem its a bit urgent...thanx in adavance
appu
appu, you didnt mention here, how you populate listview data. I guess u must have used Dataset as data source for Name,Address,CountryID and StateID, and for this you must be sending some SQL Query. So in where clause you can call the function. Another way is u dont call the funciton, LEFT OOUTER JOIN the Seed Data table for Country and State in SQL Query and populate the list view. Hope now you got some more Idea.
-
appu, you didnt mention here, how you populate listview data. I guess u must have used Dataset as data source for Name,Address,CountryID and StateID, and for this you must be sending some SQL Query. So in where clause you can call the function. Another way is u dont call the funciton, LEFT OOUTER JOIN the Seed Data table for Country and State in SQL Query and populate the list view. Hope now you got some more Idea.
thanx but i used Private Sub BindSearchByEmailGrid() Dim ds As EmployerInfoList = [EmployerInfoManager].SearchByEmail(txtemail.Text) searchgrid.DataSource = ds searchgrid.DataBind() UpdatePanel1.Update() End Sub and this dataset returns data with only countryid and stateid and as u said i cant modify storedprocedure to get names because they are in different database..i saw tht i can do that using gridview but not with the listview
appu