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