Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.OleDb
Imports Microsoft.Data.Odbc
Imports System.IO Dim ODBC_ConString As OdbcConnection
Dim ODBC_Command As OdbcCommand
Dim ODBC_DA As OdbcDataAdapter Temp = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + Server.MapPath(".") + "/dbf" + ";Exclusive=No;"
ODBC_ConString = New OdbcConnection(Temp) ODBC_ConString.Open()
ODBC_DA.Fill(Ds, SourceTableName)
Data_Dv = Ds.Tables(SourceTableName).DefaultView
Imports System.Data.SqlClient
Imports System.Data.OleDb
Imports Microsoft.Data.Odbc
Imports System.IO Dim ODBC_ConString As OdbcConnection
Dim ODBC_Command As OdbcCommand
Dim ODBC_DA As OdbcDataAdapter Temp = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + Server.MapPath(".") + "/dbf" + ";Exclusive=No;"
ODBC_ConString = New OdbcConnection(Temp) ODBC_ConString.Open()
ODBC_DA.Fill(Ds, SourceTableName)
Data_Dv = Ds.Tables(SourceTableName).DefaultView
解决方案 »
- 我想请问一个关于事件无法调用的问题
- check问题------ 为什么点击关闭按钮也check!
- 判断页面请求原始URL的问题
- TreeView1.Nodes.Count的值为1...这是为什么.在树里面..我远远不值一个节点啊..
- 怎么ValidationSummary的错误信息显示不出来 ?
- 用<a>标记通过单击实现跳转,并把session["user"]的值改为空
- 请问HttpContext有什么用?如何用?有没有例子?
- vs2005编译器的调试菜单里面少了好多东西!
- asp.net中如何共享asp中的session!
- 能不能自已写个WEB控件支持数据绑定?哪多好!哪位高手指点一下! 谢谢!!!
- 斑竹,高手使用过ODBC.NET的数据提供接口吗?它的连接字符串是怎么写的?
- 菜鸟问题。我用Visual Studio .NET做好了一个ASP.NET的网站,可是发到服务器上确不能运行?
Dim oODBCConnection As Odbc.OdbcConnection
Dim sConnString As String = _
"Driver={SQL Server};" & _
"Server=MySQLServerName;" & _
"Database=MyDatabaseName;" & _
"Uid=MyUsername;" & _
"Pwd=MyPassword"
oODBCConnection = New Odbc.OdbcConnection(sConnString)
oODBCConnection.Open()
For Oracle ODBC Driver' VB.NET
Dim oODBCConnection As Odbc.OdbcConnection
Dim sConnString As String = _
"Driver={Microsoft ODBC for Oracle};" & _
"Server=OracleServer.world;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
oODBCConnection = New Odbc.OdbcConnection(sConnString)
oODBCConnection.Open()
For Access (JET) ODBC Driver' VB.NET
Dim oODBCConnection As Odbc.OdbcConnection
Dim sConnString As String = _
"Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=c:\somepath\mydb.mdb;" & _
"Uid=Admin;" & _
"Pwd="
oODBCConnection = New Odbc.OdbcConnection(sConnString)
oODBCConnection.Open()
For Sybase System 11 ODBC Driver // C#
string myConnStr = "Driver={Sybase System 11};" +
"SRVR=mySybaseServerName;" +
"DB=myDatabaseName;" +
"UID=myUsername;" +
"PWD=myPassword";
OdbcConnection myConnection = new OdbcConnection(myConnStr);
myConnection.Open();
For all other ODBC Drivers' VB.NET
Dim oODBCConnection As Odbc.OdbcConnection
Dim sConnString As String = "Dsn=myDsn;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
oODBCConnection = New Odbc.OdbcConnection(sConnString)
oODBCConnection.Open()