Expression web video tutorial 19 Data View

Expression web video tutorial 19 Data View
Hello everyone, today I want to share with you the data view.
Data View is mainly a knowledge point in the database, because it is a basic tutorial. I will not give it to you, it will be too deep for you to digest it.

No more.
Let everyone laugh! ~
At the beginning, I will briefly introduce some links for creating data sources. First, prepare database files, such as access SQL.

A lot of data
I want to use access for other purposes. If you are interested, you can view the relevant materials or the courses provided by Tian daida.

Yes
In addition, I will not explain the controls one by one. I only have one or two controls.
View operations ~~~
We can see that the data source contains two local XML files and Asp.net connections.
First, I will show you Asp.net. First, find the Asp.net control-data-in the toolbox-

If not, you can adjust it in the task window.
Drag a gridview and create a data source.
The database can come from different data sources.
This is what we have prepared. We need to build it on our own and put it under the site.
Do not set the password and user name for logging on to the database to be empty.
Advanced is the specific settings for database connection.
A new link dialog box is displayed.
Give a name.
Saved in the web. config file
You do not need to create a new one for future use.
All operations are recommended.
Then we have the data we created displayed on the webpage.
These are SQL statements
We chose the default one for data retrieval.
Of course, you can also select the custom
These require more exercises and related SQL basics.
It seems that our SQL statement is shown below.
In fact, the same effect can be achieved by selecting the first custom
The results are the same.
You can set detailed sorting parameters such as conditional query.
Returns a unique value.
I will not do that anymore.
The view is actually the same as that of. NET 2005.
You can edit something and refer to some relevant knowledge.
Check the effect.
Wait for a while. The machine will be slow. In addition, starting the IIS service will be slow.
See it.
Of course, you need to set IIS.
Let me show you how
If not, install IIS.
I will not install it for you.
Select the directory of your site
See it.
You can click browse after I have created it.
I will give you the first one
First, create an XML
I will not create a new one to save time.
The format is the same as above.
If the view does not exist, use this method to import it.
Not under the website directory
Copy the XML file to the website directory.
Display View
Each record is displayed
View results
Haha success ~~~~~~~~~~
You can set display conditions.
View operations
See it. I am still dizzy.
You can practice more and view related knowledge.
You see, when the value is 601, the above value is 60.
Of course, you can set the condition to a range, for example, ><>=! =
I will not demonstrate them one by one.
Check the effect ~
The effect is obvious.
Thank you for watching this article ~~
Publish website http://hi.baidu.com/sr521
88