存储过程带参数和sqlcommand

 public DataSet SelectBillNo(string CarrierCode, string Date, string CompanyCode)
    {
        System.Collections.ArrayList aryParams = new System.Collections.ArrayList();
        aryParams.Add(CarrierCode);
        aryParams.Add(Date);
        aryParams.Add(CompanyCode);
        return CommonData.ExecuteStoreProcedure("ProcNamne", aryParams);
    }

public static DataSet ExecuteStoreProcedure(string procedureName, ArrayList ary)
    {
        Database db = DatabaseFactory.CreateDatabase(connstring);
        DbConnection conn = db.CreateConnection();
        try
        {
            conn.Open();
            object[] paramsObject = new object[ary.Count];
            for (int i = 0; i < ary.Count; i++)
            {
                paramsObject[i] = ary[i];
            }
            return db.ExecuteDataSet(procedureName, paramsObject);
        }
        finally
        {
            conn.Close();
            conn = null;
        }
    }

 

 public static void ExeQuery1(string Cmd)
    {
        //SqlConnection conn = new SqlConnection(connstring_TMS);
        Database db = DatabaseFactory.CreateDatabase(connstring_TMS);
        SqlConnection conn = (SqlConnection)db.CreateConnection();
        conn.Open();
        SqlCommand cmd = new SqlCommand(Cmd, conn);
        SqlDataReader reader = cmd.ExecuteReader();
        cmd.CommandTimeout = 5000;
        while (reader.Read())
        {
            //reader[1]：读取表中第2列的数据
            string sss = reader[1].ToString();
        }
        reader.Close();
        conn.Close();

    }