调用存储过程出错！大哥大姐们来看看

[xuming120]

DBUtility

    public int ExecuteNonQuery(string query, params SqlParameter[] parameters)
        {
            cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
            SqlCommand cmd = new SqlCommand(query, cnn);
            if (query.StartsWith("INSERT") | query.StartsWith("insert") | query.StartsWith("UPDATE") | query.StartsWith("update") | query.StartsWith("DELETE") | query.StartsWith("delete"))
            {
                cmd.CommandType = CommandType.Text;
            }
            else
            {
                cmd.CommandType = CommandType.StoredProcedure;
            }
            for (int[code=SQL]

i = 0; i <= parameters.Length - 1; i++)
{
cmd.Parameters.Add(parameters[i]);
}
cnn.Open();
int retval = cmd.ExecuteNonQuery();
cnn.Close();
return retval;
}
[/code]

存储过程

ALTER PROCEDURE dbo.insertUsers
	 @uname varchar(50),
	 @upwd varchar(50)
AS

insert into users(uname,upwd) values(@uname,@upwd)

调用

 public int insertUsers(string uname,string upwd) {
        DBconn con = new DBconn();
        SqlParameter[] objParams = new SqlParameter[2];
        objParams[0] = new SqlParameter("@uname",uname);
        objParams[1] = new SqlParameter("@upwd", upwd);
        int i = con.ExecuteNonQuery("insertUsers",objParams);
            return i;
    }

报错信息: 'insertUsers' 附近有语法错误。
大侠们帮忙看看.刚学调用存储过程.

[flyerwing]

没什么看地。

[wuyq11]

public static int ExecuteCommand(string sql, params SqlParameter[] values)
{
SqlCommand cmd = new SqlCommand(sql, Connection);
cmd.Parameters.AddRange(values);
return cmd.ExecuteNonQuery();
}

[freemeditator]

public static int ExecuteCommand(string sql, params SqlParameter[] values) 
        { 
            SqlCommand cmd = new SqlCommand(sql, Connection); 
            cmd.Parameters.AddRange(values); 
            return cmd.ExecuteNonQuery(); 
        }

[gaozhigang]

 using (SqlConnection conn = new SqlConnection(Utility.GetAppSetting("DBManageConnectString")))
                {
                    conn.Open();
                    SqlCommand cmd = new SqlCommand("DelIPAddress", conn);
                    cmd.CommandType = CommandType.StoredProcedure;
                    SqlParameter para_IPID = new SqlParameter("@IPID", Convert.ToInt32(IPID));
                    SqlParameter para_Flag = new SqlParameter("@flag", SqlDbType.Int);
                    para_Flag.Direction = ParameterDirection.Output;
                    cmd.Parameters.Add(para_IPID);
                    cmd.Parameters.Add(para_Flag);
                    cmd.ExecuteNonQuery();
                    if (para_Flag.Value == (object)0)
                    {
                        ret = false;
                    }
                }

[xuming120]

我那么些 为什么会报错? 帮忙看看哪有问题?

[qpzmxncb]

我认为是没有执行cmd.CommandType = CommandType.StoredProcedure
你设置个断点看看吧

[xuming120]

顶上去。。

[mqc507]

query.StartsWith("insert")
导致执行的是CommandType.Text而不是procedure

[mqc507]

因为你的存储过程名字insertUsers就是以insert开头的·

[mqc507]

修改下你的DBUtility

public static int ExecuteNonQuery(string cmdText, params SqlParameter[] cmdParams)
        {
            cmdText = cmdText.Trim();

            if (cmdText.IndexOf(' ') > 0)
                return ExecuteNonQuery(CommandType.Text, cmdText, cmdParams);
            else
                return ExecuteNonQuery(CommandType.StoredProcedure, cmdText, cmdParams);

        }