Question

to find something from database we use a​

Answer 1

In a database, a view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object. This pre-established query command is kept in the database dictionary.

Answer 2

Add a data source

1). If the Data Sources window isn't open, open it by pressing Shift+Alt+D or selecting View > Other Windows > Data Sources on the menu bar.

2). In the Data Sources window, select the Add New Data Source link.

3). The Data Source Configuration Wizard opens.

4). On the Choose a Data Source Type page, choose Database and then choose Next.

5). On the Choose a Database Model page, choose Next to accept the default (Dataset).

6) On the Choose Your Data Connection page, select the SampleDatabase.mdf file in the drop-down list, and then choose Next.

7). On the Save the Connection String to the Application Configuration File page, choose Next.

8 ) One the Choose your Database Objects page, you'll see a message that says the database doesn't contain any objects. Choose Finish.