Gridview中select命令应该如何写

[caoyang0299]

用gridview控件自动生成insert，update等按钮
生成如下代码
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:SQLConnString1 %>"
SelectCommand="SELECT [ItemId], [ItemName], [AliPrice], [ListPrice], [UnitCost], [IsRecommendByCategory], [IsHotSaleByCategory], [IsNewProductByCategory], [IsTopList], [IsNewProduct], [IsHotSale], [IsRecommend], [IsTopListByCategory] FROM [Item] "
DeleteCommand="DELETE FROM [Item] WHERE [ItemId] = @ItemId"
InsertCommand="INSERT INTO [Item] ([ItemId], [ItemName], [AliPrice], [ListPrice], [UnitCost], [IsRecommendByCategory], [IsHotSaleByCategory], [IsNewProductByCategory], [IsTopList], [IsNewProduct], [IsHotSale], [IsRecommend], [IsTopListByCategory]) VALUES (@ItemId, @ItemName, @AliPrice, @ListPrice, @UnitCost, @IsRecommendByCategory, @IsHotSaleByCategory, @IsNewProductByCategory, @IsTopList, @IsNewProduct, @IsHotSale, @IsRecommend, @IsTopListByCategory)"
UpdateCommand="UPDATE [Item] SET [ItemName] = @ItemName, [AliPrice] = @AliPrice, [ListPrice] = @ListPrice, [UnitCost] = @UnitCost, [IsRecommendByCategory] = @IsRecommendByCategory, [IsHotSaleByCategory] = @IsHotSaleByCategory, [IsNewProductByCategory] = @IsNewProductByCategory, [IsTopList] = @IsTopList, [IsNewProduct] = @IsNewProduct, [IsHotSale] = @IsHotSale, [IsRecommend] = @IsRecommend, [IsTopListByCategory] = @IsTopListByCategory WHERE [ItemId] = @ItemId">

现在我想修改其中的select command，
实现下面功能，应该怎么写，谢谢！
if (DropDownList1.SelectedValue != "ALL")
{
sql = "SELECT [ItemId], [ItemName], [AliPrice], [ListPrice], [UnitCost], [IsRecommendByCategory], [IsHotSaleByCategory], [IsNewProductByCategory], [IsTopList], [IsNewProduct], [IsHotSale], [IsRecommend], [IsTopListByCategory] FROM [Item]";
sql = sql + " Where CHARINDEX('" + DropDownList1.SelectedItem.Value + "', ProductId)<>0 ORDER BY [ItemId]";
}
else
{
sql = "SELECT [ItemId], [ItemName], [AliPrice], [ListPrice], [UnitCost], [IsRecommendByCategory], [IsHotSaleByCategory], [IsNewProductByCategory], [IsTopList], [IsNewProduct], [IsHotSale], [IsRecommend], [IsTopListByCategory] FROM [Item]";
}
SqlDataSource1.SelectCommand = sql;

[whoami333]

这种方式你不应该事先绑定数据源。在代码页中通过编程方式实现。

[happyjie]

支持楼上的,把代码写在.cs的文件中.