DB2 V9.7 for Linux, UNIX, and Windows
DB2 V9.7 for Linux, UNIX, and Windows
将 CommandText 发送至 Connection 并根据 DB2CursorType 构建 DB2ResultSet。
[Visual Basic]
Public Function ExecuteResultSet( _
cursorType As DB2CursorType _
) As DB2ResultSet
[C#]
public DB2ResultSet
ExecuteResultSet(
DB2CursorType cursorType
);
[C++]
public: DB2ResultSet
* ExecuteResultSet(
DB2CursorType cursorType
);
[JScript]
public function ExecuteResultSet(
cursorType : DB2CursorType
) : DB2ResultSet
;DB2ResultSet 实例。
[C#] 以下示例演示如何从可滚动 DB2ResultSet 中读取数据。
[C#]
public static string getSalesData(DB2Connection conn)
{
string salesQuery = "SELECT * FROM SALES";
string salesData = "";
DB2Command cmd = new DB2Command(salesQuery, conn);
DB2ResultSet salesRS = cmd.ExecuteResultSet(
DB2CursorType.Keyset);
if (salesRS.Scrollable)
{
if (salesRS.ReadLast())
{
salesData = salesRS.GetDB2Date(0).ToString();
salesData += ", " + salesRS.GetDB2String(1).ToString();
salesData += ", " + salesRS.GetDB2String(2).ToString();
salesData += ", " + salesRS.GetDB2Int32(3).ToString();
}
}
return salesData;
}