quote:

---

Originally posted by afrika

why not paste some sample code, in .net you put your connection string in you web.config file and your queries are best placed in your classes

---

quote:

---

Originally posted by afrika

your connection string is wrong

see www.connectionstrings.com

---

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Web.Configuration;
using System.ComponentModel;


[DataObject(true)]
public class myclass
{

    [DataObjectMethod(DataObjectMethodType.Select, true)]
    public DataSet myclass_data(string username)
    {
                string ehioze = "select * from yourtable ";
        string ConnectionString = WebConfigurationManager.ConnectionStrings["webconfig_variable"].ConnectionString.ToString();
        using (SqlConnection connection = new SqlConnection(ConnectionString))
        {

            SqlCommand command = connection.CreateCommand();
            command.CommandText = ehioze;
            command.Connection = connection;
            SqlDataAdapter adapter = new SqlDataAdapter(command);
            DataSet categoriesDataSet = new DataSet();
            adapter.Fill(categoriesDataSet);
            return categoriesDataSet;
            /*
             connection.Open();
             SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
             return reader;*/
        }


    }
}