Вот так у меня работает:

<asp:detailsview id="CustomerDetailView"
datasourceid="DetailsViewSource"
datakeynames="CustomerID"
autogenerateeditbutton="true"
AutoGenerateInsertButton="true"
autogeneraterows="true"
allowpaging="true"
runat="server">

<headerstyle backcolor="Navy"
forecolor="White"/>

</asp:detailsview>

<asp:SqlDataSource ID="DetailsViewSource" runat="server"
ConnectionString="Data Source=SYSADMIN;Initial Catalog=Northwind;Integrated Security=True"
UpdateCommand="UPDATE [Customers] SET
[CompanyName]= @CompanyName, [Address]=@Address, [City]=@City, [PostalCode]=@PostalCode, [Country]=@Country;"

InsertCommand="INSERT INTO [Customers]([CustomerID],
[CompanyName], [Address], [City], [PostalCode], [Country])
VALUES (@CustomerID, @CompanyName, @Address, @City,
@PostalCode, @Country)"
SelectCommand="Select [CustomerID], [CompanyName],
[Address], [City], [PostalCode], [Country]
From [Customers]">
</asp:SqlDataSource>