dataset2.xsd

能实现新闻的添加,删除,更新,对于初学者来说是个很好上手的例子,希望大家能从这个例子中学到东西

SET              USERNAME = @USERNAME, USERPASSWORD = @USERPASSWORD
WHERE     (USERID = @Original_USERID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="USERNAME" ColumnName="USERNAME" DataSourceName="news_manage.dbo.t_News_User" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@USERNAME" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="USERNAME" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="USERPASSWORD" ColumnName="USERPASSWORD" DataSourceName="news_manage.dbo.t_News_User" DataTypeServer="varchar(16)" DbType="AnsiString" Direction="Input" ParameterName="@USERPASSWORD" Precision="0" ProviderType="VarChar" Scale="0" Size="16" SourceColumn="USERPASSWORD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Original_USERID" ColumnName="USERID" DataSourceName="news_manage.dbo.t_News_User" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_USERID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="USERID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="t_NewsTableAdapter" Name="t_News">
            <MainSource>
              <DbSource ConnectionRef="news_manageConnectionString (Web.config)" DbObjectName="news_manage.dbo.t_News" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [t_News] WHERE (([NEWSID] = @Original_NEWSID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NEWSID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NEWSID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [t_News] ([NEWSTITLE], [NEWSTITLE], [CLASSID], [NEWSDATE], [NEWSKEY], [NEWSOURCE], [NEWSCONTENT], [USERID], [HITS], [MONTHHITS]) VALUES (@Expr1, @NEWSTITLE, @CLASSID, @NEWSDATE, @NEWSKEY, @NEWSOURCE, @NEWSCONTENT, @USERID, @HITS, @MONTHHITS)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Expr1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Expr1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NEWSTITLE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NEWSTITLE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CLASSID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CLASSID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NEWSDATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NEWSDATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NEWSKEY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NEWSKEY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NEWSOURCE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NEWSOURCE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NEWSCONTENT" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="NEWSCONTENT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@USERID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="USERID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HITS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HITS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MONTHHITS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MONTHHITS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     NEWSTITLE AS Expr1, NEWSID, NEWSTITLE, CLASSID, NEWSDATE, NEWSKEY, NEWSOURCE, NEWSCONTENT, USERID, HITS, MONTHHITS
FROM         t_News</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [t_News] SET [NEWSTITLE] = @Expr1, [NEWSTITLE] = @NEWSTITLE, [CLASSID] = @CLASSID, [NEWSDATE] = @NEWSDATE, [NEWSKEY] = @NEWSKEY, [NEWSOURCE] = @NEWSOURCE, [NEWSCONTENT] = @NEWSCONTENT, [USERID] = @USERID, [HITS] = @HITS, [MONTHHITS] = @MONTHHITS WHERE (([NEWSID] = @Original_NEWSID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Expr1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Expr1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NEWSTITLE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NEWSTITLE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CLASSID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CLASSID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NEWSDATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NEWSDATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NEWSKEY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NEWSKEY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NEWSOURCE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NEWSOURCE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NEWSCONTENT" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="NEWSCONTENT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@USERID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="USERID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HITS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HITS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MONTHHITS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MONTHHITS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NEWSID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NEWSID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
              <Mapping SourceColumn="NEWSID" DataSetColumn="NEWSID" />
              <Mapping SourceColumn="NEWSTITLE" DataSetColumn="NEWSTITLE" />
              <Mapping SourceColumn="CLASSID" DataSetColumn="CLASSID" />
              <Mapping SourceColumn="NEWSDATE" DataSetColumn="NEWSDATE" />
              <Mapping SourceColumn="NEWSKEY" DataSetColumn="NEWSKEY" />
              <Mapping SourceColumn="NEWSOURCE" DataSetColumn="NEWSOURCE" />
              <Mapping SourceColumn="NEWSCONTENT" DataSetColumn="NEWSCONTENT" />
              <Mapping SourceColumn="USERID" DataSetColumn="USERID" />
              <Mapping SourceColumn="HITS" DataSetColumn="HITS" />
              <Mapping SourceColumn="MONTHHITS" DataSetColumn="MONTHHITS" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="news_manageConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" Modifier="Public" Name="insertnews1" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>INSERT INTO t_News
                      (NEWSTITLE, CLASSID, NEWSDATE, NEWSKEY, NEWSOURCE, NEWSCONTENT, USERID)
VALUES     (@NEWSTITLE,@CLASSID,@NEWSDATE,@NEWSKEY,@NEWSOURCE,@NEWSCONTENT,@USERID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="NEWSTITLE" ColumnName="NEWSTITLE" DataSourceName="news_manage.dbo.t_News" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@NEWSTITLE" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="NEWSTITLE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="CLASSID" ColumnName="CLASSID" DataSourceName="news_manage.dbo.t_News" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CLASSID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CLASSID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="NEWSDATE" ColumnName="NEWSDATE" DataSourceName="news_manage.dbo.t_News" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@NEWSDATE" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="NEWSDATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="NEWSKEY" ColumnName="NEWSKEY" DataSourceName="news_manage.dbo.t_News" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@NEWSKEY" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="NEWSKEY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="NEWSOURCE" ColumnName="NEWSOURCE" DataSourceName="news_manage.dbo.t_News" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@NEWSOURCE" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="NEWSOURCE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="NEWSCONTENT" ColumnName="NEWSCONTENT" DataSourceName="news_manage.dbo.t_News" DataTypeServer="ntext" DbType="String" Direction="Input" ParameterName="@NEWSCONTENT" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="NEWSCONTENT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="USERID" ColumnName="USERID" DataSourceName="news_manage.dbo.t_News" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@USERID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="USERID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>