<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" ForeColor="#990000"
AutoGenerateEditButton="True" onrowupdated="GridView1_RowUpdated"
onselectedindexchanged="GridView1_SelectedIndexChanged"
AllowSorting="True">
<Columns>
<asp:CommandField ShowSelectButton="True" />
<asp:BoundField DataField="ship_id" HeaderText="Shipment ID" InsertVisible="False"
ReadOnly="True" SortExpression="ship_id" />
<asp:BoundField DataField="ship_date" HeaderText="Shipping Date"
SortExpression="ship_date" />
<asp:BoundField DataField="ship_Service" HeaderText="Shipment Service"
SortExpression="ship_Service" />
<asp:BoundField DataField="Ship_address" HeaderText="Shipping Address"
SortExpression="Ship_address" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:omstoreConnectionString %>"
SelectCommand="SELECT [ship_id], [ship_date], [ship_Service], [Ship_address] FROM [ordermng]"
DeleteCommand="DELETE FROM [ordermng] WHERE [ship_id] = @ship_id"
InsertCommand="INSERT INTO [ordermng] ([ship_id], [ship_date], [ship_service], [ship_address]) VALUES (@ship_id, @ship_date, @ship_service, @ship_address)"
UpdateCommand="UPDATE [ordermng] SET [ship_date] = @ship_date, [ship_service] = @ship_service, [ship_address] = @ship_address WHERE [ship_id] = @ship_id">
<DeleteParameters>
<asp:Parameter Name="ship_id" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ship_date" Type="DateTime" />
<asp:Parameter Name="ship_service" Type="String" />
<asp:Parameter Name="ship_address" Type="String" />
<asp:Parameter Name="ship_id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ship_date" Type="DateTime" />
<asp:Parameter Name="ship_service" Type="String" />
<asp:Parameter Name="ship_address" Type="String" />
<asp:Parameter Name="ship_id" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>