向数据库添加数据的问题~~~~~大神速来~

Question

                    SqlCommand selectcmd1 = new SqlCommand();
                    selectcmd1.CommandText = "select logincount,UserName from Role";
                    selectcmd1.Connection = con;
                    SqlCommand edit = new SqlCommand();
                    
          edit.CommandText = "updata Role set logincount=@logincount where UserName='"+Login1.UserName + "' ";
                    edit.Connection = con;
                    da.SelectCommand = selectcmd1;
                    da.Fill(ds1, "Role");
                    //DataRow row = ds1.Tables["Role"].Rows[0];
                    //Session["name"] = row[0];
                    edit.Parameters.Add("@logincount", SqlDbType.Int, 4, "logincount");                    da.UpdateCommand = edit;
                    DataRow editdr = null;
                    foreach (DataRow dr1 in ds1.Tables["Role"].Rows)
                    {
                        if (dr1[1].ToString() == Login1.UserName)
                        {
                            editdr = dr1;
                            break;
                        }
                    }
                  
                    editdr["logincount"] = int.Parse(editdr["logincount"].ToString()) + 1;
                    //Session["name"]=editdr["logincount"];
                    da.Update(ds1, "Role");
                    con.Close();
                    Login1.DestinationPageUrl = "~/Main.aspx";此段为向数据库修改登录者登录次数 logincount 代码但数据库死都不让我修改logincount字段 并且还不报错求大神给力~！！！！！！！！！！！！！

Answer 1

updata Role 中ROLE会不会是保留关键字？

Answer 2

你好像没有给edit.Parameters的 logincount参数赋值edit.Parameters.Add("@logincount", SqlDbType.Int, 4, "logincount").Value = xxxx;

Answer 3

可以写成：updata Role set logincount=logincount + 1 where ....
出错可能是logincount超出了范围，我猜的。

Answer 4

把SQL语句放到数据库中执行以下试试，是不是语句出问题了？

Answer 5

@logincount 的值我怎么没有看到？

Answer 6

语句没错。就是赋值增加的值搞错了 。@logincount 跟logincount 

Answer 7

好像不是
我用Session测试了  Role表里面有值  

Answer 8

Vlaue 应该是填什么？？？

Answer 9

Value 是你要更新的logincount值

Answer 10

           SqlCommand selectcmd1 = new SqlCommand();
                    selectcmd1.CommandText = "select logincount,UserName from Role";
                    selectcmd1.Connection = con;
                    SqlCommand edit = new SqlCommand();
                    edit.CommandText = "updata Role set logincount=@logincount where UserName=@UserName ";
                    edit.Connection = con;
                    da.SelectCommand = selectcmd1;
                    da.Fill(ds1, "Role");
                    //DataRow row = ds1.Tables["Role"].Rows[0];
                    //Session["name"] = row[0];
                    DataRow editdr = null;
                    foreach (DataRow dr1 in ds1.Tables["Role"].Rows)
                    {
                        if (dr1[1].ToString() == Login1.UserName)
                        {
                            editdr = dr1;
                            break;
                        }
                    }
                    editdr["logincount"] = int.Parse(editdr["logincount"].ToString()) + 1;
                    SqlParameter sp = new SqlParameter("@logincount", SqlDbType.Int, 4);
                    SqlParameter sp1 = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
                    sp.Value = editdr["logincount"].ToString();
                    sp1.Value = Login1.UserName;
                    edit.Parameters.Add(sp);
                    edit.Parameters.Add(sp1);
                    da.UpdateCommand = edit;                    //edit.Parameters.Add("@logincount", SqlDbType.Int, 4, "logincount").Value=editdr["logincount"];//Session["name"]=editdr["logincount"];
                    da.Update(ds1, "Role");
                    con.Close();
                    Login1.DestinationPageUrl = "~/Main.aspx";修改以后的代码  da.Update(ds1, "Role");被注释以后可以跳转到Main页如果不注释 da.Update(ds1, "Role");
