使用什么而不是SQLDataAdapter？ [英] What to use instead of SQLDataAdapter?
问题描述
我们没有使用与SQL Server的连接，因此当我尝试分页时，使用SQL DataAdapter执行此操作的简单方法不起作用。是否有替代方案，例如ODBCDatatAdapter？我查看了可用的对象，找不到任何类似的和ODBC连接（我们使用在COBOl中编写的RPC连接到DB2数据库并创建类模块以连接到CICS区域......它不漂亮）有没有人建议更换DataAdapter？ TIA ...
Coleen
---
发表于使用Wimdows.net NntpNews组件 - 来自于.NET最大的社区网站： http://www.dotnetjunkies.com/newsgroups/
We don''t use a connection to a SQL Server, and therefore when I try paging, the simple way to do it using a SQL DataAdapter does not work. Is there an alternative for this, such as for an ODBCDatatAdapter? I looked through the available Objects and could not find anything similar for and ODBC Connection (we connect to a DB2 database using RPC''s written in COBOl and create Class modules to connect to the CICS region...it is not pretty) Does anyone have any suggestions for a replacement for the DataAdapter? TIA...
Coleen
---
Posted using Wimdows.net NntpNews Component - Posted from .NET''s Largest Community Website: http://www.dotnetjunkies.com/newsgroups/
推荐答案
您使用的服务器是什么？
< coleenholley>在消息中写道
新闻：uF ************** @ TK2MSFTNGP12.phx.gbl ...
What server are you using?
<coleenholley> wrote in message
news:uF**************@TK2MSFTNGP12.phx.gbl...
我们不是使用与SQL Server的连接，因此当我尝试
分页时，使用SQL DataAdapter执行此操作的简单方法不起作用。
有替代方案，例如ODBCDatatAdapter吗？我通过可用的对象看了
，找不到任何类似的东西和
ODBC连接（我们使用在COBOl中编写的RPC连接到DB2数据库
并创建连接到CICS区域的类模块......它不是很漂亮）
有没有人有任何替换DataAdapter的建议？
TIA ...
Coleen
---
发布使用Wimdows.net NntpNews组件 - 发布于.NET的最大
We don''t use a connection to a SQL Server, and therefore when I try paging, the simple way to do it using a SQL DataAdapter does not work. Is
there an alternative for this, such as for an ODBCDatatAdapter? I looked
through the available Objects and could not find anything similar for and
ODBC Connection (we connect to a DB2 database using RPC''s written in COBOl
and create Class modules to connect to the CICS region...it is not pretty)
Does anyone have any suggestions for a replacement for the DataAdapter?
TIA...
Coleen
---
Posted using Wimdows.net NntpNews Component - Posted from .NET''s Largest
社区网站： http://www.dotnetjunkies.com/newsgroups/
我们连接到大型机而不是特定服务器。我们使用CICS建立连接。不幸的是，我不太了解连接过程，除了要连接的类模块中的代码是UGLY！我没有写它，我不理解写的大部分内容，所以尝试解决分页错误确实是一个困难的过程。基本上，If Not Page.IsPostBack似乎对我们不起作用...每次选择页码时都返回相同的数据集，然后在切换页面后，一切都消失了 - 没有数据网格，没有标签什么都没有......很奇怪！任何帮助表示赞赏:-) Coleen
---
发表于使用Wimdows.net NntpNews组件 - 发布于.NET最大的社区网站： http://www.dotnetjunkies.com/newsgroups/
We connect to a Mainframe not a particular server. We use CICS to establish the connection. Unfortunately, I don''t know that much about the connection process, except that the code in the Class Modules to connect is UGLY! I didn''t write it, and I don''t understand most of what was written, so it''s really a difficult process to try and troubleshoot the paging errors. Basically, the If Not Page.IsPostBack doesn''t seem to work for us...the same set of data is returned each time you select a page number, then after switching through the pages, everything disappears - no datagrid, no labels, nothing...weird! Any help is appreciated :-) Coleen
---
Posted using Wimdows.net NntpNews Component - Posted from .NET''s Largest Community Website: http://www.dotnetjunkies.com/newsgroups/
如果你没有连接到SQL Server，那么你不应该使用SQLClient命名空间中的任何一个类，而是使用OLEDB中的类
命名空间。然后你可以使用OLEDB.DataAdapter。
< coleenholley>在消息中写道
新闻：uF ************** @ TK2MSFTNGP12.phx.gbl ...
If you are not connecting to SQL Server, then you should not be using any of
the classes in the SQLClient namespace, instead use the classes in the OLEDB
namespace. You could then use the OLEDB.DataAdapter.
<coleenholley> wrote in message
news:uF**************@TK2MSFTNGP12.phx.gbl...
我们不是使用与SQL Server的连接，因此当我尝试
分页时，使用SQL DataAdapter执行此操作的简单方法不起作用。
有替代方案，例如ODBCDatatAdapter吗？我通过可用的对象看了
，找不到任何类似的东西和
ODBC连接（我们使用在COBOl中编写的RPC连接到DB2数据库
并创建连接到CICS区域的类模块......它不是很漂亮）
有没有人有任何替换DataAdapter的建议？
TIA ...
Coleen
---
发布使用Wimdows.net NntpNews组件 - 发布于.NET的最大
We don''t use a connection to a SQL Server, and therefore when I try paging, the simple way to do it using a SQL DataAdapter does not work. Is
there an alternative for this, such as for an ODBCDatatAdapter? I looked
through the available Objects and could not find anything similar for and
ODBC Connection (we connect to a DB2 database using RPC''s written in COBOl
and create Class modules to connect to the CICS region...it is not pretty)
Does anyone have any suggestions for a replacement for the DataAdapter?
TIA...
Coleen
---
Posted using Wimdows.net NntpNews Component - Posted from .NET''s Largest
社区网站： http://www.dotnetjunkies.com/newsgroups/
这篇关于使用什么而不是SQLDataAdapter？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
