cn = new SqlConnection(strConnection);
cn.Open();
SqlTransaction tran = conn.BeginTransaction("insert a row");
SqlCommand command = new SqlCommand(strSql, cn);
command.Parameters.Add(new SqlParameter("StaionID", txtStationID.Text));
command.Parameters.Add(new SqlParameter("StationName", txtStationName.Text));
command.ExecuteNonQuery();
command.Parameters.Clear();
command.Dispose();
tran.Commit();
cn.Close();
cn.Dispose();