Работа с базами данных (продолжение). Элементы-источники данных (Data Source Controls)

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" 
SelectMethod="GetData" 
TypeName="CustomersTableAdapters.CustomersTableAdapter" 
DeleteMethod="Delete" InsertMethod="Insert" 
OldValuesParameterFormatString="original_{0}" 
UpdateMethod="Update">
    <DeleteParameters>
        <asp:Parameter Name="Original_CustomerID" Type="String" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="CustomerID" Type="String" />
        <asp:Parameter Name="CompanyName" Type="String" />
        <asp:Parameter Name="ContactName" Type="String" />
        <asp:Parameter Name="ContactTitle" Type="String" />
        <asp:Parameter Name="Country" Type="String" />
        <asp:Parameter Name="City" Type="String" />
        <asp:Parameter Name="Original_CustomerID" Type="String" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="CustomerID" Type="String" />
        <asp:Parameter Name="CompanyName" Type="String" />
        <asp:Parameter Name="ContactName" Type="String" />
        <asp:Parameter Name="ContactTitle" Type="String" />
        <asp:Parameter Name="Country" Type="String" />
        <asp:Parameter Name="City" Type="String" />
    </InsertParameters>
</asp:ObjectDataSource>
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
AllowSorting="True"
    AutoGenerateColumns="False" DataKeyNames="CustomerID" 
DataSourceID="1">
    <Columns>
        <asp:CommandField ShowDeleteButton="True" 
ShowEditButton="True" ShowSelectButton="True" />
        <asp:BoundField DataField="CustomerID" 
HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" />
        <asp:BoundField DataField="CompanyName" 
HeaderText="CompanyName" SortExpression="CompanyName" />
        <asp:BoundField DataField="ContactName" 
HeaderText="ContactName" SortExpression="ContactName" />
        <asp:BoundField DataField="ContactTitle" 
HeaderText="ContactTitle" SortExpression="ContactTitle" />
        <asp:BoundField DataField="Country" HeaderText="Country" 
SortExpression="Country" />
        <asp:BoundField DataField="City" HeaderText="City" 
SortExpression="City" />
    </Columns>
</asp:GridView>

xsd.exe /dataset /language:CS Customers.xsd.

public static Stream GetPhoto(int photoid, PhotoSize size)
  {
    using (SqlConnection connection = new 
SqlConnection(ConfigurationManager.ConnectionStrings["Personal"].C
onnectionString)) {
      using (SqlCommand command = new SqlCommand("GetPhoto", con-
nection)) {
        command.CommandType = CommandType.StoredProcedure;
        command.Parameters.Add(new SqlParameter("@PhotoID", 
photoid));
        command.Parameters.Add(new SqlParameter("@Size", 
(int)size));
        bool filter = 
!(HttpContext.Current.User.IsInRole("Friends") || 
HttpContext.Current.User.IsInRole("Administrators"));
        command.Parameters.Add(new SqlParameter("@IsPublic", 
filter));
        connection.Open();
        object result = command.ExecuteScalar();
        try {
          return new MemoryStream((byte[])result);
        } catch {
          return null;
        }
      }
    }