痞客興的部落格

string cs = System.Configuration.ConfigurationManager.ConnectionStrings["transferConnectionString"].ConnectionString;

//上面這行是在Web.config中有 <add name="transferConnectionString" connectionString="Data Source=127.0.0.1;Initial Catalog=transfer;User ID=username;Password=yourpassword"
            providerName="System.Data.SqlClient" />

//如果要直接寫在程式中,可以改為 string cs = "server=127.0.0.1;database=yourDBname;User ID=username;Password=yourpassword;"
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand("INSERT INTO ticketlist(intime,ticket) VALUES('aaa','bbb')", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();

如果要嚴謹一點,就加上try cacth

try
{
  con.Open();
  cmd.ExecuteNonQuery();
}
catch(SqlException ex)
{
  Console.WriteLine(ex.Message); 
}
finally
{
  con.Close();
}