请教高手。帮小弟看看代码那有问题

[yanziyujing]

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

/// <summary>
/// DataBase 的摘要说明
/// </summary>
public class DataBase
{
private static DataBase _instance;
protected DataBase()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static DataBase getInstance()
{
if(_instance==null)
{

_instance = new DataBase();
}
return _instance;
}
public static SqlConnection ReturnConn()
{
string strConn = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
SqlConnection Conn=new SqlConnection(strConn);
if (Conn.State.Equals(ConnectionState.Closed))
{
Conn.Open();
}
return Conn;
}
public static SqlCommand CreatCmd(string procName,SqlParameter[] prams)
{
SqlConnection Conn = ReturnConn();
SqlCommand Cmd = new SqlCommand();
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Connection = Conn;
Cmd.CommandText = procName;
if(prams!=null)
{
foreach (SqlParameter paramenter in prams)
{
if (paramenter != null)
{
Cmd.Parameters.Add(paramenter);

}
}
}
return Cmd;
}
public static SqlCommand CreatCmd(string procName,SqlParameter[] prams, SqlConnection Conn)
{
SqlConnection SqlConn = Conn();
if(SqlConn.State.Equals(ConnectionState.Closed))
{
SqlConn.Open();
}
SqlCommand Cmd = new SqlCommand();
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Connection = SqlConn;
Cmd.CommandText = procName;
if (prams != null)
{
foreach (SqlParameter paramenter in prams)
{
if (paramenter != null)
{
Cmd.Parameters.Add(paramenter);

}
}
}
return Cmd;
}
public static SqlCommand CreatCmd(string procName, SqlCommand Conn)
{
SqlConnection SqlConn = Conn();
if (SqlConn.State.Equals(ConnectionState.Closed))
{
SqlConn.Open();
}
SqlCommand Cmd = new SqlCommand();
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Connection = SqlConn;
Cmd.CommandText = procName;
return Cmd;
}
public static SqlCommand CreatCmd(string procName)
{
SqlConnection SqlConn = ReturnConn();
SqlCommand Cmd = new SqlCommand();
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Connection = SqlConn;
Cmd.CommandText = procName;
return Cmd;

}
public static SqlDataReader RunProcGetReader(string procName,SqlParameter[] prams)
{
SqlCommand Cmd = CreatCmd(procName, prams);
SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
return Dr;

}
public static SqlDataReader RunProcGetReader(string procName, SqlParameter[] prams, SqlConnection Conn)
{
SqlCommand Cmd = CreatCmd(procName, prams,Conn);
SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
return Dr;
}
public static SqlDataReader RunProcGetReader(string procName, SqlConnection Conn)
{
SqlCommand Cmd = CreatCmd(procName,Conn);
SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
return Dr;
}
public static SqlDataReader RunProcGetReader(string procName)
{
SqlCommand Cmd = CreatCmd(procName);
SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
return Dr;
}
public static DataTable RunProcGetTable(string procName, SqlParameter[] prams, SqlConnection Conn)
{
SqlCommand Cmd = CreatCmd(procName, prams,Conn);
SqlDataAdapter Dtr = new SqlDataAdapter();
DataSet Ds = new DataSet();
Dtr.SelectCommand = Cmd;
Dtr.Fill(Ds);
DataTable Dt = Ds.Tables[0];
Conn.Close();
return Dt;
}

}
错误提示为
错误 5 “Conn”是“变量”，但此处被当做“方法”来使用 E:\WebSite1\App_Code\DataBase.cs 65 33 E:\WebSite1\
错误 6 “Conn”是“变量”，但此处被当做“方法”来使用 E:\WebSite1\App_Code\DataBase.cs 89 33 E:\WebSite1\
错误 7 与“DataBase.CreatCmd(string, System.Data.SqlClient.SqlParameter[])”最匹配的重载方法具有一些无效参数 E:\WebSite1\App_Code\DataBase.cs 125 26 E:\WebSite1\
错误 8 参数“2”: 无法从“System.Data.SqlClient.SqlConnection”转换为“System.Data.SqlClient.SqlParameter[]” E:\WebSite1\App_Code\DataBase.cs 125 44 E:\WebSite1\
。。。
怎么解决

