After configuring a relation data schema (MyDataSet.xsd) in vs.net, what
code do you use to display that data within two dropdownlist controls (
parent/child) in an web application?
16  1854 
Hi Leon,
configuring a typed dataset only gets you halfway there (assuming that's
what you are doing with the XSD). What you still need to do by hand is to
write some ADO.NET code to establish the connection with the database and to
actually load stuff in your dataset. For example, you could define a
SqlDataAdapter, specify a SELECT... query and use .Fill with your typed
DataSet as parameter (if you use SQL Server). It may be a little overkill to
define a typed dataset and use a DataAdapter only to fill two dropdownlists.
Take a look at the Data Access Application
Blocks( http://msdn.microsoft.com/netframewo...s/default.aspx
?pull=/library/en-us/dnbda/html/daab-rm.asp), it could be as easy as this
(C#):
DataSet MyDs = SqlHelper.Execu teDataSet( MyConnectionStr ing,
CommandType.Tex t, "select name, value from mytable" );
MyDropDownList. DataSource = MyDs.Tables[0];
MyDropDownList. DataTextField = "name";
MyDropDownList. DataValueField = "value";
MyDropDownList. DataBind();
Note that using a dataset always has some overhead, so you may want to use a
SqlDataReader for performance.
Best regards,
Marc Hoeppner
NeoGeo
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:OX******** ******@tk2msftn gp13.phx.gbl... After configuring a relation data schema (MyDataSet.xsd) in vs.net, what
code do you use to display that data within two dropdownlist controls (
parent/child) in an web application?
Hi Leon,
configuring a typed dataset only gets you halfway there (assuming that's
what you are doing with the XSD). What you still need to do by hand is to
write some ADO.NET code to establish the connection with the database and to
actually load stuff in your dataset. For example, you could define a
SqlDataAdapter, specify a SELECT... query and use .Fill with your typed
DataSet as parameter (if you use SQL Server). It may be a little overkill to
define a typed dataset and use a DataAdapter only to fill two dropdownlists.
Take a look at the Data Access Application
Blocks( http://msdn.microsoft.com/netframewo...s/default.aspx
?pull=/library/en-us/dnbda/html/daab-rm.asp), it could be as easy as this
(C#):
DataSet MyDs = SqlHelper.Execu teDataSet( MyConnectionStr ing,
CommandType.Tex t, "select name, value from mytable" );
MyDropDownList. DataSource = MyDs.Tables[0];
MyDropDownList. DataTextField = "name";
MyDropDownList. DataValueField = "value";
MyDropDownList. DataBind();
Note that using a dataset always has some overhead, so you may want to use a
SqlDataReader for performance.
Best regards,
Marc Hoeppner
NeoGeo
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:OX******** ******@tk2msftn gp13.phx.gbl... After configuring a relation data schema (MyDataSet.xsd) in vs.net, what
code do you use to display that data within two dropdownlist controls (
parent/child) in an web application?
Ok I have call the adatper.fill and databind command, but is'nt some type of
code such as Me.DataSet1.Wri teXmlSchema(Me. Request.Applica tionPath
"DataSet1.x sd" I have to type to get the database schema from the .xsd file
(I have two relate tables in my .xsd file "States" and "School". when you
select a state from the first dropdownlist the second dropdownlist suppose
to populate itself with the correct schools from that state. However, the
first list populate with the states, (I have autopostback set to true, and
the onchange event firing) but after the page postback the state
dropdownlist displays System.Data.Rel atedView over and over again. Thanks
for the help!
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message
news:Ox******** ******@TK2MSFTN GP11.phx.gbl... Hi Leon,
configuring a typed dataset only gets you halfway there (assuming that's
what you are doing with the XSD). What you still need to do by hand is to
write some ADO.NET code to establish the connection with the database and
to actually load stuff in your dataset. For example, you could define a
SqlDataAdapter, specify a SELECT... query and use .Fill with your typed
DataSet as parameter (if you use SQL Server). It may be a little overkill
to define a typed dataset and use a DataAdapter only to fill two
dropdownlists. Take a look at the Data Access Application
Blocks(http://msdn.microsoft.com/netframewo...s/default.aspx ?pull=/library/en-us/dnbda/html/daab-rm.asp), it could be as easy as this
(C#):
DataSet MyDs = SqlHelper.Execu teDataSet( MyConnectionStr ing,
CommandType.Tex t, "select name, value from mytable" );
MyDropDownList. DataSource = MyDs.Tables[0];
MyDropDownList. DataTextField = "name";
MyDropDownList. DataValueField = "value";
MyDropDownList. DataBind();
Note that using a dataset always has some overhead, so you may want to use
a SqlDataReader for performance.
Best regards,
Marc Hoeppner
NeoGeo
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:OX******** ******@tk2msftn gp13.phx.gbl... After configuring a relation data schema (MyDataSet.xsd) in vs.net, what
code do you use to display that data within two dropdownlist controls (
parent/child) in an web application?
Ok I have call the adatper.fill and databind command, but is'nt some type of
code such as Me.DataSet1.Wri teXmlSchema(Me. Request.Applica tionPath
"DataSet1.x sd" I have to type to get the database schema from the .xsd file
(I have two relate tables in my .xsd file "States" and "School". when you
select a state from the first dropdownlist the second dropdownlist suppose
to populate itself with the correct schools from that state. However, the
first list populate with the states, (I have autopostback set to true, and
the onchange event firing) but after the page postback the state
dropdownlist displays System.Data.Rel atedView over and over again. Thanks
for the help!
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message
news:Ox******** ******@TK2MSFTN GP11.phx.gbl... Hi Leon,
configuring a typed dataset only gets you halfway there (assuming that's
what you are doing with the XSD). What you still need to do by hand is to
write some ADO.NET code to establish the connection with the database and
to actually load stuff in your dataset. For example, you could define a
SqlDataAdapter, specify a SELECT... query and use .Fill with your typed
DataSet as parameter (if you use SQL Server). It may be a little overkill
to define a typed dataset and use a DataAdapter only to fill two
dropdownlists. Take a look at the Data Access Application
Blocks(http://msdn.microsoft.com/netframewo...s/default.aspx ?pull=/library/en-us/dnbda/html/daab-rm.asp), it could be as easy as this
(C#):
DataSet MyDs = SqlHelper.Execu teDataSet( MyConnectionStr ing,
CommandType.Tex t, "select name, value from mytable" );
MyDropDownList. DataSource = MyDs.Tables[0];
MyDropDownList. DataTextField = "name";
MyDropDownList. DataValueField = "value";
MyDropDownList. DataBind();
Note that using a dataset always has some overhead, so you may want to use
a SqlDataReader for performance.
Best regards,
Marc Hoeppner
NeoGeo
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:OX******** ******@tk2msftn gp13.phx.gbl... After configuring a relation data schema (MyDataSet.xsd) in vs.net, what
code do you use to display that data within two dropdownlist controls (
parent/child) in an web application?
Well, basically you can have VS.NET do the grunt work for you. If you
right-click on your project file, select add, then add class, select dataset
and use any name you like (dataset1.xsd) is fine. Now use the server
explorer to drag a few tables in the XSD and use the toolbox to add
references and/or new fields as needed. Now, when you do this and compile
your project, VS.NET will use a tool (XGEN.EXE) to generate a C# file for
you that implements a strongly typed dataset. You can use it like any other
dataset but it is also a strongly typed class with all the parameters that
your tables have. You can also manually change the XSD file or use the GUI
to build your XSD from scratch.
But if all you want to do is to fill two DropDownLists I would recommend to
use the Data Access Application Blocks or simple ADO.NET to get a DataTable
for each table separately and attach these to the dropdownlists.
One other thing: you can help the databind process to find the right columns
to display by the user of DataTextField and DataValueField. For example, if
you have a DataTable with 4 columns (Company, Street, Country, CompanyID)
and you want the ddl to display the Company as text and have the CompanyID
as the value you'd do something like this:
MyDropDownList. DataSource = MyDataTable;
MyDropDownList. DataTextField = "Company";
MyDropDownList. DataValueField = "CompanyID" ;
MyDropDownList. DataBind();
Hope this helps!!
Best regards,
Marc Höppner
NeoGeo
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. .. Ok I have call the adatper.fill and databind command, but is'nt some type
of code such as Me.DataSet1.Wri teXmlSchema(Me. Request.Applica tionPath
"DataSet1.x sd" I have to type to get the database schema from the .xsd
file (I have two relate tables in my .xsd file "States" and "School". when you
select a state from the first dropdownlist the second dropdownlist suppose
to populate itself with the correct schools from that state. However, the
first list populate with the states, (I have autopostback set to true, and
the onchange event firing) but after the page postback the state
dropdownlist displays System.Data.Rel atedView over and over again. Thanks
for the help!
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message
news:Ox******** ******@TK2MSFTN GP11.phx.gbl... Hi Leon,
configuring a typed dataset only gets you halfway there (assuming that's
what you are doing with the XSD). What you still need to do by hand is
to write some ADO.NET code to establish the connection with the database
and to actually load stuff in your dataset. For example, you could define a
SqlDataAdapter, specify a SELECT... query and use .Fill with your typed
DataSet as parameter (if you use SQL Server). It may be a little
overkill to define a typed dataset and use a DataAdapter only to fill two dropdownlists. Take a look at the Data Access Application
Blocks(http://msdn.microsoft.com/netframewo...s/default.aspx ?pull=/library/en-us/dnbda/html/daab-rm.asp), it could be as easy as
this (C#):
DataSet MyDs = SqlHelper.Execu teDataSet( MyConnectionStr ing,
CommandType.Tex t, "select name, value from mytable" );
MyDropDownList. DataSource = MyDs.Tables[0];
MyDropDownList. DataTextField = "name";
MyDropDownList. DataValueField = "value";
MyDropDownList. DataBind();
Note that using a dataset always has some overhead, so you may want to
use a SqlDataReader for performance.
Best regards,
Marc Hoeppner
NeoGeo
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:OX******** ******@tk2msftn gp13.phx.gbl... After configuring a relation data schema (MyDataSet.xsd) in vs.net,
what code do you use to display that data within two dropdownlist controls
( parent/child) in an web application?
Well, basically you can have VS.NET do the grunt work for you. If you
right-click on your project file, select add, then add class, select dataset
and use any name you like (dataset1.xsd) is fine. Now use the server
explorer to drag a few tables in the XSD and use the toolbox to add
references and/or new fields as needed. Now, when you do this and compile
your project, VS.NET will use a tool (XGEN.EXE) to generate a C# file for
you that implements a strongly typed dataset. You can use it like any other
dataset but it is also a strongly typed class with all the parameters that
your tables have. You can also manually change the XSD file or use the GUI
to build your XSD from scratch.
But if all you want to do is to fill two DropDownLists I would recommend to
use the Data Access Application Blocks or simple ADO.NET to get a DataTable
for each table separately and attach these to the dropdownlists.
One other thing: you can help the databind process to find the right columns
to display by the user of DataTextField and DataValueField. For example, if
you have a DataTable with 4 columns (Company, Street, Country, CompanyID)
and you want the ddl to display the Company as text and have the CompanyID
as the value you'd do something like this:
MyDropDownList. DataSource = MyDataTable;
MyDropDownList. DataTextField = "Company";
MyDropDownList. DataValueField = "CompanyID" ;
MyDropDownList. DataBind();
Hope this helps!!
Best regards,
Marc Höppner
NeoGeo
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. .. Ok I have call the adatper.fill and databind command, but is'nt some type
of code such as Me.DataSet1.Wri teXmlSchema(Me. Request.Applica tionPath
"DataSet1.x sd" I have to type to get the database schema from the .xsd
file (I have two relate tables in my .xsd file "States" and "School". when you
select a state from the first dropdownlist the second dropdownlist suppose
to populate itself with the correct schools from that state. However, the
first list populate with the states, (I have autopostback set to true, and
the onchange event firing) but after the page postback the state
dropdownlist displays System.Data.Rel atedView over and over again. Thanks
for the help!
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message
news:Ox******** ******@TK2MSFTN GP11.phx.gbl... Hi Leon,
configuring a typed dataset only gets you halfway there (assuming that's
what you are doing with the XSD). What you still need to do by hand is
to write some ADO.NET code to establish the connection with the database
and to actually load stuff in your dataset. For example, you could define a
SqlDataAdapter, specify a SELECT... query and use .Fill with your typed
DataSet as parameter (if you use SQL Server). It may be a little
overkill to define a typed dataset and use a DataAdapter only to fill two dropdownlists. Take a look at the Data Access Application
Blocks(http://msdn.microsoft.com/netframewo...s/default.aspx ?pull=/library/en-us/dnbda/html/daab-rm.asp), it could be as easy as
this (C#):
DataSet MyDs = SqlHelper.Execu teDataSet( MyConnectionStr ing,
CommandType.Tex t, "select name, value from mytable" );
MyDropDownList. DataSource = MyDs.Tables[0];
MyDropDownList. DataTextField = "name";
MyDropDownList. DataValueField = "value";
MyDropDownList. DataBind();
Note that using a dataset always has some overhead, so you may want to
use a SqlDataReader for performance.
Best regards,
Marc Hoeppner
NeoGeo
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:OX******** ******@tk2msftn gp13.phx.gbl... After configuring a relation data schema (MyDataSet.xsd) in vs.net,
what code do you use to display that data within two dropdownlist controls
( parent/child) in an web application?
do you have remote desktop. I would like you to see want I'm doing for
yourself. I have did everything you stated, and have reference multiple
books and is yet to solve the problem. I thinking of setting up a parameter
stored procedure to get the state id to binding the right schools for that
state in the dropdownlist. The reason I chose the .xsd relational dataset
route, it easy to define relationships among tables. What do you think?
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message
news:Oc******** ******@TK2MSFTN GP11.phx.gbl... Well, basically you can have VS.NET do the grunt work for you. If you
right-click on your project file, select add, then add class, select
dataset and use any name you like (dataset1.xsd) is fine. Now use the server
explorer to drag a few tables in the XSD and use the toolbox to add
references and/or new fields as needed. Now, when you do this and compile
your project, VS.NET will use a tool (XGEN.EXE) to generate a C# file for
you that implements a strongly typed dataset. You can use it like any
other dataset but it is also a strongly typed class with all the parameters that
your tables have. You can also manually change the XSD file or use the GUI
to build your XSD from scratch.
But if all you want to do is to fill two DropDownLists I would recommend
to use the Data Access Application Blocks or simple ADO.NET to get a
DataTable for each table separately and attach these to the dropdownlists.
One other thing: you can help the databind process to find the right
columns to display by the user of DataTextField and DataValueField. For example,
if you have a DataTable with 4 columns (Company, Street, Country, CompanyID)
and you want the ddl to display the Company as text and have the CompanyID
as the value you'd do something like this:
MyDropDownList. DataSource = MyDataTable;
MyDropDownList. DataTextField = "Company";
MyDropDownList. DataValueField = "CompanyID" ;
MyDropDownList. DataBind();
Hope this helps!!
Best regards,
Marc Höppner
NeoGeo
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. .. Ok I have call the adatper.fill and databind command, but is'nt some
type of code such as Me.DataSet1.Wri teXmlSchema(Me. Request.Applica tionPath
"DataSet1.x sd" I have to type to get the database schema from the .xsd file (I have two relate tables in my .xsd file "States" and "School". when
you select a state from the first dropdownlist the second dropdownlist
suppose to populate itself with the correct schools from that state. However,
the first list populate with the states, (I have autopostback set to true,
and the onchange event firing) but after the page postback the state
dropdownlist displays System.Data.Rel atedView over and over again.
Thanks for the help!
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message
news:Ox******** ******@TK2MSFTN GP11.phx.gbl... Hi Leon,
configuring a typed dataset only gets you halfway there (assuming
that's what you are doing with the XSD). What you still need to do by hand is
to write some ADO.NET code to establish the connection with the database and to actually load stuff in your dataset. For example, you could define a
SqlDataAdapter, specify a SELECT... query and use .Fill with your
typed DataSet as parameter (if you use SQL Server). It may be a little
overkill to define a typed dataset and use a DataAdapter only to fill two
dropdownlists. Take a look at the Data Access Application
Blocks(http://msdn.microsoft.com/netframewo...s/default.aspx ?pull=/library/en-us/dnbda/html/daab-rm.asp), it could be as easy as this (C#):
DataSet MyDs = SqlHelper.Execu teDataSet( MyConnectionStr ing,
CommandType.Tex t, "select name, value from mytable" );
MyDropDownList. DataSource = MyDs.Tables[0];
MyDropDownList. DataTextField = "name";
MyDropDownList. DataValueField = "value";
MyDropDownList. DataBind();
Note that using a dataset always has some overhead, so you may want to use a SqlDataReader for performance.
Best regards,
Marc Hoeppner
NeoGeo
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:OX******** ******@tk2msftn gp13.phx.gbl...
> After configuring a relation data schema (MyDataSet.xsd) in vs.net,
what > code do you use to display that data within two dropdownlist
controls ( > parent/child) in an web application?
>
>
do you have remote desktop. I would like you to see want I'm doing for
yourself. I have did everything you stated, and have reference multiple
books and is yet to solve the problem. I thinking of setting up a parameter
stored procedure to get the state id to binding the right schools for that
state in the dropdownlist. The reason I chose the .xsd relational dataset
route, it easy to define relationships among tables. What do you think?
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message
news:Oc******** ******@TK2MSFTN GP11.phx.gbl... Well, basically you can have VS.NET do the grunt work for you. If you
right-click on your project file, select add, then add class, select
dataset and use any name you like (dataset1.xsd) is fine. Now use the server
explorer to drag a few tables in the XSD and use the toolbox to add
references and/or new fields as needed. Now, when you do this and compile
your project, VS.NET will use a tool (XGEN.EXE) to generate a C# file for
you that implements a strongly typed dataset. You can use it like any
other dataset but it is also a strongly typed class with all the parameters that
your tables have. You can also manually change the XSD file or use the GUI
to build your XSD from scratch.
But if all you want to do is to fill two DropDownLists I would recommend
to use the Data Access Application Blocks or simple ADO.NET to get a
DataTable for each table separately and attach these to the dropdownlists.
One other thing: you can help the databind process to find the right
columns to display by the user of DataTextField and DataValueField. For example,
if you have a DataTable with 4 columns (Company, Street, Country, CompanyID)
and you want the ddl to display the Company as text and have the CompanyID
as the value you'd do something like this:
MyDropDownList. DataSource = MyDataTable;
MyDropDownList. DataTextField = "Company";
MyDropDownList. DataValueField = "CompanyID" ;
MyDropDownList. DataBind();
Hope this helps!!
Best regards,
Marc Höppner
NeoGeo
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. .. Ok I have call the adatper.fill and databind command, but is'nt some
type of code such as Me.DataSet1.Wri teXmlSchema(Me. Request.Applica tionPath
"DataSet1.x sd" I have to type to get the database schema from the .xsd file (I have two relate tables in my .xsd file "States" and "School". when
you select a state from the first dropdownlist the second dropdownlist
suppose to populate itself with the correct schools from that state. However,
the first list populate with the states, (I have autopostback set to true,
and the onchange event firing) but after the page postback the state
dropdownlist displays System.Data.Rel atedView over and over again.
Thanks for the help!
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message
news:Ox******** ******@TK2MSFTN GP11.phx.gbl... Hi Leon,
configuring a typed dataset only gets you halfway there (assuming
that's what you are doing with the XSD). What you still need to do by hand is
to write some ADO.NET code to establish the connection with the database and to actually load stuff in your dataset. For example, you could define a
SqlDataAdapter, specify a SELECT... query and use .Fill with your
typed DataSet as parameter (if you use SQL Server). It may be a little
overkill to define a typed dataset and use a DataAdapter only to fill two
dropdownlists. Take a look at the Data Access Application
Blocks(http://msdn.microsoft.com/netframewo...s/default.aspx ?pull=/library/en-us/dnbda/html/daab-rm.asp), it could be as easy as this (C#):
DataSet MyDs = SqlHelper.Execu teDataSet( MyConnectionStr ing,
CommandType.Tex t, "select name, value from mytable" );
MyDropDownList. DataSource = MyDs.Tables[0];
MyDropDownList. DataTextField = "name";
MyDropDownList. DataValueField = "value";
MyDropDownList. DataBind();
Note that using a dataset always has some overhead, so you may want to use a SqlDataReader for performance.
Best regards,
Marc Hoeppner
NeoGeo
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:OX******** ******@tk2msftn gp13.phx.gbl...
> After configuring a relation data schema (MyDataSet.xsd) in vs.net,
what > code do you use to display that data within two dropdownlist
controls ( > parent/child) in an web application?
>
>
I am not sure I get what you want to do. Could you elaborate a little?
webform2.aspx is not good going practice at all as I load all customers and
all orders into the typed dataset. I think webform1.aspx is a much, much
better implementation (faster, easier to read, easier to change, faster...).
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. .. how do do that same code but reference the name of the relationship such
as (CustomersOrder s) in the DataSet1.xsd file to populate the dropdownlist.
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message
news:es******** ******@TK2MSFTN GP11.phx.gbl... With regards to your application, I still think there is an easier way
to do that. I am sure you know that by now, but just to be safe: You need be aware that typed datasets don't write the code for you to access and retrieve
data. You still need to do all the loading/saving etc. yourself in code.
Also, the databinding process for web controls does not automatically
take care of connected tables inside a dataset (typed or not), you also have
to do this yourself.
The straight-forward approach to solving your problem (using the
Northwind database) is attached to this post on page webform1.aspx. You need to
edit the connection string and the sample is done using SQL Server or MSDE.
The typed dataset version is on page webform2.aspx.
And yes, I have remote desktop, so we can set up a time if you want to
and I'll give it a quick look.
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:eo******** ******@TK2MSFTN GP12.phx.gbl... do you have remote desktop. I would like you to see want I'm doing for
yourself. I have did everything you stated, and have reference
multiple books and is yet to solve the problem. I thinking of setting up a
parameter stored procedure to get the state id to binding the right schools for that state in the dropdownlist. The reason I chose the .xsd relational dataset route, it easy to define relationships among tables. What do you
think?
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message
news:Oc******** ******@TK2MSFTN GP11.phx.gbl...
> Well, basically you can have VS.NET do the grunt work for you. If
you > right-click on your project file, select add, then add class, select
dataset
> and use any name you like (dataset1.xsd) is fine. Now use the server
> explorer to drag a few tables in the XSD and use the toolbox to add
> references and/or new fields as needed. Now, when you do this and
compile > your project, VS.NET will use a tool (XGEN.EXE) to generate a C#
file for > you that implements a strongly typed dataset. You can use it like
any other
> dataset but it is also a strongly typed class with all the
parameters that > your tables have. You can also manually change the XSD file or use
the GUI > to build your XSD from scratch.
>
> But if all you want to do is to fill two DropDownLists I would
recommend to
> use the Data Access Application Blocks or simple ADO.NET to get a
DataTable
> for each table separately and attach these to the dropdownlists.
>
> One other thing: you can help the databind process to find the right
columns
> to display by the user of DataTextField and DataValueField. For example, if
> you have a DataTable with 4 columns (Company, Street, Country,
CompanyID) > and you want the ddl to display the Company as text and have the
CompanyID > as the value you'd do something like this:
>
> MyDropDownList. DataSource = MyDataTable;
> MyDropDownList. DataTextField = "Company";
> MyDropDownList. DataValueField = "CompanyID" ;
> MyDropDownList. DataBind();
>
> Hope this helps!!
>
> Best regards,
>
> Marc Höppner
> NeoGeo
>
> "Leon Shaw" <vn*****@msn.co m> wrote in message
> news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..
> > Ok I have call the adatper.fill and databind command, but is'nt
some type
> of
> > code such as Me.DataSet1.Wri teXmlSchema(Me. Request.Applica tionPath
> > "DataSet1.x sd" I have to type to get the database schema from the
.xsd > file
> > (I have two relate tables in my .xsd file "States" and "School". when you
> > select a state from the first dropdownlist the second dropdownlist
suppose
> > to populate itself with the correct schools from that state. However, the
> > first list populate with the states, (I have autopostback set to true, and
> > the onchange event firing) but after the page postback the state
> > dropdownlist displays System.Data.Rel atedView over and over again.
Thanks
> > for the help!
> >
> > "Marc Hoeppner" <ma**********@h otmail.com> wrote in message
> > news:Ox******** ******@TK2MSFTN GP11.phx.gbl...
> > > Hi Leon,
> > >
> > > configuring a typed dataset only gets you halfway there
(assuming that's
> > > what you are doing with the XSD). What you still need to do by hand is > to
> > > write some ADO.NET code to establish the connection with the
database > and
> > to
> > > actually load stuff in your dataset. For example, you could
define a > > > SqlDataAdapter, specify a SELECT... query and use .Fill with
your typed
> > > DataSet as parameter (if you use SQL Server). It may be a little
> overkill
> > to
> > > define a typed dataset and use a DataAdapter only to fill two
> > dropdownlists.
> > > Take a look at the Data Access Application
> > >
> >
>
Blocks(http://msdn.microsoft.com/netframewo...s/default.aspx > > > ?pull=/library/en-us/dnbda/html/daab-rm.asp), it could be as
easy as > this
> > > (C#):
> > >
> > > DataSet MyDs = SqlHelper.Execu teDataSet( MyConnectionStr ing,
> > > CommandType.Tex t, "select name, value from mytable" );
> > >
> > > MyDropDownList. DataSource = MyDs.Tables[0];
> > > MyDropDownList. DataTextField = "name";
> > > MyDropDownList. DataValueField = "value";
> > > MyDropDownList. DataBind();
> > >
> > > Note that using a dataset always has some overhead, so you may
want to > use
> > a
> > > SqlDataReader for performance.
> > >
> > > Best regards,
> > >
> > > Marc Hoeppner
> > > NeoGeo
> > >
> > >
> > > "Leon Shaw" <vn*****@msn.co m> wrote in message
> > > news:OX******** ******@tk2msftn gp13.phx.gbl...
> > > > After configuring a relation data schema (MyDataSet.xsd) in
vs.net, > what
> > > > code do you use to display that data within two dropdownlist
controls
> (
> > > > parent/child) in an web application?
> > > >
> > > >
> > >
> > >
> >
> >
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: William C. White |
last post by:
Does anyone know of a way to use PHP /w Authorize.net AIM without using
cURL? Our website is hosted on a shared drive and the webhost company
doesn't installed additional software (such as cURL) on the server because
of that. Our site will have an SSL certificate next week, so I would like
to use AIM instead of SIM, however, I don't know how to send data via POST
over https and recieve data from the Authorize.net server over an https...
|
by: Albert Ahtenberg |
last post by:
Hello,
I don't know if it is only me but I was sure that header("Location:url")
redirects the browser instantly to URL, or at least stops the execution of
the code. But appearantely it continues to execute the code until the
browser send his reply to the header instruction. So an exit(); after each
redirection won't hurt at all
|
by: James |
last post by:
Hi,
I have a form with 2 fields.
'A'
'B'
The user completes one of the fields and the form is submitted.
On the results page I want to run a query, but this will change
subject to which field is completed.
|
by: Ollivier Robert |
last post by:
Hello,
I'm trying to link PHP with Oracle 9.2.0/OCI8 with gcc 3.2.3 on a Solaris9
system. The link succeeds but everytime I try to run php, I get a SEGV from
inside the libcnltsh.so library.
354 roberto@ausone:Build/php-4.3.2> ldd /opt/php4/bin/php
libsablot.so.0 => /usr/local/lib/libsablot.so.0
libstdc++.so.5 => /usr/local/lib/libstdc++.so.5
libm.so.1 => /usr/lib/libm.so.1
|
by: Richard Galli |
last post by:
I want viewers to compare state laws on a single subject.
Imagine a three-column table with a drop-down box on the top. A viewer
selects a state from the list, and that state's text fills the column below.
The viewer can select states from the drop down lists above the other two
columns as well. If the viewer selects only one, only one column fills. If
the viewer selects two states, two columns fill. Etc.
I could, if appropriate, have...
| | |
by: Albert Ahtenberg |
last post by:
Hello,
I have two questions.
1. When the user presses the back button and returns to a form he filled
the form is reseted. How do I leave there the values he inserted?
2. When the user comes back to a page where he had a submitted POST data
the browser keeps telling that the data has expired and asks if repost. How
to avoid that? I tried registering all POST and GET vars as SESSION vars but
|
by: inderjit S Gabrie |
last post by:
Hi all
Here is the scenerio ...is it possibly to do this...
i am getting valid course dates output on to a web which i have designed
....all is okay so far , look at the following web url
http://www.mis.gla.ac.uk/biquery/training/
but each of the courses held have maximum of 8 people that could be
|
by: Jack |
last post by:
Hi All,
What is the PHP equivilent of Oracle bind variables in a SQL statement, e.g.
select x from y where z=:parameter
Which in asp/jsp would be followed by some statements to bind a value to :parameter
I dont like the idea of making the SQL statement on the fly without binding parameters as I
dont want a highly polluted SQL cache.
|
by: Sandwick |
last post by:
I am trying to change the size of a drawing so they are all 3x3.
the script below is what i was trying to use to cut it in half ... I
get errors.
I can display the normal picture but not the results of the picture
half the size. The PHP I have installed support 1.62 or higher. And
all I would like to do is take and image and make it fit a 3x3.
Any suggestions to where I should read or look would be appreciated.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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.
| |
