存储过程带参数和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(); }
人各有命,上天注定,有人天生为王,有人落草为寇。脚下的路,如果不是你自己的选择,那么旅程的终点在哪,也没人知道。你会走到哪,会遇到谁,都不一定。