[-过客-]

SqlConnection SqlConn = Conn();
-------->
SqlConnection SqlConn = Conn;

[hongqi162]

SqlConnection SqlConn = Conn();//两处的Conn()的括号去掉

[amandag]

SqlConnection SqlConn = Conn();
===============================
SqlConnection SqlConn = ReturnConn();

[小y的CSDN博客]

SqlConnection SqlConn = Conn();
改成SqlConnection SqlConn = Conn;

[shilei831115]

SqlConnection SqlConn = Conn();


改为：SqlConnection SqlConn = ReturnConn();


下面两个 好像是你调用的时候 参数没有写正确吧？

你可能写的是：CreatCmd(string procName,SqlParameter[] prams)；可是 里面根本没有你要的函数，你好好看看，确实没有你调用的那个函数

[yanziyujing]

把括号去掉第一个可以。去掉第二个。。就有问题了

[-过客-]

把你的错误行标示出来吧，难道还让大家去数哪个是33行，哪个是125行吗

[yanziyujing]

SqlCommand Cmd = CreatCmd(procName,Conn);这是第三处错误

[-过客-]

第87行
public static SqlCommand CreatCmd(string procName, SqlCommand Conn)
---------->
public static SqlCommand CreatCmd(string procName, SqlConnection Conn)

[shilei831115]

public static SqlCommand CreatCmd(string procName, SqlCommand Conn)
{
SqlConnection SqlConn = Conn();
if (SqlConn.State.Equals(ConnectionState.Closed))
{
SqlConn.Open();
}
SqlCommand Cmd = new SqlCommand();
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Connection = SqlConn;
Cmd.CommandText = procName;
return Cmd;
}


函数写错了 参数应该是public static SqlCommand CreatCmd(string procName, SqlConnection conn)

[-过客-]

-_-#，不知道在你那里是不是第87行，就是CreatCmd两个参数重载的那个，参数类型错了

[yanziyujing]

第一个错误。和大家说的那样、去掉一个括号解决。但第二个的括号在去掉。就有。问题。我把他改为
SqlConnection SqlConn = Conn();
===============================
SqlConnection SqlConn = ReturnConn();
问题也解决。为什么。不懂。第三处和第四处。为解决。错在同一行～

[yanziyujing]

public static SqlDataReader RunProcGetReader(string procName,SqlParameter[] prams)
{
SqlCommand Cmd = CreatCmd(procName, prams);
SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
return Dr;

}
public static SqlDataReader RunProcGetReader(string procName, SqlParameter[] prams, SqlConnection Conn)
{
SqlCommand Cmd = CreatCmd(procName, prams,Conn);
SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
return Dr;
}
public static SqlDataReader RunProcGetReader(string procName, SqlConnection Conn)
{
SqlCommand Cmd = CreatCmd(procName,Conn); 这行提示错误。这行提示错误
SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
return Dr;
}
public static SqlDataReader RunProcGetReader(string procName)
{
SqlCommand Cmd = CreatCmd(procName);
SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
return Dr;
}
public static DataTable RunProcGetTable(string procName, SqlParameter[] prams, SqlConnection Conn)
{
SqlCommand Cmd = CreatCmd(procName, prams,Conn);
SqlDataAdapter Dtr = new SqlDataAdapter();
DataSet Ds = new DataSet();
Dtr.SelectCommand = Cmd;
Dtr.Fill(Ds);
DataTable Dt = Ds.Tables[0];
Conn.Close();
return Dt;

[huangfuhua]

haha

[likevs]

啊，我晕，这么多代码！

楼主，自己写代码容易出错，用VS的智能感知功能吧，


///
///在这里注解这个函数的作用
///
public static SqlDataReader RunProcGetReader(string procName,SqlParameter[] prams)
{
SqlCommand Cmd = CreatCmd(procName, prams);
SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
return Dr;

}

这样每次引用时，就写入第一个字母，然后选择就得了，不会出错，看你上面，有些明明写对了，中间就出错，编程也太不细心了。

[sunshine_anycall]

直接换用Typed DataSet好了
哪里用的着这么麻烦啊？