Create Views

2,6 Lượt xem Tạo Sau khi bạn ra con số bạn muốn sử dụng một lần xem, các trick là để tạo ra nó bằng cách sử dụng thiết kế. Điều này thế nào-Để giải thích làm thế nào để làm điều này từ bên trong Visual Studio NET,. Bao gồm xác định thứ tự sắp xếp và tiêu chuẩn.
Nội dung trích xuất từ tài liệu:
Create Views 2.6 Create ViewsAfter you figure out you want to use a view, the trick is to create it by using the designer.This How-To explains how to do this from within Visual Studio .NET, includingspecifying sort order and criteria.Now that you have your tables created, with relationships in place, you can add data bydouble-clicking the table name in the Server Explorer. I also know how to bind forms andcontrols to data using data binding from the last chapter. How do you create views, usingVS .NET?TechniqueWithin SQL Server, you can view and manipulate data using one of three ways: • Views. These allow you to display different views of your data, including joining tables, sorting (SQL Server 200x), and using criteria. Views are limited to using the SELECT statement, and they can be used as the base for updating as well displaying data. Views are great when you need to filter your data but want to be able to update like you would a single table. • Stored procedures. Perform bulk operations such as updating, inserting, and deleting records. You can also create select queries that can be sorted. Another difference from Views is that you can use multiple SQL and control-of-flow statements within a stored procedure. You can also use parameters with stored procedures. • User-defined functions. User-defined functions are one of three types: Scalar, Table, and In-Line. These types combine the best features of views and stored procedures into a single query that you can nest, pass parameters to, sort, and return values.You can find more on stored procedures in How-To 2.7.When you want to have various views of your data that you will want to use throughoutyour application(s), you can create views to do so. You can then use the view to populateforms, controls, and reports.Note In versions of SQL Server prior to 2000, use of views was frowned upon because of performance and sorting limitations, among other reasons. This has changed with 2000, where views are more flexible and offer better performance.Within Visual Studio .NET, you can create, update, and delete SQL Server views all fromwithin the Server Explorer, within the desired database. To work with views, you will usethe Views Designer. For new views, you will choose New View while right-clicking onthe Views node in the database. If youre editing, choose Design View while right-clicking on the desired view. You will then be taken into the View Designer, as shown inFigure 2.10, with the view called Current Product List.Figure 2.10. Using the View Designer, you can see the tables you want to include, the fields you are using, the SQL Statement created, and even the data that will be returned.As you can see from Figure 2.9, the View Designer has the four main areas mentioned: • Diagram pane. This area allows you to display the table or tables(s) that you will be using in your view. This could also contain the following: other views, user- defined functions, sub queries (in FROM clause, and linked views. You will also see check boxes (or other objects) flowing down the left side of the tables. These allow you to choose fields that you want to include. You can also see some other icons along the right side of the tables, when grouping and sorting fields or when using criteria. You will see examples of these if you look through the existing views in Northwind. You can also join tables so that you can view data using multiple record sources.• Grid Pane. This is where you will specify how you want individual columns to be handled within the view. The following table describes each property:Column DescriptionColumn Display of either the name of a data column used for the query or the expression for a computed column.Alias The name you want to use in the result set. This allows you to either rename an existing column or name a new computed column. You might want to rename an existing column if you have the same column used in two different tables.Table The name of the table where the column is from.Output Whether to display the column in the results set.Sort Whether you want to sort the column in ascending or descending order.Type If you dont want to sort on the column, leave it blank.Sort Here you will specify where in the sorted columns you want to includeOrder this column. You can place a number that corresponds with the column order that you want this column included in.Group This is where you specify that you want to use the current column forBy aggregating information. To get this column to show, you need to choose Group By from the Query menu. Besides Grouping data on this column, you can also specify functions such as Min, Max, Count, and more.Criteria This column allows you to specify to which value you would like to compare the column to narrow down and return specific records. If you specify values in multiple columns, you will create a Boolean (AND) expression.Or Placing values in these columns will cause Boolean (OR) expressions to be created. • SQL Pane. You will see the SQL Select statement that is created by filling in the two previous panes mentioned. • Results Pane. As the title suggests, this pane will display the results of the view created when you click the Run Query toolbar button, which is the exclamation.StepsTo learn how to create a view in Visual Studio .NET, you will create a view that displaysall the orders for a given date ...