在VB.NET中相当于MoveNext [英] Equivalent of MoveNext in VB.NET
问题描述
由于Recordset.MoveNext函数在VB.NET(在互联网上大量搜索)中不再可用,因此我想找到一种解决问题的方法。
(使用MSSQL,刚才看到了movenext函数,而SQLDATASET不支持该函数。)
我想使用类似MoveNext函数的功能,并立即在数据库中进行更改。而且,在进行更改之后,它也应该立即反映到数据库中。.
正如我所说,我在互联网上进行了大量搜索,现在我很困惑使用什么...
以下我在Internet上获得的选项
1)使用SQLDataset并与其一起使用SQLDataAdapter
问题:-我每次都必须更新数据集,因为我想即时
2)使用DataReader,类似于 while rdr.read()(很多人建议这样做) 。)
问题:-但我也想在数据库中进行更新,而读取器只需读取数据库即可。如果我将dataAdapter与此一起使用来更新数据库,则它将保持连接打开一段时间。 / p>
3)我在某处看到了一些Data bindingNavigator函数,但无法获取。如果此选项是不错的选择,请在评论中添加链接...
请尽可能建议其他选择...
注意:-这个问题有点像讨论类型(但不是讨论),也许是不允许的,但这可能对我有帮助...。如果它的问题不合适,那么在得到一些好的建议后,我会ll close it ...
预先感谢...
在用户界面中,您可以使用
As Recordset.MoveNext function is no longer available in VB.NET(searched alot on internet), I want a way to solve my problem..
(Using MSSQL, just seen movenext function somewhere which is not supported with SQLDATASET.)
I want to use something which work like MoveNext function and make the changes in the database instantly. Moreover after changes made, it should also reflect into database instantly..
As I said, I searched alot on internet, I am now confused what to use...
The following options I got on Internet
1)Using SQLDataset and use SQLDataAdapter with it
Problem :- I have to update the dataset everytime because I want instant change in main database as it change in dataset.
2)Using DataReader, something like while rdr.read()(many people suggested this.)
Problem :- But I also want to update in database and reader just read the database.. If I use dataAdapter along with this to update database then it'll keep the connection open for sometime.
3) Some Data bindingNavigator function I seen somewhere but can't get it. If this option is good option then please add a link in comment plz...
Please suggest any other option if possible...
Note:- The question is somewhat discussion type (but its not discussion) which is not allowed maybe but it might help me.... If its not appropriate question then after getting some good suggestions, I'll close it...
Thanx in advance...
In UI, you can use BindingNavigator
. In code, you can use BindingSource.MoveNext()
or change this.BindingContext[datasource].Position
.
OP: Some Data bindingNavigator function I seen somewhere but can't get it. If this option is good option then please add a link in comment plz...
As a quick start to create a data application:
- Show Data Source Window from menu View
>
Other Windows>
Data Sources or by using its shortcut Shift+Alt+D. - Create a new DataSet with the Data Source Configuration Wizard. In the wizard, choose Database as data source type, and follow the wizard, connect to database and select table(s) which you want to use.
After creating the DataSet, Open a form, then go to Data Source Window and Set the Control to be created when dragging from the Data Sources Window. If you choose details mode in Data Source Window, for each field of table a control will be placed on the form. If you choose DataGridView mode,
DataGridView
will be placed on the form.Then drag a table name and drop it on the form. Some controls and some codes will be added to the form. You can run the form and it loads data and you can navigate between records using
BindingNavigator
or change data and at last save changes by click on save button.
Note:
It shows data because the designer generated some codes to fill datasets by using TableAdapters.
It saves data becase the designer generated some codes to save data back to the database
It uses a
BindingNavigator
to navigate between records and show buttons for add, remove and save.It uses a
BindingSource
control to to simplify the process of binding controls to an underlying data source. The component has methods and properties for sorting, filtering and navigation.It uses a
DataSet
as a complete set of data including the tables that contain, order, and constrain the data, as well as the relationships between the tables.
这篇关于在VB.NET中相当于MoveNext的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!