| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 595 人关注过本帖
标题:请高手帮我下,谢谢,我找不到这个报错的地方
取消只看楼主 加入收藏
hans998123
Rank: 2
等 级:论坛游民
帖 子:20
专家分:14
注 册:2011-7-10
结帖率:0
收藏
 问题点数:0 回复次数:0 
请高手帮我下,谢谢,我找不到这个报错的地方
高手帮我看看代码,我找不到报错的原因 ... 我用的SqlHelper 然后做一个 更新操作
private void btnModfiy_Click(object sender, EventArgs e)
        {
            string name = txtUserName.Text.Trim();
            string phone = txtPhone.Text.Trim();
            string mail = txtMail.Text.Trim();
            string school = txtSchool.Text.Trim();
            string address = txtAddress.Text.Trim();
            SqlParameter[] sp =
            {
                new SqlParameter("@username",(object)name),
                new SqlParameter("@phone",(object)phone),
                new SqlParameter("@mail",(object)mail),
                new SqlParameter("@school",(object)school),
                new SqlParameter("@address",(object)address)
            };
            string sql = "update T_Student set  stuName,stuPhone,stuEmail,stuAddress,stuSchool where stuName=@username and stuPhone=@phone and stuEmail=@mail and stuAddress=@address and stuSchool=@school";
            SqlHelper.SqlHelper.ExecuteNonQuery(sql,sp);
            MessageBox.Show("修改成功");
        }
以上都没报错
 public  static int ExecuteNonQuery(string sql, params SqlParameter[] parameters)
        {
            
            using (SqlConnection conn = new SqlConnection(con))
            {
                if(conn.State == System.Data.ConnectionState.Closed)
                {
                    conn.Open();
                }
                using (SqlCommand cmd = conn.CreateCommand())
                {
                     = sql;
                    if (parameters != null && parameters.Length > 0)
                    {
                        cmd.Parameters.AddRange(parameters);
                    }
                    return cmd.ExecuteNonQuery();//这行报错了 。....  说 ',' 附近有语法错误 ....  我找不到啊 不知道怎么错了  高手帮我看下 谢谢
                }
            }
搜索更多相关主题的帖子: school private address void 
2012-08-15 23:49
快速回复:请高手帮我下,谢谢,我找不到这个报错的地方
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.012109 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved