C# 调用存储过程 语法错误

[kennie_190602169]

大家好!
代码如下:

public void GetCompany(string companyId)
        {
            SqlParameter[] values = new SqlParameter[]
            {
                new SqlParameter(PARAM_COMPANY_ID, companyId)
            };

            DataTable dtResult = SQLDBUtil.GetDataSetByProcedure(PRO_GET_WATER_HISTORY, values);

        }

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'proTest' AND type = 'P')   
	DROP PROCEDURE proTest 
GO

CREATE PROCEDURE proTest
	@company_Id VARCHAR(2)
AS
BEGIN
	SELECT * FROM Company WHERE company_Id = @company_Id;
END

exec proTest '01';

错误提示: "'proTest' 附近有语法错误。"
首先,这存储过程是可以执行的.但是用C#调用,就报存储过程名字附近有语法错误.另外,如果C#里不传参数,是没问题的.这是什么问题?请大家指教,谢谢!

[wuyq11]

检查SQLDBUtil.GetDataSetByProcedure方法

[龍月]

GetDataSetByProcedure
贴出来啊

[Peter200694013]

是不是由于换行而引起的错误
建议查找一下

[kennie_190602169]

public static DataTable GetDataSetByProcedure(string procedureName, params SqlParameter[] values)
        {
            SqlDataAdapter sda = null;
            DataSet ds = null;
            SqlCommand cmd = null;

            try
            {

                ds = new DataSet();
                cmd = new SqlCommand(procedureName, Con);
                cmd.CommandTimeout = 120;
                cmd.Parameters.AddRange(values);
                sda = new SqlDataAdapter(cmd);
                sda.SelectCommand.CommandTimeout = 120;
                sda.Fill(ds);
                return ds.Tables[0];
            }
            catch (Exception e)
            {
                //Log.AddErr(e);
                return null;
            }
            finally
            {
                if (null != ds)
                {
                    ds.Dispose();
                }
                if (null != sda)
                {
                    sda.Dispose();
                }
                if (null != cmd)
                {
                    cmd.Dispose();
                }
                if (Con.State == ConnectionState.Open)
                {
                    Con.Close();
                }
            }

        }

[kennie_190602169]

[Quote=引用 3 楼 peter200694013 的回复:]
是不是由于换行而引起的错误
建议查找一下
[/Quote]

PROCEDURE里哪里换行有问题?

[wuyq11]

调用其他存储过程是否正确
public static DataTable RunProcedureTable(string storedProcName, IDataParameter[] parameters)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
DataSet dsSet = new DataSet();
SqlDataAdapter sqlDa = new SqlDataAdapter(storedProcName, con);
sqlDa.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDa.SelectCommand.Parameters.AddRange(parameters);
sqlDa.Fill(dsSet);
return dsSet.Tables[0];
}
}

[kennie_190602169]

检查出来了,晕si...低级错误, 少了一句CommandType.StoredProcedure;
哎...做到头晕了!

谢谢几位!