CommandType.Text

CommandType.Text代表执行的是SQL语句CommandType.StoreProcedure代表执行的是存储过程CommandType代表要执行的类型

//返回DataTable的SQL执行 public DataTable ExecuteDataTable(string cmdText) { DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(connStr); SqlDataAdapter apt = new SqlDataAdapter(cmdText, conn); apt.SelectCommand.CommandType = CommandType.Text; try { apt.Fill(dt); } catch (Exception exp) { throw exp; } finally { if (conn.State == ConnectionState.Open) conn.Close(); } return dt; }

转载于:https://www.cnblogs.com/ZkbFighting/p/7867834.html

相关资源：数据结构—成绩单生成器