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?
Nov 17 '05
16 1862
So I should set up a store procedure in my MS SQL 2000 database for cities
(@StateID) and get the StateDropDownLi st.DataValueFie ld and pass that value
(@StateID) to display the correct Schools in the SchoolDropDownl ist?
Correct!
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message
news:uJ******** ******@tk2msftn gp13.phx.gbl... 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? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Yes, you can do that!
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:%2******** *******@tk2msft ngp13.phx.gbl.. . So I should set up a store procedure in my MS SQL 2000 database for cities (@StateID) and get the StateDropDownLi st.DataValueFie ld and pass that
value (@StateID) to display the correct Schools in the SchoolDropDownl ist? Correct!
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message news:uJ******** ******@tk2msftn gp13.phx.gbl... 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? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
is that a better way, and more efficient way of doing it? However, Thanks
for all the help!
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. .. Yes, you can do that!
"Leon Shaw" <vn*****@msn.co m> wrote in message news:%2******** *******@tk2msft ngp13.phx.gbl.. . So I should set up a store procedure in my MS SQL 2000 database for
cities (@StateID) and get the StateDropDownLi st.DataValueFie ld and pass that value (@StateID) to display the correct Schools in the SchoolDropDownl ist? Correct!
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message news:uJ******** ******@tk2msftn gp13.phx.gbl... 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? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
I GOT IT TO WORK. THANKS SO MUCH, but so What you are saying is that I don't
even have to use a dataset at all. All I really need to do is use
sqlcommands to pull data into my form for easy selection Then use a dataset
to pull all the information from every form field and update the database?
Correct
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message
news:Oc******** ******@TK2MSFTN GP12.phx.gbl... The method used in webform1.aspx should be a lot better than using typed datasets in this case. Depending on your scenario you could some caching
or even load all the orders (in this case) in a dataset if all customers get selected pretty frequently.
If you still shoot for the typed dataset, you can start with the webform2.aspx sample and go from there. You can change the sample to use SPROCs instead of inline SQL, but you still will have to do the filtering
of the dataset either in T-SQL or by use of the Select or Filter functions in DataSet/DataTable manually. :)
"Leon Shaw" <vn*****@msn.co m> wrote in message news:Oz******** ******@TK2MSFTN GP11.phx.gbl... is that a better way, and more efficient way of doing it? However,
Thanks for all the help! "Marc Hoeppner" <ma**********@h otmail.com> wrote in message news:%2******** ********@tk2msf tngp13.phx.gbl. .. Yes, you can do that!
"Leon Shaw" <vn*****@msn.co m> wrote in message news:%2******** *******@tk2msft ngp13.phx.gbl.. . > So I should set up a store procedure in my MS SQL 2000 database for cities > (@StateID) and get the StateDropDownLi st.DataValueFie ld and pass
that value > (@StateID) to display the correct Schools in the SchoolDropDownl ist? > Correct! > > > "Marc Hoeppner" <ma**********@h otmail.com> wrote in message > news:uJ******** ******@tk2msftn gp13.phx.gbl... > > 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? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Great, congrats!!
A dataset is very powerfull on the one hand, but on the other has a lot of
overhead. So you need to use it appropriately. Yes, you don't need a dataset
to fill a dropdownlist, but you also have to count other factors such as
ease of use and amount of code to type. So, I'd use something similar to the
webform1.aspx approach and make sure that the page caching is set to a long
time period if your data does not changes very often. This way you have the
ease of use as in the first sample, but the database code only gets called a
few times a time for example. So, this was selecting data.
Inserting/updating data can be done by a dataset as well, but if you only
update a few items in a form you can as well use an SPROC and send it the
values from your form directly without a dataset. If you have a larger
application and use data over and over again on different pages, it may be a
good idea to build a couple of typed datasets where appropriate and use them
both for selecting and for inserting/updating.
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:eg******** ******@TK2MSFTN GP10.phx.gbl... I GOT IT TO WORK. THANKS SO MUCH, but so What you are saying is that I
don't even have to use a dataset at all. All I really need to do is use sqlcommands to pull data into my form for easy selection Then use a
dataset to pull all the information from every form field and update the database? Correct "Marc Hoeppner" <ma**********@h otmail.com> wrote in message news:Oc******** ******@TK2MSFTN GP12.phx.gbl... The method used in webform1.aspx should be a lot better than using typed datasets in this case. Depending on your scenario you could some caching or even load all the orders (in this case) in a dataset if all customers
get selected pretty frequently.
If you still shoot for the typed dataset, you can start with the webform2.aspx sample and go from there. You can change the sample to use SPROCs instead of inline SQL, but you still will have to do the
filtering of the dataset either in T-SQL or by use of the Select or Filter functions
in DataSet/DataTable manually. :)
"Leon Shaw" <vn*****@msn.co m> wrote in message news:Oz******** ******@TK2MSFTN GP11.phx.gbl... is that a better way, and more efficient way of doing it? However, Thanks for all the help! "Marc Hoeppner" <ma**********@h otmail.com> wrote in message news:%2******** ********@tk2msf tngp13.phx.gbl. .. > Yes, you can do that! > > "Leon Shaw" <vn*****@msn.co m> wrote in message > news:%2******** *******@tk2msft ngp13.phx.gbl.. . > > So I should set up a store procedure in my MS SQL 2000 database
for cities > > (@StateID) and get the StateDropDownLi st.DataValueFie ld and pass that > value > > (@StateID) to display the correct Schools in the
SchoolDropDownl ist? > > Correct! > > > > > > "Marc Hoeppner" <ma**********@h otmail.com> wrote in message > > news:uJ******** ******@tk2msftn gp13.phx.gbl... > > > 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? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Thanks So Much! I will surely apply and share the knowledge.
"Marc Hoeppner" <ma**********@h otmail.com> wrote in message
news:Ow******** ******@TK2MSFTN GP11.phx.gbl... Great, congrats!!
A dataset is very powerfull on the one hand, but on the other has a lot of overhead. So you need to use it appropriately. Yes, you don't need a
dataset to fill a dropdownlist, but you also have to count other factors such as ease of use and amount of code to type. So, I'd use something similar to
the webform1.aspx approach and make sure that the page caching is set to a
long time period if your data does not changes very often. This way you have
the ease of use as in the first sample, but the database code only gets called
a few times a time for example. So, this was selecting data. Inserting/updating data can be done by a dataset as well, but if you only update a few items in a form you can as well use an SPROC and send it the values from your form directly without a dataset. If you have a larger application and use data over and over again on different pages, it may be
a good idea to build a couple of typed datasets where appropriate and use
them both for selecting and for inserting/updating.
"Leon Shaw" <vn*****@msn.co m> wrote in message news:eg******** ******@TK2MSFTN GP10.phx.gbl... I GOT IT TO WORK. THANKS SO MUCH, but so What you are saying is that I don't even have to use a dataset at all. All I really need to do is use sqlcommands to pull data into my form for easy selection Then use a dataset to pull all the information from every form field and update the
database? Correct "Marc Hoeppner" <ma**********@h otmail.com> wrote in message news:Oc******** ******@TK2MSFTN GP12.phx.gbl... The method used in webform1.aspx should be a lot better than using
typed datasets in this case. Depending on your scenario you could some
caching or even load all the orders (in this case) in a dataset if all customers get selected pretty frequently.
If you still shoot for the typed dataset, you can start with the webform2.aspx sample and go from there. You can change the sample to
use SPROCs instead of inline SQL, but you still will have to do the
filtering of the dataset either in T-SQL or by use of the Select or Filter
functions in DataSet/DataTable manually. :)
"Leon Shaw" <vn*****@msn.co m> wrote in message news:Oz******** ******@TK2MSFTN GP11.phx.gbl... > is that a better way, and more efficient way of doing it? However, Thanks > for all the help! > "Marc Hoeppner" <ma**********@h otmail.com> wrote in message > news:%2******** ********@tk2msf tngp13.phx.gbl. .. > > Yes, you can do that! > > > > "Leon Shaw" <vn*****@msn.co m> wrote in message > > news:%2******** *******@tk2msft ngp13.phx.gbl.. . > > > So I should set up a store procedure in my MS SQL 2000 database for > cities > > > (@StateID) and get the StateDropDownLi st.DataValueFie ld and pass that > > value > > > (@StateID) to display the correct Schools in the SchoolDropDownl ist? > > > Correct! > > > > > > > > > "Marc Hoeppner" <ma**********@h otmail.com> wrote in message > > > news:uJ******** ******@tk2msftn gp13.phx.gbl... > > > > 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? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Excellent, glad to be of help!
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:Ou******** ******@TK2MSFTN GP10.phx.gbl... Thanks So Much! I will surely apply and share the knowledge. "Marc Hoeppner" <ma**********@h otmail.com> wrote in message news:Ow******** ******@TK2MSFTN GP11.phx.gbl... Great, congrats!!
A dataset is very powerfull on the one hand, but on the other has a lot
of overhead. So you need to use it appropriately. Yes, you don't need a dataset to fill a dropdownlist, but you also have to count other factors such as ease of use and amount of code to type. So, I'd use something similar to the webform1.aspx approach and make sure that the page caching is set to a long time period if your data does not changes very often. This way you have the ease of use as in the first sample, but the database code only gets
called a few times a time for example. So, this was selecting data. Inserting/updating data can be done by a dataset as well, but if you
only update a few items in a form you can as well use an SPROC and send it
the values from your form directly without a dataset. If you have a larger application and use data over and over again on different pages, it may
be a good idea to build a couple of typed datasets where appropriate and use them both for selecting and for inserting/updating.
"Leon Shaw" <vn*****@msn.co m> wrote in message news:eg******** ******@TK2MSFTN GP10.phx.gbl... I GOT IT TO WORK. THANKS SO MUCH, but so What you are saying is that I don't even have to use a dataset at all. All I really need to do is use sqlcommands to pull data into my form for easy selection Then use a dataset to pull all the information from every form field and update the database? Correct "Marc Hoeppner" <ma**********@h otmail.com> wrote in message news:Oc******** ******@TK2MSFTN GP12.phx.gbl... > The method used in webform1.aspx should be a lot better than using typed > datasets in this case. Depending on your scenario you could some caching or > even load all the orders (in this case) in a dataset if all
customers get > selected pretty frequently. > > If you still shoot for the typed dataset, you can start with the > webform2.aspx sample and go from there. You can change the sample to use > SPROCs instead of inline SQL, but you still will have to do the filtering of > the dataset either in T-SQL or by use of the Select or Filter functions in > DataSet/DataTable manually. > :) > > "Leon Shaw" <vn*****@msn.co m> wrote in message > news:Oz******** ******@TK2MSFTN GP11.phx.gbl... > > is that a better way, and more efficient way of doing it? However, Thanks > > for all the help! > > "Marc Hoeppner" <ma**********@h otmail.com> wrote in message > > news:%2******** ********@tk2msf tngp13.phx.gbl. .. > > > Yes, you can do that! > > > > > > "Leon Shaw" <vn*****@msn.co m> wrote in message > > > news:%2******** *******@tk2msft ngp13.phx.gbl.. . > > > > So I should set up a store procedure in my MS SQL 2000
database for > > cities > > > > (@StateID) and get the StateDropDownLi st.DataValueFie ld and
pass that > > > value > > > > (@StateID) to display the correct Schools in the SchoolDropDownl ist? > > > > Correct! > > > > > > > > > > > > "Marc Hoeppner" <ma**********@h otmail.com> wrote in message > > > > news:uJ******** ******@tk2msftn gp13.phx.gbl... > > > > > 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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |