Hi ,

im very new to c# and am having a very difficult time of it trying to connect a mobile form to a sql database.

when I enter the following code

***********************************

<script runat="server">
    string strConn = "Data Source=DANEEL;Initial Catalog=newpubstest;User ID=newstudentmm;Password=studentmm providerName=System.Data.SqlClient";
    SqlConnection myConnection = new SqlConnection(strConn);
    //create connection string

    //create connection query
    string strSql = "SELECT * FROM authors";
    //create db connection object
 </script>
****************************************

I get this error about by connection object and string

>>Error 1 A field initializer cannot reference the nonstatic field, method, or property 'ASP.default_aspx.strConn' \\sideshowbob1\students\S02090619\My Documents\Visual Studio 2005\WebSites\mobile\mobile_location\Default.aspx 8 52 \\sideshowbob1\students\...\mobile_location
Id really appreciate if somebody could explain this error to me and maybe tell me what Im doing wrong.

Thanks A lot

According to http://msdn2.microsoft.com/en-us/library/5724t6za(vs.80).aspx...

<article segment>
Visual C# Reference: Errors and Warnings
Compiler Error CS0236
Error Message
A field initializer cannot reference the nonstatic field, method, or property 'field'

Instance fields cannot be used to initialize other instance fields outside of a method. If you are attempting to initialize a variable outside of a method, consider performing the initialization inside the class constructor. For more information, see Methods (C# Programming Guide).
</article segment>

Try this...
<script runat="server">
public void main()
{
    string strConn = "Data Source=DANEEL;Initial Catalog=newpubstest;User ID=newstudentmm;Password=studentmm providerName=System.Data.SqlClient";
    System.Data.SqlClient.SqlConnection myConnection = new System.Data.SqlClient.SqlConnection(strConn);
    //create connection string

    //create connection query
    string strSql = "SELECT * FROM authors";
    //create db connection object
}
</script>


Adam Gossage
Lake Wylie, SC, USA

FYI... C# questions need to go to [P2P Forum]\[C# C++]

Adam Gossage
Lake Wylie, SC, USA