public static DataTable ExcuteTable(string sqlstr) { MyCatConnection conn = null; try { conn = OpenConn(); var cmd = conn.CreateCommand(); cmd.CommandTimeout = 0; cmd.CommandText = sqlstr; cmd.CommandType = CommandType.Text; MyCatDataAdapter da = new MyCatDataAdapter(); da.SelectCommand = cmd; var reader = cmd.ExecuteReader(); CloseConn(conn); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } catch (Exception ex) { // Console.WriteLine(ex.Message); DataTable dt = new DataTable(); return(dt); } finally { CloseConn(conn); } }
public static DataTable ExcuteTable(string sqlstr, MyCatParameter[] parameters) { MyCatConnection conn = null; try { conn = OpenConn(); var cmd = conn.CreateCommand(); cmd.CommandTimeout = 0; cmd.CommandText = sqlstr; cmd.CommandType = CommandType.Text; cmd.Parameters.AddRange(parameters); MyCatDataAdapter da = new MyCatDataAdapter(); da.SelectCommand = cmd; var reader = cmd.ExecuteReader(); // int execute = cmd.ExecuteNonQuery(); CloseConn(conn); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } catch (Exception ex) { DataTable dt = new DataTable(); return(dt); } finally { CloseConn(conn); } }
/// <summary> /// 执行查询语句,返回DataSet /// </summary> /// <param name="SQLString">查询语句</param> /// <returns>DataSet</returns> public static DataSet Query(string SQLString) { using (MyCatConnection connection = new MyCatConnection(ConfigurationManager.AppSettings["PersonCenterConnectionString"])) { DataSet ds = new DataSet(); connection.Open(); MyCatDataAdapter command = new MyCatDataAdapter(SQLString, connection); command.Fill(ds); connection.Close(); return(ds); } }
public static DataTable ExcuteTable(string sqlstr) { MyCatConnection conn = null; try { /* * cmd.CommandTimeout = 180; * * cmd.CommandText = sql; * DataSet dataset = new DataSet(); * SqlDataAdapter adapter = new SqlDataAdapter(cmd); * adapter.Fill(dataset); * return dataset.Tables[0]; */ conn = OpenConn(); var cmd = conn.CreateCommand(); cmd.CommandTimeout = 180; cmd.CommandText = sqlstr; cmd.CommandType = CommandType.Text; DataSet dataset = new DataSet(); MyCatDataAdapter da = new MyCatDataAdapter(); da.SelectCommand = cmd; // var reader = cmd.ExecuteReader(); // DataTable dt = new DataTable(); // da.Fill(dt); // CloseConn(conn); da.Fill(dataset); return(dataset.Tables[0]); // return dt; } catch (Exception ex) { // Console.WriteLine(ex.Message); DataTable dt = new DataTable(); return(dt); } finally { CloseConn(conn); } }