Dim myDataset As New DataSet
Dim myOleDbConnection As OleDbConnection = New OleDbConnection("Provider=vfpoledb.1;Data Source=" & dpath & ";Password=MyPassWord;Collating Sequence=general")
Dim myOleDbCommand As OleDbCommand = New OleDbCommand("SELECT * FROM [" & filename & "]", myOleDbConnection)
Dim myData As OleDbDataAdapter = New OleDbDataAdapter(myOleDbCommand)
myData.Fill(myDataset)
在这之前要安装VFPOLEDB的驱动
Dim myOleDbConnection As OleDbConnection = New OleDbConnection("Provider=vfpoledb.1;Data Source=" & dpath & ";Password=MyPassWord;Collating Sequence=general")
Dim myOleDbCommand As OleDbCommand = New OleDbCommand("SELECT * FROM [" & filename & "]", myOleDbConnection)
Dim myData As OleDbDataAdapter = New OleDbDataAdapter(myOleDbCommand)
myData.Fill(myDataset)
在这之前要安装VFPOLEDB的驱动
解决方案 »
- 请问一下怎么把Repeater里面的按钮禁用啊???
- 是不是ajax的 TabContainer 在点击切还TAB的时候点一次会引发两次Changed???
- asp.net MVC 路由问题
- 调用reporting Service的问题
- 在gridview中配置数据源
- SqlConnection
- 自己写了一个简单的图表控件,目前只实现了线状显示。有兴趣的朋友可以看看。顺便给点意见。
- 找到女朋友了,,给分,,只给第一个
- 由按钮连接到其他的网页!
- 讨论一下.net中多线程的处理,大家有经验之谈吗?200分,支持的有分!
- 急! DBF数据库转换问题
- DataGrid的DataKeyField能不能设置多列,因为我的主键有多个属性,谢谢
create table 新库1
(名称 char(20),
数量 char(10),
)
insert
into 新库1
select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;
SourceDB=d:\开封市;
SourceType=DBF',
'select distname,x1 from xfj12 where bh= "01"')create table 新库2
(名称 char(20),
数量 char(10),
)
insert
into 新库2
select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;
SourceDB=d:\开封市;
SourceType=DBF',
'select distname,x1 from xfj12 where bh= "02"')create table 新库3
(名称 char(20),
数量 char(10),
)
insert
into 新库3
select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;
SourceDB=d:\开封市;
SourceType=DBF',
'select distname,x1 from xfj21 where bh= "01"')create table 新库4
(名称 char(20),
数量 char(10),
)
insert
into 新库4
select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;
SourceDB=d:\开封市;
SourceType=DBF',
'select distname,x1 from xfj32 where bh= "01"')