日期:2014-05-18  浏览次数:20442 次

关于sqldatasource的问题
<asp:SqlDataSource   ID= "SqlDataSource2 "   runat= "server "     DataSourceMode=DataSet  
                   
                    ConnectionString= " <%$   ConnectionStrings:drmConnectionString2   %> "  
                   
                    SelectCommand= "SELECT   [ProgramID],   [IsAvailable],   [ProgramTitle],   [ProgramRemark],   [ProgramContent],   [MovieCount],   [WholesalePoint],   [PromotionPoint],   [ContentProvider]   FROM   [ProgramData] "
                 
                    DeleteCommand= "DELETE   FROM   [ProgramData]   WHERE   [ProgramID]   =@ProgramID "  
                   
                    InsertCommand= "INSERT   INTO   ProgramData(ProgramTitle,   IsAvailable,   MovieCount,   WholesalePoint,   PromotionPoint,   ContentProvider,ProgramRemark,ProgramContent)   VALUES   (@ProgramTitle,   @IsAvailable,@MovieCount,   @WholesalePoint,   @PromotionPoint,   @ContentProvider,@ProgramRemark,@ProgramContent) "
                       
                    UpdateCommand= "UPDATE   [ProgramData]   SET   [ProgramTitle]   =   @ProgramTitle,   [IsAvailable]   =   @IsAvailable,   [MovieCount]   =   @MovieCount,   [WholesalePoint]   =   @WholesalePoint,   [PromotionPoint]   =   @PromotionPoint,   [ContentProvider]   =   @ContentProvider,   [ProgramRemark]   =   @ProgramRemark,   [ProgramContent]   =   @ProgramContent   WHERE   [ProgramID]   =   @ProgramID "
                       
                    ConflictDetection= "CompareAllValues "   >
                           
                            <DeleteParameters>
                                  <asp:Parameter   Name= "ProgramID "   Type=Int32   />
                            </DeleteParameters>
                            <InsertParameters>
                                  <asp:FormParameter   Name= "ProgramTitle "   FormField= "ProgramTitle "   />
                                  <asp:FormParameter   Name= &q