页面不跳转   数据库不添加数据 而且还不报错

Answer 11

重新设过值后 问题依旧  我改过之后的代码 SqlCommand selectcmd1 = new SqlCommand();
                    selectcmd1.CommandText = "select logincount,UserName from Role";
                    selectcmd1.Connection = con;
                    SqlCommand edit = new SqlCommand();
                    edit.CommandText = "updata Role set logincount=@logincount where UserName=@UserName ";
                    edit.Connection = con;
                    da.SelectCommand = selectcmd1;
                    da.Fill(ds1, "Role");
                    //DataRow row = ds1.Tables["Role"].Rows[0];
                    //Session["name"] = row[0];
                    DataRow editdr = null;
                    foreach (DataRow dr1 in ds1.Tables["Role"].Rows)
                    {
                        if (dr1[1].ToString() == Login1.UserName)
                        {
                            editdr = dr1;
                            break;
                        }
                    }
                    editdr["logincount"] = int.Parse(editdr["logincount"].ToString()) + 1;
                    SqlParameter sp = new SqlParameter("@logincount", SqlDbType.Int, 4);
                    SqlParameter sp1 = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
                    sp.Value = editdr["logincount"].ToString();
                    sp1.Value = Login1.UserName;
                    edit.Parameters.Add(sp);
                    edit.Parameters.Add(sp1);
                    da.UpdateCommand = edit;                    //edit.Parameters.Add("@logincount", SqlDbType.Int, 4, "logincount").Value=editdr["logincount"];//Session["name"]=editdr["logincount"];
                    da.Update(ds1, "Role");
                    con.Close();
                    Login1.DestinationPageUrl = "~/Main.aspx";

Answer 12

  edit.Parameters.AddWidthValue("@logincount","它的值");

Answer 13

 SqlCommand selectcmd1 = new SqlCommand();
                    selectcmd1.CommandText = "select logincount,UserName from Role";
                    selectcmd1.Connection = con;
                    SqlCommand edit = new SqlCommand();
                    edit.CommandText = "updata Role set logincount=@logincount where UserName=@UserName ";
                    edit.Connection = con;
                    da.SelectCommand = selectcmd1;
                    da.Fill(ds1, "Role");
                    //DataRow row = ds1.Tables["Role"].Rows[0];
                    //Session["name"] = row[0];
                    DataRow editdr = null;
                    foreach (DataRow dr1 in ds1.Tables["Role"].Rows)
                    {
                        if (dr1[1].ToString() == Login1.UserName)
                        {
                            editdr = dr1;
                            break;
                        }
                    }
                    editdr["logincount"] = int.Parse(editdr["logincount"].ToString()) + 1;
                    edit.Parameters.AddWithValue("@logincount", int.Parse(editdr["logincount"].ToString()));
                    edit.Parameters.AddWithValue("@UserName",Login1.UserName.ToString());
                    //SqlParameter sp = new SqlParameter("@logincount", SqlDbType.Int, 4);
                    //SqlParameter sp1 = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
                    //sp.Value = int.Parse(editdr["logincount"].ToString());
                    //sp1.Value = Login1.UserName;
                    //edit.Parameters.Add(sp);
                    //edit.Parameters.Add(sp1);
                    da.UpdateCommand = edit;
                    //edit.Parameters.Add("@logincount", SqlDbType.Int, 4, "logincount").Value=editdr["logincount"];//Session["name"]=editdr["logincount"];
                    da.Update(ds1, "Role");
                    con.Close();
                    Login1.DestinationPageUrl = "~/Main.aspx";还是不行数据没加进去 

Answer 14

var cmd=new SqlCommand("updata Role set logincount=logincount+1 where UserName=@UserName",con );
cmd.Parameters.AddWithValue("@UserName",Login1.UserName.ToString());
con.Open();
cmd.ExecuteNonQuery()
con.Close();