Command type命今类型:一航为StoredProcedure(存储过程)和text(文本).
例如1:ds = SqlHelper.ExecuteDataset(connection, CommandType.StoredProcedure, "sp_Type_AllList");
connection:数据库连接
CommandType.StoredProcedure:命令类型为存储过程.
sp_Type_AllList:存储过程名称
例如2:ds = SqlHelper.ExecuteDataset(connection, CommandType.text, "strsql");
connection:数据库连接
CommandType.text:命令类型为SQL语名.
strsql:SQL语句如"select * from table1 "或"instert into ....."
例如1:ds = SqlHelper.ExecuteDataset(connection, CommandType.StoredProcedure, "sp_Type_AllList");
connection:数据库连接
CommandType.StoredProcedure:命令类型为存储过程.
sp_Type_AllList:存储过程名称
例如2:ds = SqlHelper.ExecuteDataset(connection, CommandType.text, "strsql");
connection:数据库连接
CommandType.text:命令类型为SQL语名.
strsql:SQL语句如"select * from table1 "或"instert into ....."