我这里有,用odbc连接你下载odbc.net后,看帮助就行了
web.config中添加连接语句
<add key="ConnString" value="Driver={Microsoft ODBC for Oracle};Server=JinHua;PWD=change_on_install;UID=sys" />
public static bool ConnToDB(OdbcConnection OdbcConn)连接函数:
{
if(OdbcConn.State.ToString()=="Open")
return true;
string szConn=System.Configuration.ConfigurationSettings.AppSettings["ConnString"].ToString();
OdbcConn.ConnectionString=szConn; try
{
OdbcConn.Open();
}
catch
{
return false;
}
return true;
}邦顶datagrid很简单,随便找一下就好了
web.config中添加连接语句
<add key="ConnString" value="Driver={Microsoft ODBC for Oracle};Server=JinHua;PWD=change_on_install;UID=sys" />
public static bool ConnToDB(OdbcConnection OdbcConn)连接函数:
{
if(OdbcConn.State.ToString()=="Open")
return true;
string szConn=System.Configuration.ConfigurationSettings.AppSettings["ConnString"].ToString();
OdbcConn.ConnectionString=szConn; try
{
OdbcConn.Open();
}
catch
{
return false;
}
return true;
}邦顶datagrid很简单,随便找一下就好了
.vb页面:
Private objconn As New OleDbConnection("Provider=MSDAORA.1;Password=760715;User ID=pmdb;Data Source=oracle8.zjs")
最简单的是直接从.net环境下,把“服务器资源管理器”中的“数据联接”下的oreOLEDB拖到页面上即可。
'绑定到dropdownlistAllTables
Dim adapter As OleDbDataAdapter = New OleDbDataAdapter("select distinct tablenamec,tablenamee from khpxcxtab", objconn)
objconn.Open()
Dim ds As DataSet = New DataSet()
adapter.Fill(ds, "AllTables")
dropdownlistAllTables.DataSource = ds.Tables("AllTables").DefaultView
dropdownlistAllTables.DataTextField = "tablenamec"
dropdownlistAllTables.DataValueField = "tablenamee"
dropdownlistAllTables.DataBind()
objconn.Close()
dropdownlistAllTables.Items.Add("请选择查询表:")
dropdownlistAllTables.SelectedIndex = dropdownlistAllTables.Items.Count - 1
。。
End If