Forms Data Controls :: Showing Data From Multiple Tables In A Listview?

Jan 22, 2010

I have a listview that shows the user the details of the members who have sent friendship request. The table from which the data come has two fields namely, sender_id[id of the one who sends friendship request] and receiver_id[id of the one to whom the request is sent].

There will be two columns in the listview. The first would show the pic and the name of the user. The problem is that how am I going to show the pic and the name if the table from where the data come does not contain these info. I know that the sender_id can be used to fetch the pic and name of the sender, but how should it be done?

Earlier I would do something like <%#Eval("fieldName")%>. But in the above described scenario the field is not present in the current table but the other one.

View 5 Replies

Similar Messages:

Forms Data Controls :: Displaying Data From Three Tables In A Listview?

Mar 24, 2011

I want to display data from one record in a ListView control. There are two other tables that could contain associated records. For each table, if there is an associated record, I want to display the data from a particular field. I'm only concerned with the item amd alternate templates

View 3 Replies

Forms Data Controls :: Bind Data To Listview Using Tables?

Sep 23, 2010

Is there any way to bind data to listview using tables?

Lest say I'd like to do more less something like this:


View 4 Replies

Data Controls :: Display Data From Multiple Tables Using Multiple Dynamic GridViews

May 7, 2015

I have storedprocedure which returns four or more dataset!

example here

How load  and display all data in Default.aspx....

dataset 1


dataset 2


dataset 3


dataset 4


View 1 Replies

Forms Data Controls :: Thumbnail Images Showing As ListView?

Jan 28, 2011

I want to make a website which showing thumbnail images be taken from local folder,say,'thumbnails' inside the root folder like listview items.Below each thumbnails,the name of the file would be displayed with check boxes for selecting any thumbnail images.Clicking on any thumbnails will redirect to another page where the thumbnails and the original image(with the same name in some other local folder say 'Original') would be displayed.

View 3 Replies

Forms Data Controls :: Showing Images In Datalist Or Listview From Url?

Nov 29, 2010

i need to show images from url wich i have in my behind code. For example i have listview control :

<asp:ListView ID="ListView1" runat="server">

View 14 Replies

Forms Data Controls :: Data From Multiple Database Tables Displayed On The Same Page?

Aug 20, 2010

i would like to find out how to go about displaying data from multiple database tables on the same page. What i mean is it would look like the feeds on the facebook home page where you can see the information like newply uploaded photo or a new post.

I have two tables, and i want to display any newly created row on my home page from either table in the same control. Currently, i have two gridviews, but i want the data from both tables be displayed together.

View 4 Replies

Forms Data Controls :: ListView Templates And Showing Association Fields Rather Than An Id

Feb 17, 2011

I have a Listview that is connected to an EntityDataSource. What I'm having trouble doing is showing fields of an association in the Item Template rather than just the id.

For example, what it currently shows:

Name: John Doe
Race: 3

What I wish it would show

Name: John Doe
Race: Caucasian

Some example code:


Obviously, I'm getting the number because Race_ID is an integer. What I'm less sure about is how to bind it or Eval it in some manner that will let me match that id to a name in the other table (which is associated). I've tried <%# Eval("Race.Name") %>' and a few other things to try to get a name rather than an ID but I always get either the id or nothing at all.

View 3 Replies

Forms Data Controls :: Listview Showing Photos From Database As Thumbnails ?

Mar 15, 2011

im trying to build a gallery using C#.

Ii've made a Listview showing photos from database as thumbnails in a "kind of a film strip", including a pager.What i need is that when i click on a thumbnail inside the ListView, to show the large photo in a image control outside the listview. this should work using the selectedIndexChanged event,

View 4 Replies

Forms Data Controls :: Listview Dataset Tables[0] DefaultView Sort Not Working?

Jan 15, 2010

I have a Listview control that DataBind programatically... ie I am NOT using SqlDataSource or such... I am attempting to sort a column... clicking on a link button that fires the "Sorting" event. So, after cliking on the column heading... I end up in this routine, where I hardcoded the .Sort = values (just for testing). The code is executed... but the RESULT show via Listview remains the SAME. No change!

How to fix this? I've seen some other posts examples that uses this event (ListView1_Sorting) and then sort via LINQ. I am not ready to try that...

