editablegridview.aspx

wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重推荐,电子书,电子书下载

									 </ItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipRegion" HeaderText="Ship Region"><EditItemTemplate>
									 <asp:TextBox ID="txtShipRegion" Runat="server" Width="108px" Text='<%# Bind("ShipRegion") %>'></asp:TextBox>
								 </EditItemTemplate>
									 <ItemStyle Wrap="False"></ItemStyle>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipRegion") %>' ID="Label11"></asp:Label>
									 </ItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipPostalCode" HeaderText="Ship PostalCode"><EditItemTemplate>
									 <asp:TextBox ID="txtShipPostalCode" Runat="server" Width="92px" Text='<%# Bind("ShipPostalCode") %>'></asp:TextBox>
								 </EditItemTemplate>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipPostalCode") %>' ID="Label12"></asp:Label>
									 </ItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipCountry" HeaderText="Ship Country"><EditItemTemplate>
									 <asp:TextBox ID="txtShipCountry" Runat="server" Width="100px" Text='<%# Bind("ShipCountry") %>'></asp:TextBox>
								 </EditItemTemplate>
									 <ItemStyle Wrap="False"></ItemStyle>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipCountry") %>' ID="Label13"></asp:Label>
									 </ItemTemplate>
								 </asp:TemplateField>
							 </Columns>
							 <SelectedRowStyle ForeColor="White" Font-Bold="True" BackColor="#008A8C"></SelectedRowStyle>
							 <RowStyle ForeColor="Black" BackColor="#EEEEEE"></RowStyle>
						 </asp:GridView>
						 <asp:SqlDataSource ID="dsOrdersEdit" Runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
							 SelectCommand="SELECT * FROM [Orders] ORDER BY [OrderID] DESC, [CustomerID]" DeleteCommand="DELETE FROM [Orders] WHERE [OrderID] = @original_OrderID"
							 InsertCommand="INSERT INTO [Orders] ([CustomerID], [EmployeeID], [OrderDate], [RequiredDate], [ShippedDate], [ShipVia], [Freight], [ShipName], [ShipAddress], [ShipCity], [ShipRegion], [ShipPostalCode], [ShipCountry]) VALUES (@CustomerID, @EmployeeID, @OrderDate, @RequiredDate, @ShippedDate, @ShipVia, @Freight, @ShipName, @ShipAddress, @ShipCity, @ShipRegion, @ShipPostalCode, @ShipCountry)"
							 UpdateCommand="UPDATE [Orders] SET [CustomerID] = @CustomerID, [EmployeeID] = @EmployeeID, [OrderDate] = @OrderDate, [RequiredDate] = @RequiredDate, [ShippedDate] = @ShippedDate, [ShipVia] = @ShipVia, [Freight] = @Freight, [ShipName] = @ShipName, [ShipAddress] = @ShipAddress, [ShipCity] = @ShipCity, [ShipRegion] = @ShipRegion, [ShipPostalCode] = @ShipPostalCode, [ShipCountry] = @ShipCountry WHERE [OrderID] = @original_OrderID">
							 <DeleteParameters>
								 <asp:Parameter Type="Int32" Name="OrderID"></asp:Parameter>
							 </DeleteParameters>
							 <UpdateParameters>
								 <asp:Parameter Type="String" Name="CustomerID"></asp:Parameter>
								 <asp:Parameter Type="Int32" Name="EmployeeID"></asp:Parameter>
								 <asp:Parameter Type="DateTime" Name="OrderDate"></asp:Parameter>
								 <asp:Parameter Type="DateTime" Name="RequiredDate"></asp:Parameter>
								 <asp:Parameter Type="DateTime" Name="ShippedDate" ConvertEmptyStringToNull=true></asp:Parameter>
								 <asp:Parameter Type="Int32" Name="ShipVia"></asp:Parameter>
								 <asp:Parameter Type="Decimal" Name="Freight"></asp:Parameter>
								 <asp:Parameter Type="String" Name="ShipName"></asp:Parameter>
								 <asp:Parameter Type="String" Name="ShipAddress"></asp:Parameter>
								 <asp:Parameter Type="String" Name="ShipCity"></asp:Parameter>
								 <asp:Parameter Type="String" Name="ShipRegion"></asp:Parameter>
								 <asp:Parameter Type="String" Name="ShipPostalCode"></asp:Parameter>
								 <asp:Parameter Type="String" Name="ShipCountry"></asp:Parameter>
								 <asp:Parameter Type="Int32" Name="OrderID"></asp:Parameter>
							 </UpdateParameters>
							 <InsertParameters>
								 <asp:Parameter Type="String" Name="CustomerID"></asp:Parameter>
								 <asp:Parameter Type="Int32" Name="EmployeeID"></asp:Parameter>
								 <asp:Parameter Type="DateTime" Name="OrderDate"></asp:Parameter>
								 <asp:Parameter Type="DateTime" Name="RequiredDate"></asp:Parameter>
								 <asp:Parameter Type="DateTime" Name="ShippedDate"></asp:Parameter>
								 <asp:Parameter Type="Int32" Name="ShipVia"></asp:Parameter>
								 <asp:Parameter Type="Decimal" Name="Freight"></asp:Parameter>
								 <asp:Parameter Type="String" Name="ShipName"></asp:Parameter>
								 <asp:Parameter Type="String" Name="ShipAddress"></asp:Parameter>
								 <asp:Parameter Type="String" Name="ShipCity"></asp:Parameter>
								 <asp:Parameter Type="String" Name="ShipRegion"></asp:Parameter>
								 <asp:Parameter Type="String" Name="ShipPostalCode"></asp:Parameter>
								 <asp:Parameter Type="String" Name="ShipCountry"></asp:Parameter>
							 </InsertParameters>
						 </asp:SqlDataSource>
                         <asp:ObjectDataSource ID="odsOrdersEdit" runat="server" DeleteMethod="Delete"
                             InsertMethod="Insert" SelectMethod="GetOrders" TypeName="OrdersDataSetTableAdapters.OrdersTableAdapter"
                             UpdateMethod="Update">
                             <DeleteParameters>
                                 <asp:Parameter Name="Original_OrderID" Type="Int32" />
                             </DeleteParameters>
                             <UpdateParameters>
                                 <asp:Parameter Name="CustomerID" Type="String" />
                                 <asp:Parameter Name="EmployeeID" Type="Int32" />
                                 <asp:Parameter Name="OrderDate" Type="DateTime" />
                                 <asp:Parameter Name="RequiredDate" Type="DateTime" />
                                 <asp:Parameter Name="ShippedDate" Type="DateTime" />
                                 <asp:Parameter Name="ShipVia" Type="Int32" />
                                 <asp:Parameter Name="Freight" Type="Decimal" />
                                 <asp:Parameter Name="ShipName" Type="String" />
                                 <asp:Parameter Name="ShipAddress" Type="String" />
                                 <asp:Parameter Name="ShipCity" Type="String" />
                                 <asp:Parameter Name="ShipRegion" Type="String" />
                                 <asp:Parameter Name="ShipPostalCode" Type="String" />
                                 <asp:Parameter Name="ShipCountry" Type="String" />
                                 <asp:Parameter Name="Original_OrderID" Type="Int32" />
                             </UpdateParameters>
                             <InsertParameters>
                                 <asp:Parameter Name="CustomerID" Type="String" />
                                 <asp:Parameter Name="EmployeeID" Type="Int32" />
                                 <asp:Parameter Name="OrderDate" Type="DateTime" />
                                 <asp:Parameter Name="RequiredDate" Type="DateTime" />
                                 <asp:Parameter Name="ShippedDate" Type="DateTime" />
                                 <asp:Parameter Name="ShipVia" Type="Int32" />
                                 <asp:Parameter Name="Freight" Type="Decimal" />
                                 <asp:Parameter Name="ShipName" Type="String" />
                                 <asp:Parameter Name="ShipAddress" Type="String" />
                                 <asp:Parameter Name="ShipCity" Type="String" />
                                 <asp:Parameter Name="ShipRegion" Type="String" />
                                 <asp:Parameter Name="ShipPostalCode" Type="String" />
                                 <asp:Parameter Name="ShipCountry" Type="String" />
                             </InsertParameters>
                         </asp:ObjectDataSource>
						 <asp:SqlDataSource ID="dsEmployees" Runat="server" SelectCommand="SELECT [EmployeeID], [LastName] FROM [Employees] ORDER BY [LastName]"
							 ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>">
						 </asp:SqlDataSource>
						 <asp:SqlDataSource ID="dsShippers" Runat="server" SelectCommand="SELECT [ShipperID], [CompanyName] FROM [Shippers] ORDER BY [CompanyName]"
							 ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>">
						 </asp:SqlDataSource>
					 </td>
				 </tr>
			 </table>
		 </div>
    </div>
    </form>
</body>
</html>