C#

public class CustomerClass
    {
      SqlConnection con = new SqlConnection("server=(local);database=Tailor;integrated security=true;");
      SqlDataAdapter da = new SqlDataAdapter();
      DataSet ds = new DataSet();
      public CustomerClass()
        {
            
        }
        public  object selectCustomers()
        {
            con.Open();
            
            SqlCommand select = new SqlCommand("select * from Customers",con);
            select.ExecuteNonQuery();
            con.Close();
            da.SelectCommand = select;
            da.Fill(ds, "Customer");
            return ds.Tables;
        }
    }

CustomerClass test=new CustomerClass();
            object test2 = test.selectCustomers();
            dataGridView1.DataSource = test2;

string strSQLconnection = "Data Source=dbServer;Initial Catalog=testDB;Integrated Security=True";
SqlConnection sqlConnection = new SqlConnection(strSQLconnection);
SqlCommand sqlCommand = new SqlCommand("select * from mytable", sqlConnection);

sqlConnection.Open();
SqlDataReader reader = sqlCommand.ExecuteReader();

GridView1.DataSource = reader;
GridView1.DataBind();

([0-9]{4})-([1-9]|[1][0-2])

([0-9]{4})-(0?[1-9]|[1][0-2])

OriginalGriff wrote:

(0?[1-9]|[1][0-2])

Xarzu wrote:

Is the .csproj file or the .sln file part of the code pushed to the server when you publish?

Richard Deeming wrote:

If it's a class library called from within the web site, the code you've posted should work. If it's a stand-alone application, it will need its own configuration file.