Just want to know why dsPaymentList.Tables[0].DefaultView.Sort does not work?

I followed the example at: [URL]

protected void ListView1_Sorting(object sender, ListViewSortEventArgs e)
string sortExpression = e.SortExpression + " " + e.SortDirection;
DataSet dsPaymentList = new DataSet();


View 3 Replies

Forms Data Controls :: Showing Edit Template On Page Changing Listview?

Jan 31, 2011

I'm using listview with datapager.

when I'm trying to change the page if an item is in edit mode, the item with same row number in other page is opening in edit mode.

View 4 Replies

Forms Data Controls :: Intelli Sense Not Showing BorderStyle Property For ListView?

Nov 24, 2010

I have added a list view to my page. I can not set the BorderStyle property for the listview. The BorderStyle property does not appear in the intelli sense when in the aspx of aspx.cs file.

View 4 Replies

Data Controls :: Search In Multiple Tables Using One TextBox And Display Results In Multiple GridView

Jul 22, 2013

I created 3 product  table . A,B and c.

I show product of table in different gridview.  

Now I am using one search box. but how to search product name with image in one query all of three table.... 

Simple how to search product from multiple table and show result...

View 1 Replies

Forms Data Controls :: Update Multiple Tables From DetailsView?

Nov 29, 2010

I have a asp:DetailsView control with the first column are the field headers and the second column is the record details for a given user.

The DetailsView is bound from 4 tables, I need to be able to edit/amend any field. Is there another way I can achieve this from the DetailsView? Would I need to create templates for each table entry then Update SET on each template, would that do it?

View 8 Replies

Forms Data Controls :: How To Update Multiple Tables With A SQLDataSource

Mar 3, 2011

I have 2 tables

One:Table Name Rider With columns RiderID,LName,City

Two:Table Name Car With columns CarID,RiderID,Color

What I would like to be able to do is to allow the users to do an UPDATE on both tables.

Like if you crreated a SQLDataSource using just one table as it's source. You can use that SQLDataSource for a gridview.

Then in the gridview you can display all the data from the table but you can also EDIT all the data in the table through the gridview.

But if I create a SQLDataSource using 2 table joining them together with an INNER JOIN with a Primary Key in one table and a Foriegn Key in the other table. I can still use this SQLDataSource with a GridView to display the data but I can't EDIT the data through the gridview for the 2 tables.

Is there anyway to do this using a SQLDataSource and GridView?

OR is there another way to accomplish this?

View 3 Replies

Forms Data Controls :: Showing Multiple Images In Gridview?

Nov 19, 2010

