hi :)
today´s my first day in C#
i need some help, why i can´t compile de following code, im using the line:
csc /t:library /r:System.Data.dll /out:connect_base.dll connect_base.cs

thanks

using System;
using System.Data;
using System.Data.SqlClient;


public class Listaserv
{
    public DataSet Listatel()
    {

        SQLConnection objconn = new SQLConnection("server=localhost;uid=sa;pwd=;databa se=pubs");
        SQLDataSetCommand objcomm = new SQLDataSetCommand("SELECT au_fname,au_lname,phone FROM Authors", objconn);
        DataSet objds = new DataSet();
        objcomm.FillDataSet(objds, "dsvListatel");
        return objds;
    }
}

Hi,

You need to add /r:System.dll in your csc command paramaters to compile your class, since you are using the System namespace. Something like this:

csc /t:library /r:System.dll /r:System.Data.dll /out:connect_base.dll connect_base.cs

Cheers!


Marlon Villarama
Support Team
Web Burner Hosting
marlon@webburner.com
www.webburner.com
Toll-Free: 877-535-2876

hi...
thank you...
the correct to connect is:
i was using classes tha does not belong to the System.Data.SqlClient,
ande also using SQLConnection when the corretc is SqlConnection.
well, at least i compiled :)

using System;
using System.Data;
using System.Data.SqlClient;





    public class Listaserv
    {
        public DataSet Listatel()
        {
            SqlConnection conn = new SqlConnection("server=localhost;uid=sa;pwd=;databa se=pubs");
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = new SqlCommand("SELECT au_fname,au_lname,phone FROM Authors", conn);
            DataSet objds = new DataSet();
            adapter.Fill(objds);
            return objds;

        }
    }