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