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(); }