问题描述
此处定义两个数据源:第二个带参数<asp:SqlDataSourceID="NEWSDataSource"runat="server"ConnectionString="<%$ConnectionStrings:NEWSConnectionString%>"InsertCommand="INSERTINTO[FIRSTLEVELTITLE]([TITLE],[AUTHOR],[CREATETIME])VALUES(@TITLE,@AUTHOR,@CREATETIME)"OldValuesParameterFormatString="original_{0}"SelectCommand="SELECT*FROM[FIRSTLEVELTITLE]"DeleteCommand="DELETEFROM[FIRSTLEVELTITLE]WHERE[ID]=@original_ID"UpdateCommand="UPDATE[FIRSTLEVELTITLE]SET[TITLE]=@TITLE,[AUTHOR]=@AUTHOR,[CREATETIME]=@CREATETIMEWHERE[ID]=@original_ID"><DeleteParameters><asp:ParameterName="original_ID"Type="Int32"/></DeleteParameters><InsertParameters><asp:ParameterName="TITLE"Type="String"/><asp:ParameterName="AUTHOR"Type="String"/><asp:ParameterName="CREATETIME"Type="DateTime"/></InsertParameters><UpdateParameters><asp:ParameterName="TITLE"Type="String"/><asp:ParameterName="AUTHOR"Type="String"/><asp:ParameterName="CREATETIME"Type="DateTime"/><asp:ParameterName="original_ID"Type="Int32"/></UpdateParameters></asp:SqlDataSource><asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ConnectionStrings:NEWSConnectionString%>"DeleteCommand="DELETEFROM[FIRSTLEVELTITLE]WHERE[ID]=@ID"InsertCommand="INSERTINTO[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]=@CREATETIMEWHERE[ID]=@ID"><DeleteParameters><asp:ParameterName="ID"Type="Int32"/></DeleteParameters><InsertParameters><asp:ParameterName="TITLE"Type="String"/><asp:ParameterName="AUTHOR"Type="String"/><asp:ParameterName="CREATETIME"Type="DateTime"/></InsertParameters><SelectParameters><asp:ParameterName="TITLE2"Type="String"/></SelectParameters><UpdateParameters><asp:ParameterName="TITLE"Type="String"/><asp:ParameterName="AUTHOR"Type="String"/><asp:ParameterName="CREATETIME"Type="DateTime"/><asp:ParameterName="ID"Type="Int32"/></UpdateParameters></asp:SqlDataSource>页面加载时:protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){GridView1.DataSourceID="NEWSDataSource";GridView1.DataBind();}}点击搜索按钮时执行:SqlDataSource1.SelectParameters.Add("TITLE2",keyword.Text.Trim());GridView1.DataSourceID="SqlDataSource1";GridView1.DataBind();结果搜索不到任何结果,也没提示报错,怎么回事啊?初学。net求点解啊,这可是明天就要交的作业啊
解决方案
解决方案二:
是SqlDataSource1.SelectParameters.Add("@TITLE2",keyword.Text.Trim());
解决方案三:
不如手写--这种方式我真的很少见到直接指定数据源--
解决方案四:
引用2楼的回复:
不如手写--这种方式我真的很少见到直接指定数据源--
我以前也是直接指定的不过真心看不懂现在也一样