As
mentioned earlier, a SQL 2005 Express data file is the data container for Scott??™s ToDo List
application and resides in the App_Data folder of the site. You may have to manually add
the ASP.NET user of your machine to this database before being able to access it. This
database has only one table called Tasks with three fields as shown in Figure 6.10.
CHAPTER 6 ?– USING SERVER CONTROLS IN ASP.NET AJAX 125
Figure 6-10. Tasks table containing all data for the ToDo List application
As you can see, this table contains the bare minimum columns required to run a
ToDo List application. The first field is an int field, TaskId, which is also the primary key
of this table and thus cannot be null. It is set to Identity so that each new task gets a
unique ID (one larger than the previous ID) that increments by one for each new task
that is added. The second field is Name with varchar(100) as its type. The third and the
final field is Complete, which is just a bit field (SQL type for boolean) representing the
check box. Once again, keep in mind that you can easily modify the table and the
corresponding code to add support for additional fields or functionality.
Pages:
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200