当前文件： AppleVote/App_Code/new.xsd[7K，2009-6-12 11:31:41]，打开代码结构图

		            
 1<?xml version="1.0" encoding="utf-8"?>
 2<xs:schema id="new" targetNamespace="http://tempuri.org/new.xsd" xmlns:mstns="http://tempuri.org/new.xsd" xmlns="http://tempuri.org/new.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
 3  <xs:annotation>
 4    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
 5      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
 6        <Connections>
 7          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="voteConnectionString2" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="voteConnectionString2 (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.voteConnectionString2.ConnectionString" Provider="System.Data.SqlClient">
 8          </Connection>
 9          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="voteConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="voteConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.voteConnectionString.ConnectionString" Provider="System.Data.SqlClient">
10          </Connection>
11        </Connections>
12        <Tables>
13          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="newNRBTableAdapter" GeneratorDataComponentClassName="newNRBTableAdapter" Name="newNRB" UserDataComponentName="newNRBTableAdapter">
14            <MainSource>
15              <DbSource ConnectionRef="voteConnectionString (Web.config)" DbObjectName="vote.dbo.newNRB" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetTitle" GetMethodModifier="Public" GetMethodName="GetTitle" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetTitle" UserSourceName="GetTitle">
16                <DeleteCommand>
17                  <DbCommand CommandType="Text" ModifiedByUser="False">
18                    <CommandText>DELETE FROM [newNRB] WHERE (([id] = @Original_id))</CommandText>
19                    <Parameters>
20                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original">
21                      </Parameter>
22                    </Parameters>
23                  </DbCommand>
24                </DeleteCommand>
25                <SelectCommand>
26                  <DbCommand CommandType="Text" ModifiedByUser="True">
27                    <CommandText>SELECT     biaoti, shijian, id
28FROM         newNRB
29WHERE     (shijian = @time)</CommandText>
30                    <Parameters>
31                      <Parameter AllowDbNull="False" AutogeneratedName="time" ColumnName="shijian" DataSourceName="vote.dbo.newNRB" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@time" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="shijian" SourceColumnNullMapping="False" SourceVersion="Current">
32                      </Parameter>
33                    </Parameters>
34                  </DbCommand>
35                </SelectCommand>
36                <UpdateCommand>
37                  <DbCommand CommandType="Text" ModifiedByUser="False">
38                    <CommandText>UPDATE [newNRB] SET [biaoti] = @biaoti, [shijian] = @shijian WHERE (([id] = @Original_id))</CommandText>
39                    <Parameters>
40                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@biaoti" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="biaoti" SourceColumnNullMapping="False" SourceVersion="Current">
41                      </Parameter>
42                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@shijian" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="shijian" SourceColumnNullMapping="False" SourceVersion="Current">
43                      </Parameter>
44                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original">
45                      </Parameter>
46                    </Parameters>
47                  </DbCommand>
48                </UpdateCommand>
49              </DbSource>
50            </MainSource>
51            <Mappings>
52              <Mapping SourceColumn="biaoti" DataSetColumn="biaoti" />
53              <Mapping SourceColumn="shijian" DataSetColumn="shijian" />
54              <Mapping SourceColumn="id" DataSetColumn="id" />
55            </Mappings>
56            <Sources>
57            </Sources>
58          </TableAdapter>
59        </Tables>
60        <Sources>
61        </Sources>
62      </DataSource>
63    </xs:appinfo>
64  </xs:annotation>
65  <xs:element name="new" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="new" msprop:Generator_DataSetName="_new">
66    <xs:complexType>
67      <xs:choice minOccurs="0" maxOccurs="unbounded">
68        <xs:element name="newNRB" msprop:Generator_UserTableName="newNRB" msprop:Generator_RowDeletedName="newNRBRowDeleted" msprop:Generator_RowChangedName="newNRBRowChanged" msprop:Generator_RowClassName="newNRBRow" msprop:Generator_RowChangingName="newNRBRowChanging" msprop:Generator_RowEvArgName="newNRBRowChangeEvent" msprop:Generator_RowEvHandlerName="newNRBRowChangeEventHandler" msprop:Generator_TableClassName="newNRBDataTable" msprop:Generator_TableVarName="tablenewNRB" msprop:Generator_RowDeletingName="newNRBRowDeleting" msprop:Generator_TablePropName="newNRB">
69          <xs:complexType>
70            <xs:sequence>
71              <xs:element name="biaoti" msprop:Generator_UserColumnName="biaoti" msprop:Generator_ColumnPropNameInRow="biaoti" msprop:Generator_ColumnVarNameInTable="columnbiaoti" msprop:Generator_ColumnPropNameInTable="biaotiColumn">
72                <xs:simpleType>
73                  <xs:restriction base="xs:string">
74                    <xs:maxLength value="30" />
75                  </xs:restriction>
76                </xs:simpleType>
77              </xs:element>
78              <xs:element name="shijian" msprop:Generator_UserColumnName="shijian" msprop:Generator_ColumnPropNameInRow="shijian" msprop:Generator_ColumnVarNameInTable="columnshijian" msprop:Generator_ColumnPropNameInTable="shijianColumn" type="xs:dateTime" />
79              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" />
80            </xs:sequence>
81          </xs:complexType>
82        </xs:element>
83      </xs:choice>
84    </xs:complexType>
85    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
86      <xs:selector xpath=".//mstns:newNRB" />
87      <xs:field xpath="mstns:id" />
88    </xs:unique>
89  </xs:element>
90</xs:schema>