Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

aylal899431
Level 1
Level 1

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?

2 Replies
KelvinSmith
Level 1
Level 1

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

aylal899431
Level 1
Level 1

ahaa ok I'll try and I hope it works 🙂