Low cost ecommerce web development India flash website design
Now you’ll create a recordset to display data that is stored in a database.
A recordset is a subset of
information extracted from a database by a database query. (In ASP.NET,. a recordset
is known as
a DataSet.) A database query consists of search criteria, which defines what’s
included in the
recordset. You then use the information extracted as a source of data for your
dynamic pages.
Dreamweaver MX provides an easy-to-use interface for creating simple SQL queries—you
don’t
need to know SQL to create a recordset in Dreamweaver.
You’ll create a recordset that selects all of the values from the Locations
table.
1 In Dreamweaver, open the Recordset or DataSet (ASP.NET) dialog box by doing
one of the
following:
• In the Insert bar’s Application tab, click the Recordset or DataSet
(ASP.NET) button.
• Choose Window > Bindings to open the Bindings panel, then click the
Plus (+) button and
select Recordset or DataSet.
• In the Application panel group, select the Bindings panel, then click
the Plus (+) button and
select Recordset or DataSet.
The Recordset or DataSet dialog box appears. The screen below shows the ColdFusion
recordset dialog box. (In ASP.NET this is the DataSet dialog box; most of the
recordset options
are the same for all server models.)
2 In the Name text box, enter rsLocations.
This is the name of the recordset you are defining.
3 In the Data Source pop-up menu (ColdFusion) or the Connection pop-up menu
(other server
page types), select connGlobal.
The Recordset or DataSet dialog box updates and displays information for the
first table in the
Global database.
Note: If the connGlobal connection doesn’t appear in the menu, click the
Define button to create it.
4 In the Table pop-up menu, select LOCATIONS.
The recordset updates with records in the LOCATIONS table.
5 For Columns, accept the default setting, All.
Tip: To limit the information the recordset includes you can choose Selected,
then select the column(s) you want
to work with.
6 Click Test to test the recordset.
The database records that match your recordset request are displayed in the
Test SQL
Statement window.
7 Click OK to close the Test SQL Statement window.
8 Click OK to close the Recordset or DataSet dialog box, and add the recordset
code to your page.
Dreamweaver confirms that a recordset has been added to the page and the recordset
appears in
the Bindings panel.
4 With the text field still selected, in the Property inspector, enter state_country
in the Name
text box and enter 30 in the Char Width text box.
5 In the document, place the insertion point in the table cell to the right
of the Region label,
then do one of the following to insert a List/Menu:
• In the Insert bar’s Forms category, click the List/Menu button
or drag it from the Insert bar to
the table cell.
• Choose Insert > Form Objects > Text Field
The list/menu form object inserts in the document.
website designer freelance ASP PHP ecommerce web developer
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110