This is VERY fragile code.  
Make it far more robust when you use it in your own application.


using System.Data.SqlClient;
.
.
.

string connectionStr = "server=mssql1.myregisteredsite.com; database=jbond; user id=jbond; password=@bl75$WL";
SqlConnection conn = new SqlConnection(connectionStr);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Insert into Test (tn) values ('Alan')";
cmd.Connection = conn;
cmd.ExecuteNonQuery();