[SOLVED] how can open database in asp.net

jha · #1 (**permalink**) 06-25-08, 05:55 AM

how can open database and display records in asp.net

Nico · #2 (**permalink**) 06-25-08, 05:58 AM

http://www.w3schools.com/aspnet/aspnet_dbconnection.asp

digioz · #3 (**permalink**) 06-25-08, 08:51 AM

What's your database? If MS Access, the sample Nico provided works. For SQL Server you have to use SQLClient.

Pete

jha · #4 (**permalink**) 06-26-08, 03:52 AM

No i wants to work with oracle database, i am using code below thats gives error
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
ERROR [01S00] [Microsoft][ODBC driver for Oracle]Invalid connection string attribute

Code:

<script runat="server">

    Sub submit(sender As Object, e As EventArgs)
    dim dbconn,sql,dbcomm,dbread
    dbconn=New odbcConnection("dsn=Oracle;UserId=starter;Password=starter; " )
    dbconn.Open()
    sql="SELECT * FROM students"
    dbcomm=New odbcCommand(sql,dbconn)
    dbread=dbcomm.ExecuteReader()
    customers.DataSource=dbread
    customers.DataBind()
    dbread.Close()
    dbconn.Close()
    End Sub

</script>

digioz · #5 (**permalink**) 06-26-08, 12:13 PM

Your connection string should be something like this (change "ServerName" with your server name):

Code:

Driver={Microsoft ODBC for Oracle};Server=ServerName;Uid=starter;Pwd=starter;

This is assuming that you have done the following first:

1. Install Oracle client
2. Configure TNS Names to connect to Oracle database through oracle client
3. Go to start> settings> control panel> administrator tools> ODBC connections - add a new ODBC connection using oracle driver
4. Use the connection string above.

What version of Oracle are you using?

Pete

jha · #6 (**permalink**) 06-26-08, 11:48 PM

I am using oracle 8
this code is now open database without error

Code:

<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ import Namespace="System.Data.ODbc" %>
<%@ Import Namespace=" System.Data"%>
<script runat="server">
sub Page_Load(sender as Object, e as EventArgs)
     Dim strConnectionString As String
        strConnectionString = "Dsn=oracle;uid=starter;pwd=starter"
        Dim pConn As New OdbcConnection(strConnectionString)
        Dim pSELECTQUERY As String = "SELECT  *from test"
        Dim adapter As New OdbcDataAdapter(pSELECTQUERY, pConn)
        Dim DS As DataSet = New DataSet()
        adapter.Fill(DS)
		pConn.Close()
        adapter.Dispose()
    End Sub
</script>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
</head>
<body>
    <form runat="server">

    </form>
</body>
</html>

but how can display the data store in adapter please help me out

jha · #7 (**permalink**) 06-27-08, 04:06 AM

Thanks for your kind supports problems are now solved my full code is

Code:

<%@ Page Language="VB" %>
<%@ import Namespace="System.Data.ODbc" %>
<%@ Import Namespace=" System.Data"%>
<script runat="server">
sub Page_Load(sender as Object, e as EventArgs)
     Dim strConnectionString As String
        strConnectionString = "Dsn=oracle;uid=starter;pwd=starter"
        Dim pConn As New OdbcConnection(strConnectionString)
        Dim pSELECTQUERY As String = "SELECT  *from students"
        Dim adapter As New OdbcDataAdapter(pSELECTQUERY, pConn)
        Dim DS As DataSet = New DataSet()
        adapter.Fill(DS)
         Repeater1.DataSource = ds
        pConn.Close()
        adapter.Dispose()
        Repeater1.DataBind()
    End Sub
</script>
<html>
<head>
</head>
<body>
    <form runat="server">
        <asp:Repeater id="repeater1" runat="server">
            <HeaderTemplate>
                <table border="1" width="60%">
                    <tr bgcolor="#CCFF00">
                        <th>
                            ID</th>
                        <th>
                            Major</th>
                        <th>
                            First Name</th>
                        <th>
                            Last Name</th>
                    </tr>
            </HeaderTemplate>
            <ItemTemplate>
                <tr bgcolor="#CCFFCC">
                    <th>
                        <%#Container.DataItem("id")%></th>
                    <th>
                        <%#Container.DataItem("major")%></th>
                    <th>
                        <%#Container.DataItem("first_name")%> 
                    </th>
                    <th>
                        <%#Container.DataItem("last_name")%> 
                    </th>
                </tr>
            </ItemTemplate>
            <AlternatingItemTemplate>
                <tr bgcolor="#CCFFFF">
                    <th>
                        <%#Container.DataItem("id")%></th>
                    <th>
                        <%#Container.DataItem("major")%></th>
                    <th>
                        <%#Container.DataItem("first_name")%> 
                    </th>
                    <th>
                        <%#Container.DataItem("last_name")%> 
                    </th>
                </tr>
            </AlternatingItemTemplate>
            <FooterTemplate>
                </table>
            </FooterTemplate>
        </asp:Repeater>
    </form>
</body>
</html>

i try to know whats parts of code should be write in .vb part and .aspx part
thanks