注册 登录
编程论坛 ASP.NET技术论坛

急!请大家帮帮忙!

jidanney 发布于 2008-04-26 10:47, 781 次点击
原程序:
 if (!this.IsPostBack)
        {
            SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
            strcon.Open();
            SqlDataAdapter sda = new SqlDataAdapter("select * from delivery where user_id=" + Request.QueryString["user_id"], strcon);
            DataSet ds = new DataSet();
            sda.Fill(ds, "delivery");
            DataRowView rowview = ds.Tables["delivery"].DefaultView[0];
            Label1.Text = rowview["documents"].ToString();
            Label2.Text = rowview["documents_name"].ToString();

            ds.Clear();
            strcon.Close();
        }
错误提示:‘=’号附近有错误
这是怎么回事啊?
4 回复
#2
梦心2008-04-26 10:48
SqlDataAdapter sda = new SqlDataAdapter("select * from delivery where user_id='" + Request.QueryString["user_id"]+"'", strcon);

这样写才对!!!!!
#3
jidanney2008-04-26 10:50
谢谢了,我去看看行不行!
#4
jidanney2008-04-26 10:57
上面的问题是可以解决了,又出现了新问题了
提示是这里的问题:
DataRowView rowview = ds.Tables["delivery"].DefaultView[0];
提示内容:
索引 0 不是为负数,就是大于行数。
#5
梦心2008-04-26 11:18
if (ds.Tables["delivery"].Rows.Count > 0)
{
 //先判断下有没有行
//相应代码...
}
1