Hi all,
I have a MS SQLServer database which has two tables, 'images' and
'photographers' . The photographer table contains a field for
PhotographerID and a one for PhotographerNam e. The image table also
contains a field for photographerID which is used to join the two
tables.
I'm having problems with populating a dropDownList using the complete
set of photographerNam es and IDs from the 'photographer' table but
binding the selected value to the Image table.
I've set up a DataSet and added both tables to it and now have the list
populated but can't bind the list to the photographerID field in the
'image' table.
Anyone done anything like this before? if so any help would be much
appreciated,
thanks in advance,
Paul 6 14314
So if i understand, you have a Dataset with 2 DataTables.
The DataMember property of the Dropdownlist object will allow you to specify
which dataTable to use from the datasource which is in this case the DataSet
So for example
DropDownList dll = new DropDownList();
ddl.DataSource = MyDataSetWith2T ables;
ddl.DataMember = "Photograph ers"
....
ddl.DataBind()
HTH,
Tony
"p.mc" <pa************ *@googlemail.co m> wrote in message
news:11******** **************@ j33g2000cwa.goo glegroups.com.. . Hi all,
I have a MS SQLServer database which has two tables, 'images' and 'photographers' . The photographer table contains a field for PhotographerID and a one for PhotographerNam e. The image table also contains a field for photographerID which is used to join the two tables.
I'm having problems with populating a dropDownList using the complete set of photographerNam es and IDs from the 'photographer' table but binding the selected value to the Image table.
I've set up a DataSet and added both tables to it and now have the list populated but can't bind the list to the photographerID field in the 'image' table.
Anyone done anything like this before? if so any help would be much appreciated,
thanks in advance,
Paul
Hi Tony,
thanks for your help, however i'm still unable to get it working as i
would like. Using the method you suggested i've got the ddl displaying
the complete list of photographers from the photographers table. After
i select this i would like to store the result (photog ID) in the
photographerID field in the 'imageTable'. So i guess i need to bind the
DataTextField and DataValueField to the photographer Table but bind the
result to the image table.
I'm sure i must be missing something simple here, but can't think what
it is. Any further help would be appreciated.
thanks, paul
Anthony Merante wrote: So if i understand, you have a Dataset with 2 DataTables.
The DataMember property of the Dropdownlist object will allow you to specify which dataTable to use from the datasource which is in this case the DataSet
So for example
DropDownList dll = new DropDownList(); ddl.DataSource = MyDataSetWith2T ables; ddl.DataMember = "Photograph ers" ... ddl.DataBind()
HTH, Tony
"p.mc" <pa************ *@googlemail.co m> wrote in message news:11******** **************@ j33g2000cwa.goo glegroups.com.. . Hi all,
I have a MS SQLServer database which has two tables, 'images' and 'photographers' . The photographer table contains a field for PhotographerID and a one for PhotographerNam e. The image table also contains a field for photographerID which is used to join the two tables.
I'm having problems with populating a dropDownList using the complete set of photographerNam es and IDs from the 'photographer' table but binding the selected value to the Image table.
I've set up a DataSet and added both tables to it and now have the list populated but can't bind the list to the photographerID field in the 'image' table.
Anyone done anything like this before? if so any help would be much appreciated,
thanks in advance,
Paul
Assuming that the image field that you want to place in selected value
is of type System.String, you need to create a SQL statement or
(preferably) a stored procedure that will do the join. Then bind the
dropdown list to that...
using (SqlConnection conPhotographer AndImage = new
SqlConnection([PUT CONNECTION STRING HERE])
{
SqlCommand cmdGet = new
SqlCommand("Get PhotographersAn dImages", conPhotographer AndImage);
cmdGet.CommandT ype = CommandType.Sto redProcedure;
//You could also omit the above line and set command with
text instead...
//SELECT p.PhotographerN ame,i.ImageName FROM Photographer
p INNER JOIN Image i ON p.PhotographerI d=i.Photographe rId;
conPhotographer AndImage.Open() ;
SqlDataReader drdPhotographer AndImage =
cmdGet.ExecuteR eader();
this.ddlMyDropD ownList.DataSou rce =
drdPhotographer AndImage;
this.ddlMyDropD ownList.DataVal ueField = "ImageName" ;
this.ddlMyDropD ownList.DataTex tField =
"PhotographerNa me";
this.ddlMyDropD ownList.DataBin d();
drdPhotographer AndImage.Close( );
conPhotographer AndImage.Close( );
ListItem lstAll = new ListItem("[all]", "999999");
this.ddlEventTy pe.Items.Insert (this.ddlEventT ype.Items.Count , lstAll);
this.ddlEventTy pe.SelectedInde x =
this.ddlEventTy pe.Items.Count - 1;
}
HTH,
JP
JP
thanks for your help, just to clarify - i've included a table in the
dataSet which is a SQL view that contains the INNER JOIN you suggest.
Is it necessary to explicitly create this join for the ddl?
The webForm i'm working on will contain 15 to 20 of these foreign-key
joins bound to ddls.
I'm sure that what i'm trying to do must be a very common technique (is
it not one of the basic principles of relational databases?), surely
using foreign keys to link to other tables can be handled more
efficiently than this?
thanks again
The point is to set the datasource up as *one* entity (not two tables).
This where the join comes in. You configure the query with a join to
return a result set that has all of your data. You then simply set
DataTextField to the name of the field that you want to show in the
dropdown, set DataValue field to the name of the field that you want to
be in the corresponding values, and then bind the DDL to the one
entity. At least that's the way I have always done it.
JP
Thanks for your help, much appreciated.
I'll have a go and see where i get,
thanks again This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Hugh McLaughlin |
last post by:
Hello Everyone and thanks for your help in advance. I am
developing a class library that reads a SQL Server table
of names and ID's. I want to populate a dropdownlist with
the data, however, names in the table may appear more
than once. I only want to display the name in the
dropdownlist once. My initial thought wat to create an
arraylist, then loop through each record, adding a new
name upon each new name encountered. But I want the name...
|
by: cloverme |
last post by:
Hi,
I need help populating a listbox from a database on a webform.
I created a an access database with a table, fields and data. Then I
created a WebForm in vb.net and added a DropDownList control to the
page.
Then I created a data connection to my table... I right clicked and
told it to generate a dataset (which it created dataset1).
|
by: to_rgoyal |
last post by:
Hi All,
I am creating one web base application using ASP.net and C#. I am
populating dropdown lists of my web
pages using database. I am using this code:
con = new SqlConnection(connectionString);
SqlCommand getresult = new SqlCommand("select distinct(owner) from
issue_log",con);
con.Open();
|
by: Wim |
last post by:
Hi Everyone,
I'm trying to speed up a Asp.net 1.1 applications' performance. The
application needs to run in an environment with little bandwith and
therefore pagesizes and roundtrip times shoud be brought back to a
minimum.
The application suffered from relatively large screens. A typical aspx
page was 500 Kbyte so page load times were in the order of 40 - 50
seconds. After unsufficient loading improvement using .net caching
|
by: RFS666 |
last post by:
Hello together,
I tried to find out about populating an asp.net server control (a
dropdownlist) from the clientside jscript, but I didn't find a solution up
to now.
I cannot use a html dropdownlist, because a database query in codebehind has
to be done, when a new listItem is selected. So, I need to use a
servercontrol dropdownlist.
Now to my problem:
| |
by: Mike P |
last post by:
I am populating a drop down column in a datagrid on page load. Here is
my code :
<asp:TemplateColumn>
<ItemTemplate>
<asp:DropDownList ID="ddlUserName" Font-Name="Verdana"
Font-Size="8pt" Runat=server
DataValueField="UserName"
DataTextField="UserName"
DataSource='<%# GetUserList() %>'>
|
by: Mike P |
last post by:
I know how to populate a dropdown list in a gridview in edit mode when
the dropdown is populated by a datasource (see below eg 1), but how do
you populate the dropdown when the dropdown is populated in the ASP.NET
(ie you are adding asp:ListItems in the ASP see eg 2) rather than by a
datasource?
Eg 1:
<asp:TemplateField HeaderText="Forecast Type"
SortExpression="ForecastDescription">
|
by: Phil Sandler |
last post by:
I am trying to do something which seems (to me) to be very simple, and
yet I can't seem to figure it out.
I have a gridview and a formview. When a user clicks "select" in the
gridview, the formview opens. The user can then click "insert" or
"update" to either create a new row or edit the existing row.
This all works fine as long as I only use textboxes and checkboxes in
my insertItemTemplate and editItemTemplate. What I would like...
|
by: koonda |
last post by:
Hi all,
I have a Project due after one week. It is a web service project. I have a Web Form which communicates to the web service and this web service communicates to the database. I have all my SQL statements in the Data Acess Layer to create more secure web service application. The Web service class is also in the Data Access Layer. I need to populates the 4 Dropdown list boxes on the web form from one table. I have Customer table which...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |