(1)private const string Sql_Select_Tasks = " declare @taskId int ;select * from task where taskId=@taskId;";(这个不能显示列表)
这个是根据参数显示响应的列表,你没有输入参数当然不会显示啦
把它改成(2)private const string Sql_Select_Tasks = "select * from task";不就可以啦,难道不想改?还是有别的目的?
这个是根据参数显示响应的列表,你没有输入参数当然不会显示啦
把它改成(2)private const string Sql_Select_Tasks = "select * from task";不就可以啦,难道不想改?还是有别的目的?
(2)private const string Sql_Select_Tasks = "select * from task";是我作的测试一个简单的例子。现在如果我想用(1)为什么不能显示啊
现在我想显示列表怎么才能显示啊
改为private const string Sql_Select_Tasks = " declare @taskId int ;select * from task where taskId=@taskId and taskId=9
这个也不行啊。我试过的
我想显示项目列表:可是数据库的操作是
private const string Sql_Select_Task_By_Cate="declare @category nvarchar(100); select * from task where cateId=@category order by taskId desc ";(这个不能显示列表)
现在我想显示项目列表怎么办啊?下面是具体的实现代码
ASPX。CS页面
public static void DataBind()
{
string taskKey=Request.QueryString["taskId"]; Task task = new Task();
taskList.DataSource = task.GetTaskByCategory(taskKey);
taskList.DataBind();
}下面是数据库操作的代码 public IList<TaskInfo> GetTaskByCategory(string category)
{
IList<TaskInfo> TaskByCate = new List<TaskInfo>();
SqlParameter para = new SqlParameter("@category",SqlDbType.NChar,100);
para.Value = category; using (SqlDataReader sdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringocalTransaction, CommandType.Text, Sql_Select_Task_By_Cate, para)) {
while (sdr.Read())
{
TaskInfo taskByCate = new TaskInfo(sdr.GetInt32(0), sdr.GetString(1), sdr.GetString(2), sdr.GetString(3), sdr.GetString(4), sdr.GetDecimal(5), sdr.GetDateTime(6), sdr.GetDateTime(7));
TaskByCate.Add(taskByCate);
} } return TaskByCate;
}
private const string Sql_Select_Task_By_Cate="declare @category nvarchar(100); select * from task where cateId=@category order by taskId desc ";