Unable to connect to a remote database through ASP. NET ( ASPHostPortal.com Hosting )

[Former Community Member]

I have a ASP.NET website and an hosting account on asphostportal.com.

I created a SQL Server Database with Direct Access and updated the connection string with the one provided by asphostportal

There are no errors, but I see no data being stored in the database on a form submit.

Code to insert a row is as follows:

public int run_sql(string msg)

{

    SqlConnection conn = new SqlConnection();

    SqlCommand cmd = new SqlCommand();

    SqlDataAdapter da = new SqlDataAdapter();

    DataSet ds = new DataSet();

    conn.ConnectionString = connString;

    cmd = conn.CreateCommand();

    cmd.CommandText = msg;

    conn.Open();

    cmd.ExecuteNonQuery();

    conn.Close();

    return 1;

}

What could be the issue?

[Former Community Member]

What I think is we need to open the connection before assigning it to the command. Can you try this code and see whether it works:

public int run_sql(string msg)

{

    SqlConnection conn = new SqlConnection(connString);

    conn.Open();

    SqlCommand cmd = new SqlCommand(msg,conn);

    cmd.ExecuteNonQuery();

    conn.Close();

    return 1;

}

Hope it works.

Regards

[Former Community Member]

ahaa ok I'll try and I hope it works :)