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;
}
posted @ 2017-11-20 19:17  ProZkb  阅读(2804)  评论(0编辑  收藏  举报