Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can not use ado.net
Message
 
À
16/08/2001 06:25:47
Shailendra Kumar
Soccer International Limited
Jalandhar, Inde
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Divers
Thread ID:
00544580
Message ID:
00545767
Vues:
14
Which version of the Beta are you using? There were many changes from Beta1 to Beta2. I don't see where you are creating a DataAdaptor anywhere in your code.

Here is some code I use to test my ADO.NET connection in Beta2 using C#. Careful with line wrap. Tags have been removed in order to post.
@ Page Language="C#" 
@ Import Namespace="System.Data" 
@ Import Namespace="System.Data.SqlClient"

Response.Write("Test ADO.NET<br>");
Response.Write(System.DateTime.Now); 
Response.Write("<br>");

SqlConnection sobeConn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;" +
"Initial Catalog=Sobe");
sobeConn.Open();
SqlDataAdapter sobeDA = new SqlDataAdapter("SELECT * FROM Links", sobeConn);

    try
    {
      DataSet sobeDS = new DataSet();
      sobeDA.Fill(sobeDS,"Links");

      foreach (DataRow myDataRow in sobeDS.Tables["Links"].Rows)
      {
        Response.Write(myDataRow["Lnk_href"].ToString());
        Response.Write("<br>");
      }
    }
    catch(Exception e)
    {
      Response.Write(e.ToString());
    }
>Hi dude...
>
>
>I am facing problrm while using ado.net it says:
>--------------------------------------------------------
>Compilation Error
>Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
>
>Compiler Error Message: BC30389: 'System.Data.SqlClient.SQL' is Private, and is not accessible in this context.
>
>Source Error:
>
>
>
>Line 18: MyConnection = New SqlConnection("server=(local);database=test;Trusted_Connection=yes")
>Line 19: MyConnection.Open()
>Line 20: sql="select * from employee"
>Line 21: cmd=new SqlCommand(sql,MyConnection)
>Line 22: cmd.execute(rd)
>-------------------------------------------------------
>
>
>Also my web server does not shows the appropiate erros on remote machines, though I have changed the config.web file ....
>
>
>waiting ....
>
>shail
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform