Greetings
I have a simple app with a datasource, and I want to make a call to a
stored procedure. So, what I was trying to do was get the connection
string from Settings.settings,
then basically do this:
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into test values ('testdata')";
int rows_affected = cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Dispose();
except in my code I will call my stored procedure, is this the right
thing to do? How do I get the connection string that is stored in
Settings.settings?
thanks
troy