关于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