gridview 动态绑定sqldatasource sqldatasource带参数，如何在gridview更改数据源是传递参数

Eureal 2012-04-17 03:43:50

此处定义两个数据源：第二个带参数
<asp:SqlDataSource ID="NEWSDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:NEWSConnectionString %>"
InsertCommand="INSERT INTO [FIRSTLEVELTITLE] ([TITLE], [AUTHOR], [CREATETIME]) VALUES (@TITLE, @AUTHOR, @CREATETIME)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT * FROM [FIRSTLEVELTITLE]"
DeleteCommand="DELETE FROM [FIRSTLEVELTITLE] WHERE [ID] = @original_ID"
UpdateCommand="UPDATE [FIRSTLEVELTITLE] SET [TITLE] = @TITLE, [AUTHOR] = @AUTHOR, [CREATETIME] = @CREATETIME WHERE [ID] = @original_ID">
<DeleteParameters>
<asp:Parameter Name="original_ID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="TITLE" Type="String" />
<asp:Parameter Name="AUTHOR" Type="String" />
<asp:Parameter Name="CREATETIME" Type="DateTime" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="TITLE" Type="String" />
<asp:Parameter Name="AUTHOR" Type="String" />
<asp:Parameter Name="CREATETIME" Type="DateTime" />
<asp:Parameter Name="original_ID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:NEWSConnectionString %>"
DeleteCommand="DELETE FROM [FIRSTLEVELTITLE] WHERE [ID] = @ID"
InsertCommand="INSERT INTO [FIRSTLEVELTITLE] ([TITLE], [AUTHOR], [CREATETIME]) VALUES (@TITLE, @AUTHOR, @CREATETIME)"
SelectCommand="SELECT * FROM [FIRSTLEVELTITLE] WHERE ([TITLE] LIKE '%' + @TITLE2 + '%')"
UpdateCommand="UPDATE [FIRSTLEVELTITLE] SET [TITLE] = @TITLE, [AUTHOR] = @AUTHOR, [CREATETIME] = @CREATETIME WHERE [ID] = @ID">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="TITLE" Type="String" />
<asp:Parameter Name="AUTHOR" Type="String" />
<asp:Parameter Name="CREATETIME" Type="DateTime" />
</InsertParameters>
<SelectParameters>
<asp:Parameter Name="TITLE2" Type="String" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="TITLE" Type="String" />
<asp:Parameter Name="AUTHOR" Type="String" />
<asp:Parameter Name="CREATETIME" Type="DateTime" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
页面加载时：
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridView1.DataSourceID = "NEWSDataSource";
GridView1.DataBind();
}
}

点击搜索按钮时执行：
SqlDataSource1.SelectParameters.Add("TITLE2",keyword.Text.Trim());
GridView1.DataSourceID = "SqlDataSource1";
GridView1.DataBind();
结果搜索不到任何结果，也没提示报错，怎么回事啊？初学。net 求点解啊，这可是明天就要交的作业啊

...全文