string sql1 = "select MemberName,YHKahao,YHKaMima from tb_Chongqian where MemberName='" + Session["MName"].ToString() + "'";
sqlconn.Open();
SqlDataAdapter myda = new SqlDataAdapter(sql1, sqlconn);
DataSet myds = new DataSet();
myda.Fill(myds, "tb_Chongqian");
DataRowView mydrv = myds.Tables["tb_Chongqian"].DefaultView[0]; -------这儿报错:索引0不是为负数,就是大于行数!
string KaHao = Convert.ToString(mydrv.Row["YHKahao"]);
string MiMa = Convert.ToString(mydrv.Row["YHKaMima"]);
if (Convert.ToInt32(KaHao) == 0 && Convert.ToInt32(MiMa) == 0)
{
string sql = "update tb_Chongqian set YHKahao='"
+ TextBox1.Text + "' where MemberName='" + Session["MName"].ToString() + "'";
sqloperate.DataCom(sql);
string sqlstr1 = "update tb_Chongqian set YHKaMima='"
+ TextBox2.Text + "' where MemberName='" + Session["MName"].ToString() + "'";
sqloperate.DataCom(sqlstr1); }错误见上,我就是想利用从数据库中查出的字段和文本框中的字段比较!但是报上面的错误!那为大姐大哥帮忙看一下小弟急用!
sqlconn.Open();
SqlDataAdapter myda = new SqlDataAdapter(sql1, sqlconn);
DataSet myds = new DataSet();
myda.Fill(myds, "tb_Chongqian");
DataRowView mydrv = myds.Tables["tb_Chongqian"].DefaultView[0]; -------这儿报错:索引0不是为负数,就是大于行数!
string KaHao = Convert.ToString(mydrv.Row["YHKahao"]);
string MiMa = Convert.ToString(mydrv.Row["YHKaMima"]);
if (Convert.ToInt32(KaHao) == 0 && Convert.ToInt32(MiMa) == 0)
{
string sql = "update tb_Chongqian set YHKahao='"
+ TextBox1.Text + "' where MemberName='" + Session["MName"].ToString() + "'";
sqloperate.DataCom(sql);
string sqlstr1 = "update tb_Chongqian set YHKaMima='"
+ TextBox2.Text + "' where MemberName='" + Session["MName"].ToString() + "'";
sqloperate.DataCom(sqlstr1); }错误见上,我就是想利用从数据库中查出的字段和文本框中的字段比较!但是报上面的错误!那为大姐大哥帮忙看一下小弟急用!
在数据库里面 能不能 查出 记录
用查询分析器 试试