A user has multiple images which is stored in database(datatype varbinary ).I want to show all the images of that particular user in gridview.Can you people guide me how to achieve this?( with c#)

View 4 Replies

Forms Data Controls :: GridView Showing Multiple Row Entries Instead Of Just One?

Aug 6, 2010

I have some data displayed in GridView and there are multiple (repeat) entires.

There are about 20 rows of the same data, but I only want to display 1 row.

I know can amend PageSize="1" but then it shows multiple pages which I also don't want.

The multiple rows - are all of the exact same data - but it should only appear once!

View 2 Replies

Data Controls :: Need A Stored Procedure To Fetch Combined Data From Multiple Tables

Dec 27, 2012

i have a details table which include detailid, custname, address, classification , pincode, telephone, remarks and classification table contain classification id & classification.i want to insert detailid & corresponding classificationid to a new table detail_classification. How to write stored procedure for that?

View 1 Replies

Data Controls :: Load On Demand Data In GridView With Records From Multiple Tables

Jul 17, 2015

In article Load on demand data in GridView you clearly described. but it's not enough when we comes to conditions. 

Is it possible to load data on query method?I want to add some field from other table so how to use inner join in this...

Like I'm having a table with userid and want to get user full name from users table where userId = users.userId

View 1 Replies

Forms Data Controls :: Dataset With Multiple Tables Bind To Grid

Jul 7, 2010

i m trying to bind my both grid with two tables which are in dataset i m trying but when i m binding my gridview it's always binding the second table see code


i already tried to bind both the gv1 and gv2 they both are displaying same table i.e department

View 3 Replies

Forms Data Controls :: Build Gridview Dynamically - Multiple Tables?

Jun 29, 2010

I have a .NET 1 web app that is using a Oracle database, the web app has a page of table names that allows the users to select, there are 101 tables listed on the page. When the user clicks on a table name, it takes them to a page that shows user friendly column headers, the table data, etc. Is there a way to use one GridView to do this and show the user friendly column headers instead of creating 101 pages or 101 user controls and show that control based on the table passed into the page?

for example: the user clicks table 22, I want my gridview to look like this

Buyer's Name State City Zip Code Phone Number

if they click table 55 I want them to see this

Product Wholesale Price MSRP Sale Price On Sale (check box)

instead of showing the users

BuyersFullName BuyersState BuyersCity BuyersZipCode PhoneNumber, etc

and so I, I would like to use 1 gridview on one page if possible and build the grid on the "fly", We have the user friendly column headers in a table.

So my questions are:

is this possible, if so, what is the best approach in doing this

from a scalabilty level and maintenance level, would the 1 gridview be worth for all 101 (and growing tables), or would building a seperate user control for each table be better?

View 5 Replies

Forms Data Controls :: Gridview Showing Values From Two Tables Accommodation And Pic (left Join On Accommodation)

Nov 19, 2010

I have a gridview showing values from two tables accommodation and pic (left join on accommodation). If there is no pic uploaded I want to display the row without the pic. So in the gridview I first check to see if the picid is null, if it is i don't render any 'a href' code , if it's isn't i do.

The problem that i'm having is that instead of the image showing up in the gridview itemtemplate i get
','_blank','toolbar=no,menubar=no'))" >

Here is my .aspx code

SelectCommand="SELECT pic.picid, aspnet_Users.Username, accommodation.location, accommodation.type,accommodation.description, convert(varchar,accommodation.createdate,101) as createdate

View 2 Replies

Data Controls :: Display Data From Multiple Tables Using LINQ To SQL In MVC

May 7, 2015

I have to display records from two tables where foreign key table contains many values for a primary key column how to get the data using linq query???

View 1 Replies

Forms Data Controls :: How To Use A Custom Wizard To Make Entries In Multiple Tables

Apr 8, 2010

I'm using Visual Studio 2008 with SQL Server Express databases in my .net 3.5 website

I have three tables I'd like to make entries to when the user completes a wizrd i've setup on a web form.

The First Step - The user enters basic information about their "Case". The table looks like so:

db_Cases - CaseId PK auto int, CustomerId, etc fields

The Second Step - The user enters information about the "Debtors" that are related to this "Case". Think of this as being products....The only difference is these records wont be used over and over again like a product would. The user may need to enter data about several "Debtors", just like if you needed to show several different products on an invoice. For example the user may need to enter information about a husband and wife. This means two entries in the "Debtors" table. The table looks like so:

db_Debtors - DebtorId PK auto int, etc fields

The Third Step - Here's my problem. This step needs to make entries into a third table called "CaseDetails". Again, this is just like if you were creating an invoice with several different products on it, where you would want to get a subtotal of each product's cost. The table looks like so:

db_CaseDetails - CaseDeatailId PK auto int, CaseId int, DebtorId, int

* When this table is later viewed, It will reflect all "Debtors" attached to the specific "Case" being viewed.

The first two steps aren't a problem, I pretty well have that handled in the wizard. BUT How do I create the entries in the "CaseDetails" table when the user finishes?

My idea right now is..... Considering the "Debtors" will be re-used but only on rare occations, I'm thinking I should just add the "CaseId" that was created in step one, to the "Debtors" table at the same time the "Debtor" is created. So the table would look like so.

db_Debtors - DebtorId PK auto int, CaseId int, Name, Address, etc

View 1 Replies

Forms Data Controls :: Joining Multiple Tables To Show Results In A Gridview?

Mar 4, 2011

I have been trying to make this work for a while, but I have not been yet able to figure this put. I am using VS 2008 and mysql database. I wrote a query and checked to see if it works in database. It does.

I have a gridview, whose select command is that query. But for some reason, I just get all the rows from one table only. I rechecked my datasource and it is ok. I read on some discussions that it is NOT possible to have data from two tables in a gridview. Is that true? If that is not true, how can I have data from multiple tables in a gridview? Or any other web control for that matter.

View 6 Replies

Copyrights 2005-15, All rights reserved