//请问这里的 params IDataParameter[] parameters如何解释
public object GetProcScalar(string storedProcName, params IDataParameter[] parameters)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
object result;
connection.Open();
SqlCommand command = BuildQueryCommand(connection, storedProcName, parameters);
command.CommandTimeout = comTime;
result = command.ExecuteScalar();
return result;
}
} private void con(DbConnection connection)
{
这里是否可以这样转换类型
OracleConnection connection=(OracleConnection)connection; SqlConnection connection=(SqlConnection)connection;
}
//请问这里的 params IDataParameter[] parameters如何解释//这个是参数数组来的,例如:parmater SqlParameter[] parmater = {
new SqlParameter("@XXX1",Value1),
new SqlParameter("@XXX2",Value2)
};
SqlParameter[] param = new SqlParameter[] {
new SqlParameter ("@id",id )
};
SqlDataReader r = DBHelper.getDataReader(strSql, param);
就是把你的参数放在参数数组里面再传到你的方法里面。楼主懂了吗???
public object GetProcScalar(string storedProcName, params IDataParameter[] parameters)
{
}
public object GetProcScalar(string storedProcName,IDataParameter[] parameters)
{
}
一个是可以想string.format("{0}{1}{2}",1,2,3)一样,后面跟若干个参数